OraFAQ Forum: Server Administration » TNS:listener does not currently know of service

Home » RDBMS Server » Server Administration » TNS:listener does not currently know of service

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

TNS:listener does not currently know of service [message #567461]

Mon, 01 October 2012 09:56

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

hello experts,

Enter user-name: sys@test123 as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SQL>

i want to make my database from noarchive mode to archive mode, so
whenever i tried to startup the database after the shutdown then i have to up the
database by restarting the service(from control panel on windows) because of this error.
why this error occured.

thanks in advance ....

Report message to a moderator

Re: TNS:listener does not currently know of service [message #567462 is a reply to message #567461]

Mon, 01 October 2012 10:02

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You shut down your database so the service is no more active and so the listneer can't know it.
Locally connect, without listener, and you will be able to restart the database.
Generally speaking, alway locally connect to make maintenance on your database (but maybe for backup).

Regards
Michel

Report message to a moderator

Re: TNS:listener does not currently know of service [message #567523 is a reply to message #567462]

Wed, 03 October 2012 02:09

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

thank you very much sir,
about connection locally without the listner.

but how we can connect locally?
and what setting we have to do for it?
please tell me sir.

thanks again...

[Updated on: Wed, 03 October 2012 02:10]

Report message to a moderator

Re: TNS:listener does not currently know of service [message #567525 is a reply to message #567523]

Wed, 03 October 2012 02:14

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Connect to the server.
Set ORACLE_HOME, ORACLE_SID, PATH environment variables.
Execute sqlplus.

Regards
Michel

Report message to a moderator

Re: TNS:listener does not currently know of service [message #567659 is a reply to message #567525]

Thu, 04 October 2012 01:56

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

thanks sir,

i want to share that what i want to do:-
actually my database is in NOARCHIVELOG mode , then i want to make it in ARCHIVELOG mode.
so i have to MOUNT the database.

i want to do that-

sql>shutdown immediate
sql>startup mount
sql>alter database archivelog

is there any other way to do that?

thanks again.......

Report message to a moderator

Re: TNS:listener does not currently know of service [message #567660 is a reply to message #567659]

Thu, 04 October 2012 02:12

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No.
Which kind of other way have you in mind?

Regards
Michel

Report message to a moderator

Re: TNS:listener does not currently know of service [message #567666 is a reply to message #567462]

Thu, 04 October 2012 03:08

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

Michel Cadot wrote on Mon, 01 October 2012 10:02

You shut down your database so the service is no more active

Regards
Michel

when i shutdown the database then database windows service also get stopped.
but when i try startup the database , then database windows service should also be
started automatically, otherwise we can't startup databasa in MOUNT or NOMOUNT mode
(because now we restart the database windows service then the database restarted in NORMAL mode),
without connecting locally,
as you told that set ORACLE_SID,ORACLE_HOME....etc.

so i am asking that is there any other way to startup the database in MOUNT or NOMOUNT mode from local machine.

thanks again....

Report message to a moderator

Re: TNS:listener does not currently know of service [message #567669 is a reply to message #567666]

Thu, 04 October 2012 03:37

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

i shutdown the database then database windows service also get stopped.

It should not.

Quote:

when i try startup the database , then database windows service should also be
started automatically

No, you have to first start the service.

Regards
Michel

Report message to a moderator

Re: TNS:listener does not currently know of service [message #567672 is a reply to message #567669]

Thu, 04 October 2012 03:45

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

Michel Cadot wrote on Thu, 04 October 2012 03:37

Quote:

It should not.

Regards
Michel

then how should i restrict database windows service from getting stopped?
thanks....

[Updated on: Thu, 04 October 2012 03:47]

Report message to a moderator

Re: TNS:listener does not currently know of service [message #567673 is a reply to message #567672]

Thu, 04 October 2012 03:53

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you stop the database using SQL statement "shutdown" it should not stop the service.
If it does then have a look at the Windows application event log there should be a message; post it.

Regards
Michel

Report message to a moderator

Re: TNS:listener does not currently know of service [message #567688 is a reply to message #567673]

Thu, 04 October 2012 06:41

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

thanks sir,

sql>shutdown

it's taking so much time and this process is not being completed.

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Neetesh>rman

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Oct 4 17:10:59 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target sys/@test123

target database Password:
connected to target database: test123(DBID=61106777)

RMAN> @d:/rman_utility/rman_cold_script.txt

RMAN> run
2> {
3> shutdown immediate;
4> startup mount;
5> allocate  channel c type diask;
6> backup  as backupset database format 'd:/rman_utility/rman_test123_cold_full
_%u';
7> alter database open;
8> }
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 10/04/2012 17:12:00
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

RMAN> **end-of-file**

RMAN>

now i am unable to take cold backup.in the rman script it throws
error at the point of MOUNT the database
, but some days before i had taken cold backup with same script.

thanks.......

Report message to a moderator

Re: TNS:listener does not currently know of service [message #567693 is a reply to message #567688]

Thu, 04 October 2012 06:51

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

sql>shutdown

result is here for testdb-

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Neetesh>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 4 17:17:35 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: sys@testdb as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SQL>

and this is the last message as warning in Event Viewer

"All process in instance testdb stopped"

thanks.......

Report message to a moderator

Re: TNS:listener does not currently know of service [message #567694 is a reply to message #567688]

Thu, 04 October 2012 06:51

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

"shutdown" alone waits for all connections to end.
Use "shutdown immediate" instead.

Now you have to abort the instance, restart it and shut down immediate it.

Regards
Michel

Report message to a moderator

Re: TNS:listener does not currently know of service [message #567706 is a reply to message #567694]

Thu, 04 October 2012 07:56

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

as you told:-

SQL> conn sys@testdb as sysdba
Enter password:
Connected.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup;
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SQL> conn sys@testdb as sysdba
Enter password:
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SQL>

and...




SQL> shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SQL>

now i have restart the windows service, then i become able to connect again....

SQL> conn sys@testdb as sysdba
Enter password:
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SQL>

again i have to restart the windows service, then i become able to connect

SQL> conn sys@testdb as sysdba
Enter password:
Connected.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup;
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SQL>

and for transactional:-


SQL> shutdown transactional;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SQL>

in all cases it throws service error.

thanks.....

Report message to a moderator

Re: TNS:listener does not currently know of service [message #567708 is a reply to message #567706]

Thu, 04 October 2012 08:04

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You must be connected on the database server.
ALWAYS do your database maintenance on the database server.

Regards
Michel

Report message to a moderator

Re: TNS:listener does not currently know of service [message #567709 is a reply to message #567708]

Thu, 04 October 2012 08:05

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Michel Cadot wrote on Wed, 03 October 2012 09:14

Connect to the server.
Set ORACLE_HOME, ORACLE_SID, PATH environment variables.
Execute sqlplus.

Regards
Michel

Report message to a moderator

Re: TNS:listener does not currently know of service [message #567712 is a reply to message #567709]

Thu, 04 October 2012 08:27

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

ok sir thanks a lot........

Report message to a moderator

Previous Topic:	Use of LM( Lock mode) in V$lock
Next Topic:	Redo log switches in every 3 mins

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 14:25:27 CST 2024