OraFAQ Forum: Server Administration » ORACLE not available PLEASE HELP

Home » RDBMS Server » Server Administration » ORACLE not available PLEASE HELP

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

ORACLE not available PLEASE HELP [message #182754]

Tue, 18 July 2006 01:20

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 available PLEASE HELP [message #182759 is a reply to message #182754]

Tue, 18 July 2006 01:45

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It seems that Oracle database is shut down. In order to make it available, start it up.

Quote:

ORA-01034 ORACLE not available

Cause: Oracle was not started. Possible causes include the following:

The SGA requires more space than was allocated for it.

The operating-system variable pointing to the instance is improperly defined.

Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform-specific Oracle documentation.

Report message to a moderator

Re: ORACLE not available PLEASE HELP [message #182772 is a reply to message #182759]

Tue, 18 July 2006 02:44

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

If you're on Windoze, then check that the Service for the database is started. If it isn't, then start it, and also check that the Listener is started too.

If the service is started, then connect to sql*plus as sysdba