OraFAQ Forum: Server Administration » restart of the database service causes ORA-12514: TNS:listener does not currently know of service re

Home » RDBMS Server » Server Administration » restart of the database service causes ORA-12514: TNS:listener does not currently know of service re (Windows server 2003 Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558948]

Wed, 27 June 2012 12:23

Andrey_R
Messages: 441
Registered: January 2012
Location: Israel

Senior Member

Hi guys.
oracle Database was shutdown by

shutdown immediate;

now I try to connect but it gives me:
ORA-12514: TNS:listener does not currently know of service requested in connect

how can I bring the database back up?

Thank you,
Andrey

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558950 is a reply to message #558948]

Wed, 27 June 2012 12:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>how can I bring the database back up?
no listener is required to start or utilize Oracle RDBMS

log onto DB Server & do exactly as below

sqlplus
/ as sysdba
startup
exit

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558951 is a reply to message #558948]

Wed, 27 June 2012 12:28

Andrey_R
Messages: 441
Registered: January 2012
Location: Israel

Senior Member

Just did, got this:

C:\oracle\product\10.2.0\db_1\network\ADMIN>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 27 18:27:55 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558952 is a reply to message #558951]

Wed, 27 June 2012 12:30

Andrey_R
Messages: 441
Registered: January 2012
Location: Israel

Senior Member

If you meant real login credentials: with the regular credentials it doesn't work as well.
I use the same sysdba credentials and it gives me the original error message I posted.

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558953 is a reply to message #558952]

Wed, 27 June 2012 12:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

are both OS Services for database & listener started & running now?

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558954 is a reply to message #558953]

Wed, 27 June 2012 12:34

Andrey_R
Messages: 441
Registered: January 2012
Location: Israel

Senior Member

I have restarted the database OS service, although it was up already.

currently both up and running.

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558955 is a reply to message #558954]

Wed, 27 June 2012 12:38

Andrey_R
Messages: 441
Registered: January 2012
Location: Israel

Senior Member

and still same problem, of course.

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558956 is a reply to message #558955]

Wed, 27 June 2012 12:47

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

I don't understand. If the database is up and running, what is the problem? How did it restart, as you initially said it was down and you made no indication that you brought it back up.

Are your environment variables set properly to startup the correct database?

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558957 is a reply to message #558956]

Wed, 27 June 2012 12:54

Andrey_R
Messages: 441
Registered: January 2012
Location: Israel

Senior Member

>> If the database is up and running, what is the problem?

the database and listener services in the OS are up and running.
I cannot connect to the database due to the originally posted error.

I *restarted* the database and listener services to see if this will solve the original error,
but it didn't, still can't connect.

I have a TNS_ADMIN environment variable that leads to %ORACLE_HOME%\network\admin.
I tried to change it to C:\oracle\product\10.2.0\db_1\network\admin and restart the listener - same problem.

any ideas what else should I check?

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558958 is a reply to message #558957]

Wed, 27 June 2012 13:06

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

if/when ORACLE_SID not correct, can result in ORA-12560: TNS:protocol adapter error

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558965 is a reply to message #558958]

Wed, 27 June 2012 14:01

Andrey_R
Messages: 441
Registered: January 2012
Location: Israel

Senior Member

this is probably what has happend.

I am still investigating what and why caused this..
but what has let me connect was defining the next set of variables explicitly in SQL*Plus session:

set ORACLE_SID=*SID_NAME*
set ORACLE_HOME=C:\oracle\product\10.2.0\db_1
PATH %ORACLE_HOME%\bin;%PATH%
set NLS_LANG=AMERICAN_AMERICA.WE8PC850
set NLS_DATE_FORMAT=yyyy-mm-dd.hh24-mi-ss
set NLS_TIMESTAMP_FORMAT=yyyy-mm-dd.hh24-mi-ss.ff6
set TNS_ADMIN=%ORACLE_HOME%\network\admin
set SQLPATH=%ORACLE_HOME%\rdbms\admin;c:\my_scripts

can someone guess what of these solved the issue?

Regards,
Andrey

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558971 is a reply to message #558965]

Wed, 27 June 2012 14:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>can someone guess what of these solved the issue?
42

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558972 is a reply to message #558971]

Wed, 27 June 2012 14:26

Andrey_R
Messages: 441
Registered: January 2012
Location: Israel

Senior Member

Nice guess;)

I assume it was the SID_NAME.
where is it supposed to be configured?

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558973 is a reply to message #558972]

Wed, 27 June 2012 14:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>where is it supposed to be configured?
for Windoze, usually in registry.

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558974 is a reply to message #558973]

Wed, 27 June 2012 14:31

Andrey_R
Messages: 441
Registered: January 2012
Location: Israel

Senior Member

Can you please elaborate?

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558978 is a reply to message #558965]

Wed, 27 June 2012 15:14

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Andrey_R wrote on Wed, 27 June 2012 15:01

this is probably what has happend.

I am still investigating what and why caused this..
but what has let me connect was defining the next set of variables explicitly in SQL*Plus session:

set ORACLE_SID=*SID_NAME*
set ORACLE_HOME=C:\oracle\product\10.2.0\db_1
PATH %ORACLE_HOME%\bin;%PATH%
set NLS_LANG=AMERICAN_AMERICA.WE8PC850
set NLS_DATE_FORMAT=yyyy-mm-dd.hh24-mi-ss
set NLS_TIMESTAMP_FORMAT=yyyy-mm-dd.hh24-mi-ss.ff6
set TNS_ADMIN=%ORACLE_HOME%\network\admin
set SQLPATH=%ORACLE_HOME%\rdbms\admin;c:\my_scripts

can someone guess what of these solved the issue?

Again I do not understand. If you cannot connect, how did you set these variables in a sql*plus session? And the above are OS environment variables, not DEFINEd sqlplus session variables.
ORACLE_SID is what connects you to the correct database if it is set at the OS (along with ORACLE_HOME).

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558979 is a reply to message #558978]

Wed, 27 June 2012 15:31

Andrey_R
Messages: 441
Registered: January 2012
Location: Israel

Senior Member

sqlplus /nolog
then ran the "set...."

then i could connect.

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #558983 is a reply to message #558979]

Wed, 27 June 2012 17:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Andrey_R wrote on Wed, 27 June 2012 13:31

sqlplus /nolog
then ran the "set...."

then i could connect.

I don't believe you.

15:11:34 SQL> set ORACLE_HOME=C:\oracle\product\10.2.0\db_1
SP2-0735: unknown SET option beginning "ORACLE_HOM..."
15:11:41 SQL>

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

use COPY & PASTE so we can see what you do & how Oracle responds.

Report message to a moderator

Re: restart of the database service causes ORA-12514: TNS:listener does not currently know of service re [message #559041 is a reply to message #558983]

Thu, 28 June 2012 03:22

Andrey_R
Messages: 441
Registered: January 2012
Location: Israel

Senior Member

BlackSwan wrote on Thu, 28 June 2012 01:13

Andrey_R wrote on Wed, 27 June 2012 13:31
sqlplus /nolog
then ran the "set...."

then i could connect.

I don't believe you.
15:11:34 SQL> set ORACLE_HOME=C:\oracle\product\10.2.0\db_1
SP2-0735: unknown SET option beginning "ORACLE_HOM..."
15:11:41 SQL> 
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

use COPY & PASTE so we can see what you do & how Oracle responds.

Please let me correct myself.
I *first* ran the "set" command in cmd window and then coul connect by SQL*Plus.

apologies for misinforming.

Regards,
Andrey

[Updated on: Thu, 28 June 2012 03:22]

Report message to a moderator

Previous Topic:	restorin the oracle services in windows 2008 server
Next Topic:	Materialized aggregate view index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 00:44:34 CDT 2024