At the time of login using scott/tiger I'm getting this error
Sm1 help me out :(

If you have just installed Oracle, you will need to start the instance. Is this Windows or UNIX?

Start the instance by :

1. Set your SID
2. Login : sqlplus /nolog
3. connect /as sysdba
4. startup

Try to login again.

Quote:

---

Originally Posted by DaBaAd

If you have just installed Oracle, you will need to start the instance. Is this Windows or UNIX?

Start the instance by :

1. Set your SID
2. Login : sqlplus /nolog
3. connect /as sysdba
4. startup

Try to login again.

---

Explain in detail ,and I'm using windows xp

When you install Oracle it installs a schema named Scott and the password is Tiger.

However after you install Oracle on windows, the service needs to be started otherwise the service is not active and you cannot access Oracle, therefore the 01034. Go to your services window on your server (workstation) and lookup any service starting with Oracle. There you will find several. Start all the ones that begin with Oracle.

Try this instead of the manual provisions I gave earlier. This is in case you wanted to use a DOS window.

Report back.

Please help

Installed oracle 8i on windows2003 server, got the message ORA-01034: ORACLE not available" Error

The instance may be started, but you have not started the database. Go into SQLPLUS and start the database. If you are not sure how to do this, it would be best to review the installation documentation stepXstep.