OraFAQ Forum: Server Administration » Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter error

Home » RDBMS Server » Server Administration » Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter error [message #551068]

Sun, 15 April 2012 07:56

d_seng
Messages: 78
Registered: November 2011
Location: UK

Member

Hi,

I want to install Oracle EE 11gR2 on my Windows 7 Professional 64-bit laptop. Installed memory is 8GB.

I need to install 32-bit server since Oracle Warehouse Builder will not run on a 64-bit o/s. Further, I use Toad 9.7.2 which will only recognise client 32-bit.

I had a few failed attempts, especially when the database was being created with the ORA-12560: TNS:protocol adapter error, so I decided to list the steps and figure out what could have gone wrong at what steps.

So here's what I did:

Changed C:\Windows\System32\drivers\etc\hosts so that it contains two lines 127.0.0.1 localhost & ::1 localhost
Changed properties of setup.exe in the installation directory to be Windows XP SP2 compatible and run as administrator
Selected "install database software only" (so I could figure out at what step the installation fails)
Selected "single instance"
Selected "Enterprise Edition"
Selected oracle base "c:\app" (instead of default location c:\app\d_seng)

Copy of files was completed successfully, log file was created in c:\program files(x86)\oracle\inventory\logs & registry entries were added to "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE" (with keys KEY_OraDb11g_home1, ODP.NET & OracleMTSRecoveryService), and the following services were created:

OracleMTSRecoveryService: Started/Automatic
OracleOraDb11g_home1ClrAgent: Not started/Manual
OracleRemExecService: Started/Disabled

There are no listener.ora & tnsnames.ora yet. Sqlnet.ora is created with the line SQLNET.AUTHENTICATION_SERVICES = (NTS)

Now I went to Start, All Programs, Oracle - OraDb11g_home1, Configuration and Migration Tools, right clicked on "Net Configuration Assistant" and changed the properties to be Windows XP SP2 compatible and run as administrator and ran it. I selected "Listener Configuration", added a listener called LISTENER, TCP protocol, port 1521 and finished. A service called "OracleOraDb11g_home1TNSListener" was created and started in automatic mode. The PATH was updated and listener.ora was created with the lines:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\app\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = DSG-HP6555b)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = C:\app

Tnsnames.ora is also creaed with the contents:

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

At the command prompt, lsnrctl.status shows:

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 15-APR-2012 12:42
:19

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DSG-HP6555b)(PORT=1521))
)
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date                15-APR-2012 12:37:54
Uptime                    0 days 0 hr. 4 min. 27 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\app\product\11.2.0\dbhome_1\network\admin\listener.
ora
Listener Log File         c:\app\diag\tnslsnr\DSG-HP6555b\listener\alert\log.xml

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DSG-HP6555b)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

At the command prompt, lsnrctl.services shows:

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 15-APR-2012 12:43
:15

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DSG-HP6555b)(PORT=1521))
)
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
The command completed successfully

Now I went to start, all programs, Oracle - OraDb11g_home1, Configuration and Migration Tools, right clicked on "Database Configuration Assistant" and changed the properties to be Windows XP SP2 compatible and run as administrator and ran it.

I chose to create a database
General purpose
Global database name ORCL
SID ORCL
Chose "Configure Enterprise Manager" & "Configure Database Control for local management" and disabled "Automatic maintenance tasks"
Used the same password for all accounts
Selected storage type "File System" & "Use Database File Locations from Template"
Unchecked Flash Recovery & Archiving
Selected "Sample Schemas", "Typical" memory size (1228MB), "Use Automatic Memory Management"
Left sizing/character sets/connection mode as default, and
Selected "Generate Database Creation Scripts" in C:\app\admin\ORCL\scripts (if I choose to Create Database, it fails with TNS Protocol Adapter Error).

I now open ORCL.bat in an editor, go to command prompt, create the directories as per the file, set ORACLE_SID=ORCL & path.

Running

C:\app\product\11.2.0\dbhome_1\bin\oradim.exe -new -sid ORCL -startmode manual -spfile

gives a message "instance created" & services "OracleJobSchedulerORCL", "OracleVssWriterORCL" (started) & "OracleServiceORCL" (started) are created.

The next step

C:\app\product\11.2.0\dbhome_1\bin\oradim.exe -edit -sid ORCL -startmode auto -srvcstart

system give an error "Unable to start service, OS Error 1056" (probably implies services already running), nothing is present in the windows alert logs about this. If I stop the service OracleVssWriterORCL, then this command completes, although no messages are returned.

The next step in the batch file starts sqplus /nolog and calls ORCL.sql.

ORCL.sql accepts passwords for sys, system, sysman & dbsnmp. It then executes

host C:\app\product\11.2.0\dbhome_1\bin\orapwd.exe file=C:\app\product\11.2.0\dbhome_1\database\PWDORCL.ora force=y

, which prompts me for the password for sys.

ORCL.sql then calls CloneRmanRestore.sql, which then tries to run

connect "SYS"/"&&sysPassword" as SYSDBA

This is when I get the error ORA-12560: TNS:protocol adapter error, which has been haunting me for days.

My gut feel is that the database creation step at sqlplus is unable to recognise the listener...or probably it does not recognise the modified registry location (with Wow6432Node), the file oracle.key in C:\app\product\11.2.0\dbhome_1\BIN shows the string SOFTWARE\ORACLE\KEY_OraDb11g_home1.

I then changed oracle.key to point to SOFTWARE\Wow6432Node\ORACLE\KEY_OraDb11g_home1, restarted the listener and ORCL service, but connecting as sys returns the same error.

I've been at it for days now and losing the will to live Sad

! Any help much appreciated!

Thanks
Dhruva