OraFAQ Forum: Security » ORACLE NOT AVAILABL PLEASE HELP

Home » RDBMS Server » Security » ORACLE NOT AVAILABL PLEASE HELP

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORACLE NOT AVAILABL PLEASE HELP [message #182752]

Tue, 18 July 2006 01:10

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 ?

Report message to a moderator

Re: ORACLE NOT AVAILABL PLEASE HELP [message #182766 is a reply to message #182752]

Tue, 18 July 2006 02:21

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

Report message to a moderator

Re: ORACLE NOT AVAILABL PLEASE HELP [message #182771 is a reply to message #182752]

Tue, 18 July 2006 02:41

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.

Report message to a moderator

Re: ORACLE NOT AVAILABL PLEASE HELP [message #182777 is a reply to message #182771]

Tue, 18 July 2006 02:53

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Closed. Continue in your other thread on the same subject.

MHE

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 13 14:36:19 CDT 2025