Home » RDBMS Server » Server Administration » Database Problem
Database Problem [message #369233] Fri, 21 July 2000 15:08 Go to next message
Messages: 41
Registered: March 2000

I have one Oracle 8i Database called DB1.
After that I created another Database called DB2 by Database Cofiguraion Assistant in the Same Machine.
After creating the database DB2 , DB1 is not working.
DB2 is working perfectly.
In contol Panal service All database services (DB1 and DB2) are started sucssfully.

But When I connect to DB1 it is saying Oracle Not Avilable.

The error is
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.

How Can i increase the SGA Space ?

or What else i do ?

Can you give me a solution?

Re: Database Problem [message #369238 is a reply to message #369233] Mon, 24 July 2000 10:42 Go to previous messageGo to next message
Messages: 1
Registered: July 2000
Junior Member
What is your ORACLE_SID value ?

Re: Database Problem [message #369242 is a reply to message #369238] Tue, 25 July 2000 18:59 Go to previous message
Messages: 255
Registered: April 2000
Senior Member
set your oracle sid and home corresponding to the db and try to connect (if its started)..other wise try to start and connect.
Previous Topic: DBA_Tables info is not accurate
Next Topic: redo log space request - what is the ideal size?
Goto Forum:

Current Time: Mon May 27 22:14:23 CDT 2024