Home » Infrastructure » Windows » Re: oracle 10g ERROR: 12560 (split from hijacked thread by bb)
Re: oracle 10g ERROR: 12560 (split from hijacked thread by bb) [message #537567] Thu, 29 December 2011 06:13 Go to next message
santoshcheli
Messages: 1
Registered: December 2011
Location: HYD
Junior Member
Hai, I have tried it and got the same problem

C:\Documents and Settings\Administrator>set
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\Administrator\Application Data
CLASSPATH=.;C:\Program Files\Java\jdk1.6.0_21\lib\tools.jar;C:\Program Files\Jav
a\jdk1.6.0_21\jre\lib\rt.jar;C:\ojdbc14;
CLIENTNAME=Console
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=SANTOSHR-B6DF0F
ComSpec=C:\WINDOWS\system32\cmd.exe
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\Administrator
JAVA_HOME=C:\jdevstudio10133\jdk
LOGONSERVER=\\SANTOSHR-B6DF0F
NUMBER_OF_PROCESSORS=1
ORACLE_HOME=C:\oraclexe\app\oracle\product\10.2.0\server
OS=Windows_NT
Path=C:\OracleSOASuite\jdk\bin;C:\OracleSOASuite\ant\bin;C:\OracleSOASuite\bin;C
:\oraclexe\app\oracle\product\10.2.0\server\bin;.;C:\Program Files\Java\jdk1.6.0
_21\bin;C:\WINDOWS\system32;
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 37 Stepping 5, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=2505
ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
TMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
USERDOMAIN=SANTOSHR-B6DF0F
USERNAME=Administrator
USERPROFILE=C:\Documents and Settings\Administrator
windir=C:\WINDOWS

C:\Documents and Settings\Administrator>sqlplus "/ as sysdba"

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Dec 29 17:29:19 2011

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

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: orabpel
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: system
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

C:\Documents and Settings\Administrator>

please try to ressolve it.
Re: oracle 10g ERROR: 12560 [message #537574 is a reply to message #537567] Thu, 29 December 2011 06:55 Go to previous message
Michel Cadot
Messages: 59143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORACLE_HOME and PATH do not match.
PATH shoud cotains %ORACLE_HOME%\bin, %ORACLE_HOME%\jdk\bin and %ORACLE_HOME%\lib at the beginning.

Regards
Michel
Previous Topic: Windows 7 64 Bit support?
Next Topic: Unable to install Oracle Client
Goto Forum:
  


Current Time: Fri Sep 19 15:22:17 CDT 2014

Total time taken to generate the page: 0.23065 seconds