Home » RDBMS Server » Server Administration » Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter error
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 Go to next message
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
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551079 is a reply to message #551068] Sun, 15 April 2012 09:20 Go to previous messageGo to next message
John Watson
Messages: 4859
Registered: January 2010
Location: Global Village
Senior Member
Have you set your ORACLE_SID environment variable?
c:\users\john\home>sqlplus sys/oracle as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Apr 15 15:18:31 2012

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

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:
c:\users\john\home>set ORACLE_SID=orcl

c:\users\john\home>sqlplus sys/oracle as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Apr 15 15:18:48 2012

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

orcl>
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551080 is a reply to message #551079] Sun, 15 April 2012 09:25 Go to previous messageGo to next message
BlackSwan
Messages: 23146
Registered: January 2009
Senior Member
>Changed C:\Windows\System32\drivers\etc\hosts so that it contains two lines 127.0.0.1 localhost & ::1 localhost
>Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DSG-HP6555b)(PORT=1521))

how does OS resolve the IP# that is associated with hostname=DSG-HP6555b?
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551084 is a reply to message #551080] Sun, 15 April 2012 10:00 Go to previous messageGo to next message
d_seng
Messages: 78
Registered: November 2011
Location: UK
Member
Quote:
Have you set your ORACLE_SID environment variable?

Yes John I've done that

Quote:
how does OS resolve the IP# that is associated with hostname=DSG-HP6555b?

Ok, pinging DSG-HP6555 resolves the name into IPV6 address. So I added 127.0.0.1 DSG-HP6555b in hosts, restarted listener, but same error occurs.

I changed the listener.ora file to use the IP address, but to no avail.

I'm going to try and copy the contents of the registry from SOFTWARE\Wow6432Node\ORACLE\KEY_OraDb11g_home1 to SOFTWARE\ORACLE\KEY_OraDb11g_home1, probably a shot in the dark.
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551085 is a reply to message #551084] Sun, 15 April 2012 10:04 Go to previous messageGo to next message
BlackSwan
Messages: 23146
Registered: January 2009
Senior Member
what is the IP# (V4) of this system?
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551086 is a reply to message #551085] Sun, 15 April 2012 10:11 Go to previous messageGo to next message
d_seng
Messages: 78
Registered: November 2011
Location: UK
Member
Well, localhost/loopback is 127.0.0.1, DHCP assigned addresses are:
C:\app\admin\ORCL\scripts>IPCONFIG

Windows IP Configuration


Wireless LAN adapter Wireless Network Connection:

   Connection-specific DNS Suffix  . :
   Link-local IPv6 Address . . . . . : fe80::9d9d:5142:d2f6:e161%13
   IPv4 Address. . . . . . . . . . . : 192.168.0.15
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Default Gateway . . . . . . . . . : 192.168.0.1

Ethernet adapter Local Area Connection:

   Connection-specific DNS Suffix  . :
   Link-local IPv6 Address . . . . . : fe80::8caf:93e1:7835:c5a7%10
   IPv4 Address. . . . . . . . . . . : 192.168.0.16
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Default Gateway . . . . . . . . . : 192.168.0.1


One thing that I tried is tnsping 127.0.0.1:
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 15-APR-2
012 16:05:42

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

Used parameter files:
C:\app\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
OK (170 msec)
For some reason, the service_name is blank??

Just a quick dump of listener.ora again if it reveals anything:
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 = 127.0.0.1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = C:\app


Thanks for spending time on this!
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551087 is a reply to message #551086] Sun, 15 April 2012 10:19 Go to previous messageGo to next message
BlackSwan
Messages: 23146
Registered: January 2009
Senior Member
no REMOTE Client can ever talk to any DB residing upon localhost (a.k.a 127.0.0.1)
oracle@bcm-laptop:~$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-APR-2012 08:16:29

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

Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/bcm-laptop/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                15-APR-2012 08:16:31
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/bcm-laptop/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522)))
Services Summary...
Service "v112" has 1 instance(s).
  Instance "v112", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
oracle@bcm-laptop:~$ tnsping v112

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 15-APR-2012 08:16:43

Copyright (c) 1997, 2009, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=V112)))
OK (30 msec)
oracle@bcm-laptop:~$ sqlplus scott/tiger@v112

SQL*Plus: Release 11.2.0.1.0 Production on Sun Apr 15 08:17:52 2012

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

08:17:53 SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
oracle@bcm-laptop:~$ 

Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551094 is a reply to message #551087] Sun, 15 April 2012 11:05 Go to previous messageGo to next message
d_seng
Messages: 78
Registered: November 2011
Location: UK
Member
Quote:
no REMOTE Client can ever talk to any DB residing upon localhost (a.k.a 127.0.0.1)

Hi, unless I've misunderstood your suggestion, all of this on my laptop.
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551095 is a reply to message #551094] Sun, 15 April 2012 11:17 Go to previous messageGo to next message
John Watson
Messages: 4859
Registered: January 2010
Location: Global Village
Senior Member
I am yet to be convinced that you have set your ORACLE_SID correctly. Can you run these:

echo %ORACLE_SID%
echo %ORACLE_HOME%
echo %PATH%
where sqlplus
sqlplus / as sysdba

and copy/paste what happens?
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551096 is a reply to message #551094] Sun, 15 April 2012 11:20 Go to previous messageGo to next message
BlackSwan
Messages: 23146
Registered: January 2009
Senior Member
>Hi, unless I've misunderstood your suggestion, all of this on my laptop.
& so is mine; but mine works.
Does your?
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551103 is a reply to message #551096] Sun, 15 April 2012 11:51 Go to previous messageGo to next message
d_seng
Messages: 78
Registered: November 2011
Location: UK
Member
John Watson wrote on Sun, 15 April 2012 17:17
I am yet to be convinced that you have set your ORACLE_SID correctly. Can you run these:

echo %ORACLE_SID%
echo %ORACLE_HOME%
echo %PATH%
where sqlplus
sqlplus / as sysdba

and copy/paste what happens?

Here you go:
C:\app\admin\ORCL\scripts>echo %ORACLE_SID%
orcl

C:\app\admin\ORCL\scripts>echo %ORACLE_HOME%
%ORACLE_HOME%

C:\app\admin\ORCL\scripts>echo %PATH%
%ORACLE_HOME%\bin;C:\app\product\11.2.0\dbhome_1\bin;I:\PowerCenter8.6.0\server\
bin;C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\windows\System32\
WindowsPowerShell\v1.0;Q:\Common Files\Roxio Shared\DLLShared;Q:\Common Files\Ro
xio Shared\10.0\DLLShared;P:\ActivIdentity\ActivClient;Q:\ActivIdentity\ActivCli
ent;P:\Hewlett-Packard\Drive Encryption;Q:\ATI Technologies\ATI.ACE\Core-Static;
P:\WIDCOMM\Bluetooth Software;P:\WIDCOMM\Bluetooth Software\syswow64;P:\Broadcom
\Broadcom 802.11\Driver;Q:\Common Files\HP\Digital Imaging\bin;Q:\HP\Digital Ima
ging\bin;Q:\HP\Digital Imaging\bin\Qt\Qt 4.3.3;Q:\Windows Live\Shared;Q:\QuickTi
me\QTSystem;C:\Program Files\Trend Micro\AMSP;Q:\PC Connectivity Solution;

C:\app\admin\ORCL\scripts>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Apr 15 17:36:09 2012

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

ERROR:
ORA-12560: TNS:protocol adapter error



C:\app\admin\ORCL\scripts>sqlplus sys/Dhruva01 as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Apr 15 17:38:24 2012

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

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:

Being a windows machine, ORACLE_HOME is set in the registry, so I tried:
C:\app\admin\ORCL\scripts>set ORACLE_HOME=C:\app\product\11.2.0\dbhome_1

C:\app\admin\ORCL\scripts>sqlplus sys/Dhruva01 as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Apr 15 17:40:59 2012

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

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:


BlackSwan wrote on Sun, 15 April 2012 17:20
>Hi, unless I've misunderstood your suggestion, all of this on my laptop.
& so is mine; but mine works.
Does your?

Nope. Can you please check if my listener.ora is fine, and could you also paste the contents of your listener.ora.

Thanks
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551106 is a reply to message #551103] Sun, 15 April 2012 12:05 Go to previous messageGo to next message
John Watson
Messages: 4859
Registered: January 2010
Location: Global Village
Senior Member
Well, my last suggestion: confirm that you are in the correct OS group, make sure the service is running OK, set all the variables correctly:

whoami /groups
net stop oracleserviceORCL
net start oracleserviceORCL
set ORACLE_SID=ORCL
set ORACLE_HOME=C:\app\product\11.2.0\dbhome_1
set PATH=%ORACLE_HOME%\bin;%PATH%
where sqlplus
sqlplus / as sysdba


Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551107 is a reply to message #551103] Sun, 15 April 2012 12:07 Go to previous messageGo to next message
BlackSwan
Messages: 23146
Registered: January 2009
Senior Member
>Nope. Can you please check if my listener.ora is fine, and could you also paste the contents of your listener.ora.
listener.ora file is NOT required.
listener can start without it existing

oracle@bcm-laptop:~$ cd /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/
oracle@bcm-laptop:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-APR-2012 10:02:41

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
oracle@bcm-laptop:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin$ mv listener.ora listener.ora.sav
oracle@bcm-laptop:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-APR-2012 10:03:01

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

Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Log messages written to /u01/app/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/bcm-laptop/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                15-APR-2012 10:03:05
Uptime                    0 days 0 hr. 0 min. 3 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/bcm-laptop/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
The listener supports no services
The command completed successfully
oracle@bcm-laptop:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin$ 


ORA-12560 indicates OS/Networking mis-configuration.
Oracle is victim; not culprit.
Root cause & solution are EXTERNAL to Oracle.


have you tried adding correct entry into "hosts" file?
192.168.0.15 DSG-HP6555b
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551119 is a reply to message #551107] Sun, 15 April 2012 13:21 Go to previous messageGo to next message
d_seng
Messages: 78
Registered: November 2011
Location: UK
Member
John Watson wrote on Sun, 15 April 2012 18:05
Well, my last suggestion: confirm that you are in the correct OS group, make sure the service is running OK, set all the variables correctly:

whoami /groups
net stop oracleserviceORCL
net start oracleserviceORCL
set ORACLE_SID=ORCL
set ORACLE_HOME=C:\app\product\11.2.0\dbhome_1
set PATH=%ORACLE_HOME%\bin;%PATH%
where sqlplus
sqlplus / as sysdba


C:\app\admin\ORCL\scripts>whoami /groups
GROUP INFORMATION
-----------------

Group Name                           Type             SID                                          Attributes                                                     
==================================== ================ ============================================ ===============================================================
Everyone                             Well-known group S-1-1-0                                      Mandatory group, Enabled by default, Enabled group             
DSG-HP6555b\HomeUsers                Alias            S-1-5-21-552319158-3007789056-695639748-1002 Mandatory group, Enabled by default, Enabled group             
DSG-HP6555b\ORA_DBA                  Alias            S-1-5-21-552319158-3007789056-695639748-1005 Mandatory group, Enabled by default, Enabled group             
BUILTIN\Administrators               Alias            S-1-5-32-544                                 Mandatory group, Enabled by default, Enabled group, Group owner
BUILTIN\Users                        Alias            S-1-5-32-545                                 Mandatory group, Enabled by default, Enabled group             
NT AUTHORITY\INTERACTIVE             Well-known group S-1-5-4                                      Mandatory group, Enabled by default, Enabled group             
CONSOLE LOGON                        Well-known group S-1-2-1                                      Mandatory group, Enabled by default, Enabled group             
NT AUTHORITY\Authenticated Users     Well-known group S-1-5-11                                     Mandatory group, Enabled by default, Enabled group             
NT AUTHORITY\This Organization       Well-known group S-1-5-15                                     Mandatory group, Enabled by default, Enabled group             
LOCAL                                Well-known group S-1-2-0                                      Mandatory group, Enabled by default, Enabled group             
NT AUTHORITY\NTLM Authentication     Well-known group S-1-5-64-10                                  Mandatory group, Enabled by default, Enabled group             
Mandatory Label\High Mandatory Level Label            S-1-16-12288                                 Mandatory group, Enabled by default, Enabled group             

C:\app\admin\ORCL\scripts>net stop oracleserviceORCL
The OracleServiceORCL service is stopping..................................
The OracleServiceORCL service was stopped successfully.

C:\app\admin\ORCL\scripts>net stop OracleOraDb11g_home1TNSListener
The OracleOraDb11g_home1TNSListener service is stopping..................................
The OracleOraDb11g_home1TNSListener service was stopped successfully.

C:\app\admin\ORCL\scripts>set ORACLE_SID=ORCL

C:\app\admin\ORCL\scripts>set ORACLE_HOME=C:\app\product\11.2.0\dbhome_1

C:\app\admin\ORCL\scripts>set PATH=%ORACLE_HOME%\bin;%PATH%

C:\app\admin\ORCL\scripts>net start OracleOraDb11g_home1TNSListener
The OracleOraDb11g_home1TNSListener service is starting.
The OracleOraDb11g_home1TNSListener service was started successfully.

C:\app\admin\ORCL\scripts>net start oracleserviceORCL
The OracleServiceORCL service is starting..................................
The OracleServiceORCL service was started successfully.

C:\app\admin\ORCL\scripts>where sqlplus

C:\app\product\11.2.0\dbhome_1\BIN\sqlplus.exe

C:\app\admin\ORCL\scripts>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Apr 15 18:50:37 2012

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

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: 

C:\app\admin\ORCL\scripts>sqlplus sys/Dhruva01 as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Apr 15 19:11:03 2012

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

ERROR:
ORA-12560: TNS:protocol adapter error

BlackSwan wrote on Sun, 15 April 2012 18:07
>Nope. Can you please check if my listener.ora is fine, and could you also paste the contents of your listener.ora.
listener.ora file is NOT required.
listener can start without it existing

have you tried adding correct entry into "hosts" file?
192.168.0.15 DSG-HP6555b

Yep, same results Sad
But obviously this could be different everytime DHCP assigns me a new IP address

[Updated on: Sun, 15 April 2012 13:23]

Report message to a moderator

Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551120 is a reply to message #551119] Sun, 15 April 2012 13:29 Go to previous messageGo to next message
BlackSwan
Messages: 23146
Registered: January 2009
Senior Member
open Command Window & do as below

lsnrctl stop
ren C:\app\product\11.2.0\dbhome_1\network\admin\listener.ora C:\app\product\11.2.0\dbhome_1\network\admin\listener.sav
lsnrctl start
# wait 70 -90 seconds before proceeding
lsnrctl status
lsnrctl service

COPY commands & results then PASTE all back here.
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551121 is a reply to message #551120] Sun, 15 April 2012 13:43 Go to previous messageGo to next message
d_seng
Messages: 78
Registered: November 2011
Location: UK
Member
C:\app\admin\ORCL\scripts>lsnrctl stop

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 15-APR-2012 19:33:14

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
The command completed successfully

C:\app\admin\ORCL\scripts>ren C:\app\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora listener.sav

C:\app\admin\ORCL\scripts>lsnrctl start

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 15-APR-2012 19:38:34

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

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
Log messages written to c:\app\diag\tnslsnr\DSG-HP6555b\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DSG-HP6555b)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
Start Date                15-APR-2012 19:38:40
Uptime                    0 days 0 hr. 0 min. 5 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
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)))
The listener supports no services
The command completed successfully

C:\app\admin\ORCL\scripts>time
The current time is: 19:40:24.99
Enter the new time:

C:\app\admin\ORCL\scripts>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 15-APR-2012 19:40:28

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
Start Date                15-APR-2012 19:38:40
Uptime                    0 days 0 hr. 1 min. 52 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
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)))
The listener supports no services
The command completed successfully

C:\app\admin\ORCL\scripts>lsnrctl service

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 15-APR-2012 19:40:30

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The listener supports no services
The command completed successfully
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551122 is a reply to message #551121] Sun, 15 April 2012 13:57 Go to previous messageGo to next message
BlackSwan
Messages: 23146
Registered: January 2009
Senior Member
OK things look good above.
open Command Window & issue following OS commands
(issue Ctrl-C if required below)

ping 192.168.0.15
ping DSG-HP6555b
telnet 192.168.0.15 1521

ideally the last command (telnet) should result similar to below:

oracle@bcm-laptop:~$ telnet 127.0.0.1 1521
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.


COPY commands & results then PASTE all back here
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551128 is a reply to message #551119] Sun, 15 April 2012 14:14 Go to previous messageGo to next message
John Watson
Messages: 4859
Registered: January 2010
Location: Global Village
Senior Member
Sorry, man, I've nothing more to suggest. It seems likely to me that the problem is specific to running the 32bit software in a 64bit environment, you have alrewady had to make several hacks to get as far as you have done. I would raise an SR on this. I don't think that the networking is relevant.
Good luck.
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551130 is a reply to message #551128] Sun, 15 April 2012 14:29 Go to previous messageGo to next message
John Watson
Messages: 4859
Registered: January 2010
Location: Global Village
Senior Member
Dhruva, may I ask an obvious question: why are you doing this? You could just install the 64bit version of the software,
http://www.oracle.com/technetwork/developer-tools/warehouse/downloads/software/index.html

[Updated on: Sun, 15 April 2012 14:30]

Report message to a moderator

Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551133 is a reply to message #551122] Sun, 15 April 2012 15:15 Go to previous messageGo to next message
d_seng
Messages: 78
Registered: November 2011
Location: UK
Member
BlackSwan wrote on Sun, 15 April 2012 19:57
OK things look good above.
open Command Window & issue following OS commands
(issue Ctrl-C if required below)

ping 192.168.0.15
ping DSG-HP6555b
telnet 192.168.0.15 1521

ideally the last command (telnet) should result similar to below:

oracle@bcm-laptop:~$ telnet 127.0.0.1 1521
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.


COPY commands & results then PASTE all back here

Here it is:
C:\Users\d_seng>ping 192.168.0.15

Pinging 192.168.0.15 with 32 bytes of data:
Reply from 192.168.0.15: bytes=32 time<1ms TTL=128
Reply from 192.168.0.15: bytes=32 time<1ms TTL=128
Reply from 192.168.0.15: bytes=32 time<1ms TTL=128
Reply from 192.168.0.15: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.0.15:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Users\d_seng>ping DSG-HP6555b

Pinging DSG-HP6555b [127.0.0.1] with 32 bytes of data:
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Ping statistics for 127.0.0.1:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Users\d_seng>telnet 192.168.0.15 1521
Screen stays blank for half a minute and then comes back to the command prompt. But no 'connection refused' messages. Same response for 127.0.0.1. Any problems here? Telnet server is enabled.


John Watson wrote on Sun, 15 April 2012 20:29
Dhruva, may I ask an obvious question: why are you doing this? You could just install the 64bit version of the software,
http://www.oracle.com/technetwork/developer-tools/warehouse/downloads/software/index.html

Hi John, as I mentioned, 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 am surprised OWB is available as a product in the 64-bit installer, even though it won't work!
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551134 is a reply to message #551133] Sun, 15 April 2012 15:23 Go to previous messageGo to next message
John Watson
Messages: 4859
Registered: January 2010
Location: Global Village
Senior Member
Quote:
Oracle Warehouse Builder will not run on a 64-bit o/s.
What gives you this idea?
ORacle says that OWB runs on 32 or 64 bit. And if TOAD won't run 64bit, throw it away: it does nothing you can't do with Oracle's own tools. You are just wasting time. Goodbye.

[update: the first hit on Google,
https://blogs.oracle.com/warehousebuilder/entry/owb_11gr2_windows_64_bit
]

[Updated on: Sun, 15 April 2012 15:27]

Report message to a moderator

Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551137 is a reply to message #551134] Sun, 15 April 2012 15:58 Go to previous messageGo to next message
BlackSwan
Messages: 23146
Registered: January 2009
Senior Member
Ethernet adapter Local Area Connection:

   Connection-specific DNS Suffix  . :
   Link-local IPv6 Address . . . . . : fe80::8caf:93e1:7835:c5a7%10
   IPv4 Address. . . . . . . . . . . : 192.168.0.16
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Default Gateway . . . . . . . . . : 192.168.0.1

You need to obtain consistent resolution between IP# & hostname!
C:\Users\d_seng>ping DSG-HP6555b

Pinging DSG-HP6555b [127.0.0.1] with 32 bytes of data:
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551138 is a reply to message #551137] Sun, 15 April 2012 16:23 Go to previous messageGo to next message
BlackSwan
Messages: 23146
Registered: January 2009
Senior Member
http://docs.oracle.com/cd/B19306_01/install.102/b14316/reqs.htm#BABGCEAI

was above completed prior to today?
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #551140 is a reply to message #551134] Sun, 15 April 2012 16:51 Go to previous messageGo to next message
d_seng
Messages: 78
Registered: November 2011
Location: UK
Member
John Watson wrote on Sun, 15 April 2012 21:23
Quote:
Oracle Warehouse Builder will not run on a 64-bit o/s.
What gives you this idea?
ORacle says that OWB runs on 32 or 64 bit. And if TOAD won't run 64bit, throw it away: it does nothing you can't do with Oracle's own tools. You are just wasting time. Goodbye.

[update: the first hit on Google,
https://blogs.oracle.com/warehousebuilder/entry/owb_11gr2_windows_64_bit
]

John, thanks for the pointer. I definitely tried installing 11gR2 64-bit server (11.2.0.2) on my laptop but launching OWB would raise an error, which was then confirmed as inability to run on a 64-bit o/s because of which I had to revert to 32 bit. It was the second line of my original post. Wasn't aware that a standalone OWB was made available.

I have several friends who are running a similar setup as me and had no problems whatsoever.

Nevertheless sorry to waste your time.
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #552234 is a reply to message #551140] Tue, 24 April 2012 07:43 Go to previous messageGo to next message
d_seng
Messages: 78
Registered: November 2011
Location: UK
Member
I've had a go with 64 bit Oracle now, but facing the same problem.

  • ORACLE_HOSTNAME has been set to DSGHP6555b (it was previously DSG-HP6555b, I thought maybe the "-" was causing a problem)
  • Microsoft loopback adapter has been installed and assigned an IP address of 192.168.0.9/255.255.255.0, hosts file has been changed accordingly (considering there is an ethernet and wifi adapter)
  • User has adminstrative privileges and belongs to group ORA_DBA (from a previous installation attempt)
  • Adminstrative share has been enabled using "net use \\DSGHP6555b\c$"
  • Windows firewall has been disabled

I ran setup.exe with an option to copy database software files only.

At command prompt (as administrator), after setting ORACLE_SID=ORCL and setting the path, typing in
oradim.exe -new -sid ORCL -startmode manual -spfile
gives the message "instance created" and the service OracleServiceORCL has been created.

Running the following
sqlplus sys/<password> as sysdba
returns the error ORA-12560: TNS:protocol adapter error.

I may be wrong, but my understanding is that the listener does not come into play for a local connection.

So what could cause sqlplus not connect to the instance? Could the message "instance created" be a red herring and perhaps the instance has not been created in the way it's meant to be?

Still lost Sad
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #552236 is a reply to message #552234] Tue, 24 April 2012 07:50 Go to previous messageGo to next message
John Watson
Messages: 4859
Registered: January 2010
Location: Global Village
Senior Member
You need to start the service before connecting with SQL*Plus.
And then you need to create an instance and a database.
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #552238 is a reply to message #552236] Tue, 24 April 2012 07:58 Go to previous messageGo to next message
d_seng
Messages: 78
Registered: November 2011
Location: UK
Member
John Watson wrote on Tue, 24 April 2012 13:50
You need to start the service before connecting with SQL*Plus.
And then you need to create an instance and a database.


Thanks for your reply, but doesn't the command "oradim.exe -new -sid ORCL -startmode manual -spfile" create a service, start it AND create the instance? How do I break it down further?
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #552240 is a reply to message #552238] Tue, 24 April 2012 08:00 Go to previous messageGo to next message
John Watson
Messages: 4859
Registered: January 2010
Location: Global Village
Senior Member
Trust me (I'm a DBA)
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #552241 is a reply to message #552240] Tue, 24 April 2012 08:05 Go to previous messageGo to next message
d_seng
Messages: 78
Registered: November 2011
Location: UK
Member
John Watson wrote on Tue, 24 April 2012 14:00
Trust me (I'm a DBA)
Of course!

Kindly tell me the sequence of commands I should execute. I'm a bit lost about how to create a service and start it without actually creating an instance.
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #552243 is a reply to message #552241] Tue, 24 April 2012 08:15 Go to previous messageGo to next message
John Watson
Messages: 4859
Registered: January 2010
Location: Global Village
Senior Member
Earlier in this thread I gave the exact sequence of commands to get a sysdba connection. The only point that might be missing in a new installation is that the line
SQLNET.AUTHENTICATION_SERVICES= (nts)
must be included in your %ORACLE_HOME%\network\admin\sqlnet.ora file.

What you perhaps do not understand is that a Windows service is not an Oracle instance. You register the Oracle instance as a Windows service with the oradim utility, but creating the instance is a separate process.

I don't think I can assist you, whatever we've tried has failed. Possibly, I would guess now, because of Windows security. If you ever change users, groups, machine names, pretty much anything security related on Windows, you can get totally stuck. An Active Directory makes it worse.

Perhaps someone else can help.
Re: Installation of Oracle 11gR2 on Windows 7 64-bit: fails with ORA-12560: TNS:protocol adapter err [message #552427 is a reply to message #552243] Wed, 25 April 2012 12:24 Go to previous message
d_seng
Messages: 78
Registered: November 2011
Location: UK
Member
So finally it works.

Trend Micro is the culprit. It has been blocking TCP connections without leaving a trail in the audit log or even throwing up warnings.

I had to uninstall it and installed Kaspersky which fulfils the requirements.

Thanks again
Previous Topic: OLAP Installation on 10g
Next Topic: Suggest customer
Goto Forum:
  


Current Time: Fri Dec 19 06:31:59 CST 2014

Total time taken to generate the page: 0.12083 seconds