| Re: oracle 10g ERROR: 12560 (split from hijacked thread by bb) [message #537567] |
Thu, 29 December 2011 06:13  |
 |
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  |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
