-
how to start oracle9i
please inform me the steps of how to start Oracle9i
-
sqlplus
conect sys as sysdba
startup
--
Better RTFM.
Sanjay
-
Re: how to start oracle9i
Originally posted by pareshg
please inform me the steps of how to start Oracle9i
Hi,
Which System/OS?
Orca
-
-
Originally posted by davey23uk
hmmm
Hi, the reason is :
under WIN2K i start as follow :
Code:
net start OracleService[SID]
sqlplus /nolog @dbstart.sql
So only when i use the db really i start the NT-Service
The same with shutdown.
Orca
-
if its unix
login to os with dba group os user id
then
sqlplus /nolog
then
connec / as sysdba;
startup
same for shutdown
"Be not afraid of growing slowly. Be afraid only of standing still."
-
Originally posted by davey23uk
hmmm
It is somewhat concerning.
OCP 8i, 9i DBA
Brisbane Australia
-
<--recusing myself from this one
-
Originally posted by pgoenka
if its unix
login to os with dba group os user id
Under WinK the DBA-Group_name is ORA_DBA
Orca
-
Hello
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|