ORA 01034 :tns error oracle not available

mistisona · #1 May 23, 2008, 03:01 AM

At the time of login using scott/tiger i m getting this error
sm1 help me out

DaBaAd · May 23, 2008, 04:47 AM

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.

mistisona · May 26, 2008, 02:15 AM

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

DaBaAd · May 31, 2008, 12:18 PM

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.

y2kinfosystems · Jul 4, 2008, 03:00 AM

Please help

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

DaBaAd · Jul 7, 2008, 08:26 AM

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.



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!