Database Problem [message #369233] |
Fri, 21 July 2000 15:08 |
Suresh.N
Messages: 41 Registered: March 2000
|
Member |
|
|
Hi,
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?
Thanks
Suresh.N
|
|
|
|
Re: Database Problem [message #369242 is a reply to message #369238] |
Tue, 25 July 2000 18:59 |
Sam
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.
rgds
sam
|
|
|