on 12-28-2009 8:39 AM
Hi,
I need to stop and oracle database via command line, but I´m not secure how to do it.
More thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
start:
brconnect -c -u / -f dbstart
stop:
brconnect -c -u / -f dbshut
Hi Ruben,
Start database
shell> sqlplus / as sysdba SQL> startup;
Stop database
shell> sqlplus / as sysdba SQL> shutdown immediate;
Documentation: http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/toc.htm
Regards
Stefan
But when i execute the sqlplus I get command not found. In which folder I can found the executable?
Hello Ruben,
on which platform are you running oracle?
The whole environment for the oracle instance is not set for every user .. it depends on the platform (Windows, Linux, Unix, etc.) which user you have to use.
It´s running on UNIX
in this case you have to switch to the user ora<SID> before you run the sqlplus command.
shell> su - ora<SID> (for example "su - orap01", if your SID is P01) shell> sqlplus / as sysdba .... ....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.