start Oracle database
can I get step by step instructions how to start oracle database from command prompt or sqlplus. Enterprise manager is showing status shutdown but I am not able to start it up from Enterprise manager because it cannot access the database.
>>$ sqlplus / as sysdba
To clarify:
This is while logged into the database server as a member of the OS DBA group.
To clarify:
This is while logged into the database server as a member of the OS DBA group.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
I am getting ORA_12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach) in enterprise manager
Did the database start up?
Did it register with the listener (this can take a few minutes if you are using automatic registration)?
from a command prompt: lsnrctl status
Did it register with the listener (this can take a few minutes if you are using automatic registration)?
from a command prompt: lsnrctl status
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
I am new to this stuff. I did not issue the startup command yet. Should I just go to SQlplus and issue the alter command.
>>I did not issue the startup command yet.
If you haven't started up the database Enterprise Manager will not respond so I'm not sure what you are trying to tell us in http:#a37102781
>>Should I just go to SQlplus and issue the alter command.
The alter command is for AFTER the database is started and the listener is up and running.
If you haven't started up the database Enterprise Manager will not respond so I'm not sure what you are trying to tell us in http:#a37102781
>>Should I just go to SQlplus and issue the alter command.
The alter command is for AFTER the database is started and the listener is up and running.
ASKER
It is not responding.. Enterprise manager is not able to connect to databse instance it just pops up error above under Agent connection to instance and wants me to startup but the startup does not work because there is no connection to the database. Status of databas is shutdown mode.
>>Enterprise manager is not able to connect to databse instance
Did you startup the database using the sqlplus command posted above or the OracleService if on Windows?
Did you startup the database using the sqlplus command posted above or the OracleService if on Windows?
what exactly have you tried and what exactly were the responses?
please cut-and-paste the text (not a screen capture) of what you did with sql*plus
please cut-and-paste the text (not a screen capture) of what you did with sql*plus
ASKER
server was rebooted and this error showed up. have not done anything with sql plus yet
>>have not done anything with sql plus yet
Why not? The question you asked was how to startup the database through a command prompt.
That was provided in the very first post.
If you have not done this, why not?
Why not? The question you asked was how to startup the database through a command prompt.
That was provided in the very first post.
If you have not done this, why not?
Please tell us:
1. What is your server O/S?
2. Do you know which version of Oracle you have?
3. Do you have an O/S login account that you can use on the database server that is the owner of the Oracle software?
1. What is your server O/S?
2. Do you know which version of Oracle you have?
3. Do you have an O/S login account that you can use on the database server that is the owner of the Oracle software?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SQL> startup