Home » RDBMS Server » Security » ORACLE NOT AVAILABL PLEASE HELP
ORACLE NOT AVAILABL PLEASE HELP [message #182752] Tue, 18 July 2006 01:10 Go to next message
Khamkhahe
Messages: 12
Registered: June 2006
Location: Islamabad
Junior Member

Hello Dears

I have some problums during Login in to ORACLE Database.... When i'm entering user Name and Pasword then following message is displaying....

User Name: system || Or miak
Password: manager || kia

Error occur ORA-01034: ORACLE not available

PLEASE HELP ME What i can do ?

My all database (tables) are not accessable.....please what i can do ?
Re: ORACLE NOT AVAILABL PLEASE HELP [message #182766 is a reply to message #182752] Tue, 18 July 2006 02:21 Go to previous messageGo to next message
cmkarpagam
Messages: 1
Registered: June 2006
Location: bangalore
Junior Member

Hi,

in oracle 8i, if some services are not restarted properly this type of error will come. to solve this problem you goto start -> program files -> administrative tools -> service - you checked oracle services. if it is stop you start that service.
than it will work

bye
karpagam
Re: ORACLE NOT AVAILABL PLEASE HELP [message #182771 is a reply to message #182752] Tue, 18 July 2006 02:41 Go to previous messageGo to next message
rtjk
Messages: 33
Registered: February 2005
Member
Hi,

This error may come even if the db is started.
Go to cmd prompt.type sqlplus /nolog
connect /as sysdba
startup;


Then connect to the specific user with the password and try..
Also check for the services and make it as automatic.If it is manual, then for each shutdown of ur system , u have to face this error.

bye.
jay.
Re: ORACLE NOT AVAILABL PLEASE HELP [message #182777 is a reply to message #182771] Tue, 18 July 2006 02:53 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Closed. Continue in your other thread on the same subject.

http://www.orafaq.com/forum/fa/448/0/

MHE
Previous Topic: obtaining security reports on users on different hosts
Next Topic: GRANT ALL on a schema
Goto Forum:
  


Current Time: Fri Mar 29 06:27:21 CDT 2024