Skip to Main Content
  • Questions

  • Is it possible to install 11G and 12C in Windows 7 64 bit.

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Som.

Asked: January 12, 2017 - 2:27 pm UTC

Last updated: January 13, 2017 - 7:25 am UTC

Version: 11G, 12C

Viewed 1000+ times

You Asked

Hi,

Can you help me to resolve the issue.

Scenario 1: I have 11G 64 bits running fine in Windows 64 bits but When I was trying to install 12C 64 bits in same system,
Its throwing an error while creating database through DBCA. Error is: Error executing: "oracle_home\rdbms\admin\dbmssml.sql"
Error message redirect me to look for log dbmssml0.log, which is completely empty.

Secnario 2: When I am starting my Listener its taking my new Oracle database's installed oracle_home path i.e Oracle 12c's home path
and it totally overshadow the 11g listener.

Thanks,
Shom

and Connor said...

1)

I have both 11.2.0.4 and 12.1.0.2 running on my Win7 laptop, so it definitely can be done. You should always check on MOS to see if its officially supported and certified.

If you're really stuck, look at using DBCA to create scripts, and then step through them.

2)

You only need *one* listener to handle connections to both databases. And generally you would always want that to be the listener of the newer version.

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Both database on Win7

Rajeshwaran, Jeyabal, January 13, 2017 - 11:02 am UTC

Like Connor, i have both my database (11g and 12c) on my Windows 7 - 64 bit OS.

Here is my contents from listener.ora

LISTENER_ORA12C =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1524))
      (ADDRESS = (PROTOCOL = TCP)(HOST = LT035221)(PORT = 1522))
    )
  )

LISTENER_ORA11G =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = LT035221)(PORT = 1521))
    )
  )
  
SID_LIST_LISTENER_ORA12C =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ORA12c)
      (ORACLE_HOME = D:\app\Vnameit\product\12.1.0\dbhome_1)
      (SID_NAME = ORA12c)
    )
  )  
  
SID_LIST_LISTENER_ORA11G =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ORA11G)
      (ORACLE_HOME = D:\app\Vnameit\product\11.2.0\dbhome_1)
      (SID_NAME = ORA11G)
    )
  )


and here is the status of my listener.

C:\Users\179818>lsnrctl

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 13-JAN-2017 16:29:29

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status LISTENER_ORA11G
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_ORA11G
Version                   TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date                13-JAN-2017 16:26:34
Uptime                    0 days 0 hr. 3 min. 2 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:\app\Vnameit\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File         D:\app\Vnameit\diag\tnslsnr\LT035221\listener_ora11g\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LT035221.cts.com)(PORT=1521)))
Services Summary...
Service "ORA11G" has 2 instance(s).
  Instance "ORA11G", status UNKNOWN, has 1 handler(s) for this service...
  Instance "ora11g", status READY, has 1 handler(s) for this service...
Service "ORA11GXDB" has 1 instance(s).
  Instance "ora11g", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> status LISTENER_ORA12C
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1524)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_ORA12C
Version                   TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date                11-JAN-2017 17:30:30
Uptime                    1 days 22 hr. 59 min. 12 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:\app\Vnameit\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File         D:\app\Vnameit\diag\tnslsnr\LT035221\listener_ora12c\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1524ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LT035221.cts.com)(PORT=1522)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=LT035221.cts.com)(PORT=5500))(Security=(my_wallet_directory=D:\APP\VNAMEIT\admin\ORA12C\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "ORA12CXDB" has 1 instance(s).
  Instance "ora12c", status READY, has 1 handler(s) for this service...
Service "ORA12c" has 2 instance(s).
  Instance "ORA12c", status UNKNOWN, has 1 handler(s) for this service...
  Instance "ora12c", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>


using those entries, i am able to connect both these database 

C:\Users\179818>sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 13 16:30:14 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

idle> conn demo/demo@ora11g
Connected.
demo@ORA11G>
demo@ORA11G> conn demo/demo@ora12c
Connected.
demo@ORA12C>

Shom RaZz, March 07, 2017 - 10:09 pm UTC

Thank you....
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.