please inform me the steps of how to start Oracle9i
Printable View
please inform me the steps of how to start Oracle9i
sqlplus
conect sys as sysdba
startup
--
Better RTFM.
Sanjay
Hi,Quote:
Originally posted by pareshg
please inform me the steps of how to start Oracle9i
Which System/OS?
Orca
hmmmQuote:
Oracle DBA
Quote:
Originally posted by davey23uk
hmmm
Hi, the reason is :
under WIN2K i start as follow :
So only when i use the db really i start the NT-ServiceCode:net start OracleService[SID]
sqlplus /nolog @dbstart.sql
The same with shutdown.
Orca
:cool:
if its unix
login to os with dba group os user id
then
sqlplus /nolog
then
connec / as sysdba;
startup
same for shutdown
It is somewhat concerning.Quote:
Originally posted by davey23uk
hmmm
<--recusing myself from this one
Under WinK the DBA-Group_name is ORA_DBAQuote:
Originally posted by pgoenka
if its unix
login to os with dba group os user id
Orca
FYI Pls........
Login as DBA grup user
goto dos prompt.
start an oracle service as
1.oradim -new -sid SERVICE_NAME -intpwd PASSWORD -startmode a
-pfile "< Path for ur initSID.ora file>"
2.set oracle_sid=SERVICE_NAME
3.sqlplus /nolog
4.connect /as sysdba
5.startup
Regards,
Sudheer,
Project Lead,India