Home » RDBMS Server » Enterprise Manager » System Identifier Problem (WinServer2003,Oracle10g Release2)
System Identifier Problem [message #414317] Tue, 21 July 2009 09:55 Go to next message
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 Go to previous messageGo to next message
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 #414319 is a reply to message #414317] Tue, 21 July 2009 10:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
logon as the user (oracle?) which owns Oracle software directory
open a command window

CUT the following commands

lsnrctl status
lsnrctl start
lsnrctl status
lsnrctl service
set
pwd

PASTE them into command window
CUT commands & results from command window & PASTE back here
Re: System Identifier Problem [message #414321 is a reply to message #414317] Tue, 21 July 2009 10:36 Go to previous messageGo to next message
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 #414322 is a reply to message #414317] Tue, 21 July 2009 10:55 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member

logon as the user (oracle?) which owns Oracle software directory


>USERNAME=Administrator

Does user Adminstrator really own the Oracle software tree D:\oracle\product\10.2.0\db_1 ?

Log onto the system as the Oracle s/w owner & do the following:

sqlplus
/ as sysdba
startup
select * from v$version;
exit
lsnrctl service
lsnrctl status


Now using CUT & PASTE show the session doing all the commands & the results
Re: System Identifier Problem [message #414325 is a reply to message #414317] Tue, 21 July 2009 11:14 Go to previous messageGo to next message
I_AM_TOO
Messages: 37
Registered: July 2009
Location: cc
Member
how i can log in as oracle

login window prompt me check user name please clear how i can?
Re: System Identifier Problem [message #414406 is a reply to message #414317] Wed, 22 July 2009 00:54 Go to previous messageGo to next message
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 #414445 is a reply to message #414406] Wed, 22 July 2009 04:01 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
SQL> conn / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error



start your oracle service from windows services.msc

thanks
Re: System Identifier Problem [message #414452 is a reply to message #414445] Wed, 22 July 2009 04:14 Go to previous messageGo to next message
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 #414508 is a reply to message #414317] Wed, 22 July 2009 06:55 Go to previous messageGo to next message
I_AM_TOO
Messages: 37
Registered: July 2009
Location: cc
Member

OracleDBConsolescc  (automatic) not started
OrcleJobScheduler                   started
Oracle10gHomeSQL*Plus		    started
OracleServiceSCC		    Started



Thats fine Thank you very much.
Re: System Identifier Problem [message #414540 is a reply to message #414508] Wed, 22 July 2009 09:04 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Great to know this. Thanks for your feedback. Smile

Thanks
Re: System Identifier Problem [message #414556 is a reply to message #414317] Wed, 22 July 2009 11:31 Go to previous messageGo to next message
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 #414564 is a reply to message #414556] Wed, 22 July 2009 12:16 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Generic error message; You may need to check with your OS admin.

Thanks
Re: System Identifier Problem [message #414627 is a reply to message #414317] Thu, 23 July 2009 01:10 Go to previous messageGo to next message
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 #414704 is a reply to message #414627] Thu, 23 July 2009 04:14 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

On start service gives me 

Could not start OracleServiceSCC service on local computer.
ERROR-5 : Access is denied


Quote:
Generic error message; You may need to check with your OS admin.

Thanks
Re: System Identifier Problem [message #414887 is a reply to message #414317] Thu, 23 July 2009 23:34 Go to previous messageGo to next message
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.
Re: System Identifier Problem [message #415109 is a reply to message #414887] Fri, 24 July 2009 23:06 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

http://www.google.co.in/search?hl=en&client=firefox-a&rls=org.mozilla:en-US:official&hs=WuY&ei=iIRqSvDVIo2BkQWGz7CoCw &sa=X&oi=spell&resnum=0&ct=result&cd=1&q=Could+not+start+OracleService+service+on+local+computer&spell=1
Previous Topic: non-ORA alert in EM
Next Topic: collection status - Disabled by upload manager
Goto Forum:
  


Current Time: Tue Dec 03 05:32:20 CST 2024