Home » RDBMS Server » Server Administration » Error in startup mount after shutdown immediate (oracle 10g)
Error in startup mount after shutdown immediate [message #395288] Wed, 01 April 2009 01:34 Go to next message
rajeshkanna.dba
Messages: 16
Registered: April 2009
Location: Bangalore
Junior Member

Hi friends, I want to shutdown the database using shutdown immediate and startup the database using startup mount.

1.)
My system is client system if I connect start--> program -->Accessories --> communication --> Remote Desktop connection (connect server system) , open Run type cmd after

Shutdown immediate (database is shutdown)
Startup mount (database is mounted no problem it's working fine)

2.) But if I, open Run type cmd in client system If I run same command, I'm getting below error (ORA-12560: TNS:protocol adapter error).

C:\>set oracle_sid=dbadb

C:\>sqlplus / as sysdba

SQL*Plus: Release 10.1.0.2.0 - Production on ╘± ╠ß± 31 18:09:27 2009

Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name: system
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error

3. If I run same command in Sql Plus I'm getting below error(ORA-12514: TNS:listener does not currently know of service requested in connect descriptor).


SQL*Plus: Release 10.1.0.2.0 - Production on Ôñ Ìáñ 31 18:23:13 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> connect sys/password@dbadb as sysdba
Connected.
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

Question: what is the problem , I have to set any thing in my client system. I'm new to oracle so please help me.
Re: Error in startup mount after shutdown immediate [message #395294 is a reply to message #395288] Wed, 01 April 2009 01:44 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
OK
You have a problem.
Calmly describe how to produce your problem,
Re: Error in startup mount after shutdown immediate [message #395306 is a reply to message #395288] Wed, 01 April 2009 02:11 Go to previous messageGo to next message
rajeshkanna.dba
Messages: 16
Registered: April 2009
Location: Bangalore
Junior Member
fine.
I have to shutdown the database using shutdown immediate and startup the database using startup mount in SQL Plus.
If I type shutdown immediate, database is shutdown after if I type startup mount ,I'm getting this error ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.
How to overcome this particular issue.
Re: Error in startup mount after shutdown immediate [message #395311 is a reply to message #395288] Wed, 01 April 2009 02:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to locally connect with a user in ORA_DBA Windows group to startup your database.

Regards
Michel
Re: Error in startup mount after shutdown immediate [message #395447 is a reply to message #395311] Wed, 01 April 2009 08:18 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Or, I believe that you can add explicit details to the LISTENER.ORA telling the listener about the database.
Re: Error in startup mount after shutdown immediate [message #396116 is a reply to message #395311] Sat, 04 April 2009 01:13 Go to previous messageGo to next message
rajeshkanna.dba
Messages: 16
Registered: April 2009
Location: Bangalore
Junior Member
Thanks for your replay.

Sorry for late replay,

Hi Michel Cadot

I assigned ORA_DBA windows group to my user in server system, but still I have same problem.
Re: Error in startup mount after shutdown immediate [message #396117 is a reply to message #395447] Sat, 04 April 2009 01:14 Go to previous messageGo to next message
rajeshkanna.dba
Messages: 16
Registered: April 2009
Location: Bangalore
Junior Member
Thanks for your replay.

Sorry for late replay,

Hi JRowbottom

How to add explicit details to the LISTENER.ORA

This is my listener config
# listener.ora Network Configuration File: D:\Oracle\product\10.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = evan.SOFT.COM)(PORT = 1521))
)
)
)

Re: Error in startup mount after shutdown immediate [message #396120 is a reply to message #396116] Sat, 04 April 2009 01:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
rajeshkanna.dba wrote on Sat, 04 April 2009 08:13
Thanks for your replay.

Sorry for late replay,

Hi Michel Cadot

I assigned ORA_DBA windows group to my user in server system, but still I have same problem.

Which one? You mentioned 2.
Always copy and paste what you did.

Regards
Michel

Re: Error in startup mount after shutdown immediate [message #396139 is a reply to message #396120] Sat, 04 April 2009 04:58 Go to previous messageGo to next message
rajeshkanna.dba
Messages: 16
Registered: April 2009
Location: Bangalore
Junior Member
Hi Michel

In server system

I followed this procedure

Active Directory Users and Computers --> Computers --> select my computer name (EVANDEV04) --> Add ORA_DBA


Active Directory Users and Computers -->Users --> Add ORA_DBA

I attached jpg image also

./fa/5989/0/

After in client system

1.) if I, open Run type cmd in client system If I run same command, I'm getting below error (ORA-12560: TNS:protocol adapter error).

C:\>set oracle_sid=dbadb

C:\>sqlplus / as sysdba

SQL*Plus: Release 10.1.0.2.0 - Production on ╘± ╠ß± 31 18:09:27 2009

Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name: system
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error

2. If I run same command in Sql Plus I'm getting below error(ORA-12514: TNS:listener does not currently know of service requested in connect descriptor).


SQL*Plus: Release 10.1.0.2.0 - Production on Ôñ Ìáñ 31 18:23:13 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> connect sys/password@dbadb as sysdba
Connected.
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

--> I'm getting the same error

Regards
Rajesh


  • Attachment: S3.jpg
    (Size: 530.30KB, Downloaded 2544 times)
Re: Error in startup mount after shutdown immediate [message #396166 is a reply to message #395288] Sat, 04 April 2009 09:14 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Hi friends, I want to shutdown the database using shutdown immediate and startup the database using startup mount.

>My system is client system if I connect start--> program -->Accessories --> communication --> Remote Desktop connection (connect server system) , open Run type cmd after

It would be easier for all concerned to shut down Oracle if you logged directly onto the database server system itself as the owner of the Oracle software.

sqlplus
/ as sysdba
shutdown immediate
exit

If problems still exist, post output from following command
SET
Re: Error in startup mount after shutdown immediate [message #396218 is a reply to message #395288] Sun, 05 April 2009 02:24 Go to previous messageGo to next message
malikjee
Messages: 80
Registered: May 2007
Location: lahore
Member

Hi Mr!

you are trying to test the skill of experts I think,y you not provide complete detail about your environment.plz ask question to the point and provide detiled concerning information.
Thaks.
Malik
Re: Error in startup mount after shutdown immediate [message #396358 is a reply to message #396218] Mon, 06 April 2009 05:09 Go to previous messageGo to next message
rajeshkanna.dba
Messages: 16
Registered: April 2009
Location: Bangalore
Junior Member
Hi friend,

I am not tried to test anyone. But I have lot of query in my mind regarding oracle, because I am new to oracle.

I explained almost all think. Please let me know what detail you want.

I have one query in my mind regarding oracle now.

1.)If I open start--> Run type cmd in Server system . It's working fine, no problem

I am following below step in my server system

C:\>set oracle_sid=dbadb

C:\>sqlplus / as sysdba

SQL*Plus: Release 10.1.0.2.0 - Production on -s) -=± 6 14:44:03 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

2.)but if try same think in my client system to shutdown the database

open start--> Run type cmd in client system . It's not working .I'm getting error 'TNS:protocol adapter error'

C:\>set oracle_sid=dbadb

C:\>sqlplus / as sysdba

SQL*Plus: Release 10.1.0.2.0 - Production on 6 14:51:27 2009

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

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: system
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Question: whether we can shutdown the database using start --> Run type cmd --> cmd.exe window in client system are not?
If yes means what are the settings we have to do?

Re: Error in startup mount after shutdown immediate [message #396359 is a reply to message #396358] Mon, 06 April 2009 05:13 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
Question: whether we can shutdown the database using start --> Run type cmd --> cmd.exe window in client system are not?
If yes means what are the settings we have to do?


From Server; Check your listener status. If it's up. Then it's possible from client.

Babu
Re: Error in startup mount after shutdown immediate [message #396457 is a reply to message #395288] Mon, 06 April 2009 17:19 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>2.)but if try same think in my client system to shutdown the database
This is a VERY dangerous approach because if you can shutdown the DB server from your client, then I can shutdown the DB from my PC!

Would you have a problem, if I or any other client shutdown the DB?


Since you can manage the database while logged onto the server,
why do you need to open up the security hole by allowing any client to control the database?

Beside you need to RTFM found at http://tahiti.oracle.com
to learn how SQL*Net works & how to properly configure it.

I refuse to give a loaded pistol to a child.
With configuration changes, you would be able to start & stop the remote database from your client.
You are free to determine the necessary changes. Enjoy!

[Updated on: Mon, 06 April 2009 17:24]

Report message to a moderator

Re: Error in startup mount after shutdown immediate [message #502883 is a reply to message #396457] Mon, 11 April 2011 05:01 Go to previous message
ankit3010
Messages: 17
Registered: November 2010
Location: Indore
Junior Member
Hi all,
You have to make an entry of the instance which you are trying to shutdown and start in the tnsnames.ora file which is usually in C:\orant\NET80\ADMIN directory
Previous Topic: log file sync and LGWR wait on LNS Event - ADDM
Next Topic: Oracle not reconising shutdown command
Goto Forum:
  


Current Time: Sat Dec 10 00:58:34 CST 2016

Total time taken to generate the page: 0.09655 seconds