| Error in startup mount after shutdown immediate [message #395288] |
Wed, 01 April 2009 01:34  |
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 #395306 is a reply to message #395288] |
Wed, 01 April 2009 02:11  |
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 #396117 is a reply to message #395447] |
Sat, 04 April 2009 01:14 |
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 #396358 is a reply to message #396218] |
Mon, 06 April 2009 05:09 |
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 #396457 is a reply to message #395288] |
Mon, 06 April 2009 17:19 |
 |
BlackSwan
Messages: 26766
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
