System Identifier Problem [message #414317] |
Tue, 21 July 2009 09:55 |
I_AM_TOO
Messages: 37 Registered: July 2009 Location: cc
|
Member |
|
|
Hi,
Firstly after install 10g i connect from SQL Plus and Developer 10 g But after second restart it gives error
SQL>conn / as sysdba
connected idle instance
SQL>conn sys/PS@scc as sysdba
ORA-15514:TNS:Listener does not currently know of service requested in connect descriptor
Network manager shows SID SCC
Protocol TCP/IP
Port 1521
E.M also not opening since installation
Help me Sir
|
|
|
Re: System Identifier Problem [message #414318 is a reply to message #414317] |
Tue, 21 July 2009 10:03 |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Step one would be to try to start the database.
Then tell us what the situation REALLY is.
The error code you posted doesn't match with the error message
oracle ~ $ oerr ORA 15514
15514, 00000, "cannot find a match for the remote procedure call during replay"
// *Cause: The corresponding PL/SQL program was either dropped or modified.
// *Action: Verify that the corresponding PL/SQL program is defined the same
// way during replay as it was defined during workload capture.
//
"connected idle instance" also isn't exactly the message *I* get when I connect to an idle instance.
|
|
|
|
Re: System Identifier Problem [message #414321 is a reply to message #414317] |
Tue, 21 July 2009 10:36 |
I_AM_TOO
Messages: 37 Registered: July 2009 Location: cc
|
Member |
|
|
Sorry the code and erorr is
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Results are there for
lsnrctl status
lsnrctl start
lsnrctl status
lsnrctl service
set
pwd
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
D:\Documents and Settings\Administrator>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-JUL-2009 20:23
:55
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 21-JUL-2009 20:16:51
Uptime 0 days 0 hr. 7 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File D:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sec786)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
D:\Documents and Settings\Administrator>lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-JUL-2009 20:24
:23
Copyright (c) 1991, 2005, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
D:\Documents and Settings\Administrator>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-JUL-2009 20:24
:49
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 21-JUL-2009 20:16:51
Uptime 0 days 0 hr. 7 min. 57 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File D:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sec786)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
D:\Documents and Settings\Administrator>lsnrctl service
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-JUL-2009 20:25
:07
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
D:\Documents and Settings\Administrator>set
ALLUSERSPROFILE=D:\Documents and Settings\All Users
APPDATA=D:\Documents and Settings\Administrator\Application Data
ClusterLog=D:\WINDOWS\Cluster\cluster.log
CommonProgramFiles=D:\Program Files\Common Files
COMPUTERNAME=SEC786
ComSpec=D:\WINDOWS\system32\cmd.exe
FP_NO_HOST_CHECK=NO
HOMEDRIVE=D:
HOMEPATH=\Documents and Settings\Administrator
LOGONSERVER=\\SEC786
NUMBER_OF_PROCESSORS=1
OS=Windows_NT
Path=F:\OraHome_1\jdk\jre\bin\client;F:\OraHome_1\jlib;F:\OraHome_1\bin;F:\OraHo
me_1\jre\1.4.2\bin\client;F:\OraHome_1\jre\1.4.2\bin;D:\DevSuiteHome_1\jre\1.4.2
\bin\client;D:\DevSuiteHome_1\jre\1.4.2\bin;D:\oracle\product\10.2.0\db_1\bin;D:
\WINDOWS\system32;D:\WINDOWS;D:\WINDOWS\System32\Wbem
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PERL5LIB=D:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWin32-x86;D:\oracle\prod
uct\10.2.0\db_1\perl\5.8.3\lib;D:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWi
n32-x86;D:\oracle\product\10.2.0\db_1\perl\site\5.8.3;D:\oracle\product\10.2.0\d
b_1\perl\site\5.8.3\lib;D:\oracle\product\10.2.0\db_1\sysman\admin\scripts;
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 15 Model 2 Stepping 7, GenuineIntel
PROCESSOR_LEVEL=15
PROCESSOR_REVISION=0207
ProgramFiles=D:\Program Files
PROMPT=$P$G
SESSIONNAME=Console
SystemDrive=D:
SystemRoot=D:\WINDOWS
TEMP=D:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
TMP=D:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
USERDOMAIN=SEC786
USERNAME=Administrator
USERPROFILE=D:\Documents and Settings\Administrator
windir=D:\WINDOWS
D:\Documents and Settings\Administrator>pwd
'pwd' is not recognized as an internal or external command,
operable program or batch file.
D:\Documents and Settings\Administrator>
|
|
|
|
|
Re: System Identifier Problem [message #414406 is a reply to message #414317] |
Wed, 22 July 2009 00:54 |
I_AM_TOO
Messages: 37 Registered: July 2009 Location: cc
|
Member |
|
|
I don't know Oracle user automatically created at instalation or otherwise ,I create user oracle in o/s and then login
Following are not available adapter error
sqlplus
/ as sysdba
startup
select * from v$version;
exit
due to ORA-12560: TNS:protocol
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
D:\Documents and Settings\Oracle>sqlplus/nolog
SQL*Plus: Release 10.1.0.4.2 - Production on Wed Jul 22 10:32:29 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
SQL> conn system/scc@scc
ERROR:
ORA-12505: TNS:listener does not currently know of SID given in connect
descriptor
SQL> conn oracle/scc@scc
ERROR:
ORA-12505: TNS:listener does not currently know of SID given in connect
descriptor
SQL>
Others results are here under
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
D:\Documents and Settings\Oracle>lsnrctl service
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 22-JUL-2009 10:40
:10
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
D:\Documents and Settings\Oracle>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 22-JUL-2009 10:40
:30
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 22-JUL-2009 10:02:37
Uptime 0 days 0 hr. 37 min. 52 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File D:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sec786)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
D:\Documents and Settings\Oracle>
|
|
|
|
Re: System Identifier Problem [message #414452 is a reply to message #414445] |
Wed, 22 July 2009 04:14 |
|
Michel Cadot
Messages: 68718 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
gentlebabu wrote on Wed, 22 July 2009 11:01 | Quote: | SQL> conn / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
|
start your oracle service from windows services.msc
thanks
|
And be sure you did set ORACLE_SID.
Regards
Michel
[Updated on: Wed, 22 July 2009 04:15] Report message to a moderator
|
|
|
|
|
Re: System Identifier Problem [message #414556 is a reply to message #414317] |
Wed, 22 July 2009 11:31 |
I_AM_TOO
Messages: 37 Registered: July 2009 Location: cc
|
Member |
|
|
I have another problem
Now that starts automaticaly
OracleDBConsolescc started
this not start
OracleServiceSCC (automatic) not Started
On start it gives me
Could not start OracleServiceSCC service on local computer.
ERROR-5 : Access is denied
Please help me
|
|
|
|
Re: System Identifier Problem [message #414627 is a reply to message #414317] |
Thu, 23 July 2009 01:10 |
I_AM_TOO
Messages: 37 Registered: July 2009 Location: cc
|
Member |
|
|
That is second time installation in different windows (WinXP now WinServer2003) having similar problems in both .
if try some thing
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
D:\Documents and Settings\Oracle>set oracle_SID=SCC
D:\Documents and Settings\Oracle>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://sec786:1158/em/console/aboutApplication
Error opening logfile for output in nmeula_new
Error opening logfile for output in nmeula_new
Starting Oracle Enterprise Manager 10g Database Control ...System error 5 has oc
curred.
Access is denied.
D:\Documents and Settings\Oracle>.
And Error
On start service gives me
Could not start OracleServiceSCC service on local computer.
ERROR-5 : Access is denied
Except reinstalling is there any way(.Net and Oracle)
|
|
|
|
Re: System Identifier Problem [message #414887 is a reply to message #414317] |
Thu, 23 July 2009 23:34 |
I_AM_TOO
Messages: 37 Registered: July 2009 Location: cc
|
Member |
|
|
Quote: |
Generic error message; You may need to check with your OS admin.
|
Now the error message is
Could not start OracleServiceSCC service on local computer.
ERROR-2 : The system cannot find the spacified file.
|
|
|
|