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)
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 Go to next message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 23158
Registered: January 2009
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

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 Go to previous messageGo to next message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
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:
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 Go to previous messageGo to next message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
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.
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 Go to previous messageGo to next message
BlackSwan
Messages: 23158
Registered: January 2009
Senior Member
are both OS Services for database & listener started & running now?
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 Go to previous messageGo to next message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
Senior Member

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

currently both up and running.

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 Go to previous messageGo to next message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
Senior Member

and still same problem, of course.
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 Go to previous messageGo to next message
joy_division
Messages: 4559
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?
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 Go to previous messageGo to next message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
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?
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 Go to previous messageGo to next message
BlackSwan
Messages: 23158
Registered: January 2009
Senior Member
if/when ORACLE_SID not correct, can result in ORA-12560: TNS:protocol adapter error
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 Go to previous messageGo to next message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 23158
Registered: January 2009
Senior Member
>can someone guess what of these solved the issue?
42
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 Go to previous messageGo to next message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
Senior Member

Nice guess;)

I assume it was the SID_NAME.
where is it supposed to be configured?
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 Go to previous messageGo to next message
BlackSwan
Messages: 23158
Registered: January 2009
Senior Member
>where is it supposed to be configured?
for Windoze, usually in registry.
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 Go to previous messageGo to next message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
Senior Member

Can you please elaborate?
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 Go to previous messageGo to next message
joy_division
Messages: 4559
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).
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 Go to previous messageGo to next message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
Senior Member

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

then i could connect.
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 Go to previous messageGo to next message
BlackSwan
Messages: 23158
Registered: January 2009
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.
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 Go to previous message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
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:
  


Current Time: Sun Dec 21 16:36:09 CST 2014

Total time taken to generate the page: 0.07715 seconds