shutdown databse from client/remotely - Heterogeneous Connectivity

hi..
how to shutdown the remote Database(remotely) from client /other Database....
my database is 9i/8i
is it ok....
pl help me...
IT'sRK

You will make a connection from client to database. Use connect sys as sysdba. Then shutdown the database.

Related

Shutdown Database Oracle 8.0.5 on NT

Hi All,
Something really weird happened to one of my databases. I can connect as Internal and I can startup the database, but if connect as Internal, I can't Shutdown Normal or Immediate the database! The error is ORA-01012 Not Logged ON
The point is I can Shutdown Abort. I deleted the instance & recreated it again abd still have the same problem.
Any help, appreciated.
Thanks,
Arash
check your listener services

Database Backup

Hi Everybody,
I have different Oracle versions (8.0.5 , 8.1.5 , 8.1.7, 9.0.1, ..) on different windows 2000 servers.
and each of them has more than one oracle database. Now I want to write a script and define it as a job in one of the Oracle servers. I want to do the following:
1-set oracle sid
2-svrmgr
3-connect internal
4-shutdown database
5-copy related files
6-startup database
I don't have any problem for shutting down databases at night. So I prefer to do Full backup.
The problem is, because it is one script and stay only on one of the servers (for example server A) , at the time of switching the server and setting the oracle_sid to a new one that is on remote server ( for example B) it faces error ora-12203. In another way, how is it possible to set oracle_sid on a remote server & connect svrmgr and do the shutdown or startup database? Remember I want to use one script for all databases and define it as one job stay in one of the servers.
Thanks for any help,
Arash
Create SQL*NET entries for all your instances on the 'Master' server then connect with an account as sysdba to each of the instances then order the shutdown command:
connect '/ as sysdba'#inst1
shutdown immediate;
connect '/as sysddba'#inst2
shutdown immediate;
...
Thanks

Problem with Shutdown & Startup a database in Oracle 9i

Hi All,
I have an Oracle 9i Database (SID=V800) on Windows 2000. The problem is whenever I shutdown the database I have to restart associated oracle service (OracleServiceV800) in Services on the server. It seems, whenever I stop the service, it shutdown the database and at the time of starting the service, it startup the database. Besides that, I can't startup the database manually. I have to restart the Oracle service on the server, which is startup the database simultaneously.
Thanks for any help.,
Arash
how are you trying to startup the database manually?
did you get any error messages while trying to start manually?
Kamal,
I use command prompt and the error is ORA-12505:TNS: couldn't resolve SID given ....
I chaged Starttype of oracle service to Manual. Now it won't Startup the Database whenever I restart the service & I can startup the database Localy(If I issue Startup command on the Server), but I can't do it remotly. Although I can shutdown the database remotly. Let me explain it more. I do the following on a client:
C:\sqlplus /nolog
sql> connect sys/change_on_install#v800 as sysdba
sql>shutdown immediate
Database closed.
Oracle instance shut down.
After that, I can't reconnect as an idel or whatever to be able to startup the database. (Error ORA-12505)
But if I go and do it on the server, I can issue "connect sys/change_on_install as sysdba" AND startup the database.
I hope I could explain it
Thanks,
Arash
are you using server side initialization file or the traditional init.ora file for starting
your database? 
I am using init.ora
startup pfile=\\ora9012k\D\Data\Databases\V800\init_file\initV800.ora
Thanks for your time

Error when startup Oracle 10.2.0 database

Hi all,
I'm using Oracle 10g v10.2.0 on Windows 2K Advanced Server.
I want to drop schema SYSMAN following the instructions available in the forum.
But I cannot startup (restrict) the database after shutdown it.
My commands:
SQL> connect / as sysdba
SQL> connected
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup restrict
Then error ORA-12514 : TNS : listener does not currently know of service requested in connect descriptor
So, what is the real problem. Pls help me to solve
Thank you very much. 
try to restart oracle service in control panel and try again... 
or of the service is already running ,try to manually configure the database entry inl listener .ora file and then bounce the listener.
regards. 
I've tried to modify listener.ora manually, and got success.
Thanks.

STARTUP DATABASE FROM SQLPLUS

DEAR ALL,
I've shutdown the database from SQLPLUS.How to startup the database from sql plus.I tried to connect using sys and i recieve Listener doesn't know currently of service....
Thanks 
Is your litsener up? lsnrctl status.
then connect to sqlplus again and startup 
open a sqlplus worksheet
1. connect sys as sysdba;
2. startup nomount,
3 .alter database mount;
4. alter database open;
or short:
connect sys as sysdba;
startup open;
is this what u want?
greetings tommy 
Also if you have done the above and still get the message, leave a couple of moments and let the newly opened instance register itself with the Listener. 
I tried to connect using sys and i recieve
Listener doesn't know currently of service....Please post the exact command you used to connect from Sql*Plus. Also post your OS and Oracle version. 
Well on the command prompt type the following if you are on 10g:\
connect / as sysdba
startup
Hope this helps
Regards 
I've shutdown the database from SQLPLUS.How to
startup the database from sql plus.I tried to connect
using sys and i recieve Listener doesn't know
currently of service....Your errors seems that you were using sqlplus in client not in server to shudown
database and try to startup database.
If so, you need to config your listener.ora with static listener as well as dynamic listener.
HTH 
I've shutdown the database from SQLPLUS.How to
startup the database from sql plus.I tried to connect
using sys and i recieve Listener doesn't know
currently of service....Your errors seems that you were using sqlplus in client not in server to shudown
database and try to startup database.
If so, you need to config your listener.ora with static listener as well as dynamic listener.
HTH 
This is because by default oracle is configured to perform automatic listener instance self-registration, which is only possible if instance is up and running. You can still get connected if you perform this operation locally only. If you want to connect as sysdba remotely then you must configure instance manual registration by declaring your instance on the sid_list at the listener.ora file.
~ Madrid

Categories

Resources