G***o 发帖数: 5158 | 1 i connect using the client using internal/oracle
upon login i got
"Connected to an idle instance."
after i tryped
"select sysdate from dual"
ORA-01034: ORACLE not available
i checked the helpd document about this error code,
it says:
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 | G***o 发帖数: 5158 | 2 i checked services in administrator tools of control panel,
oracle is already started.
i'm using windows 2000 server, oracle 8i personal edition
what shall i do now?
thanks a lot.
【在 G***o 的大作中提到】![](/moin_static193/solenoid/img/up.png) : i connect using the client using internal/oracle : upon login i got : "Connected to an idle instance." : after i tryped : "select sysdate from dual" : ORA-01034: ORACLE not available : i checked the helpd document about this error code, : it says: : ORA-01034 ORACLE not available : Cause: Oracle was not started. Possible causes include the following:
| w*****h 发帖数: 139 | 3 Database Server is started, but instance is not started.
Run "startup" in sqlplus.
【在 G***o 的大作中提到】![](/moin_static193/solenoid/img/up.png) : i checked services in administrator tools of control panel, : oracle is already started. : i'm using windows 2000 server, oracle 8i personal edition : what shall i do now? : thanks a lot.
| a***a 发帖数: 39 | 4 One thing you might want to check is you need to set up
ORACLE_SID
before you run svrmgr or sqlplus from command prompt.
If Oracle create the database for you then the sid should be
ORCL.
another possibility is as wangfsh pointed out, instance may
not started.
【在 G***o 的大作中提到】![](/moin_static193/solenoid/img/up.png) : i checked services in administrator tools of control panel, : oracle is already started. : i'm using windows 2000 server, oracle 8i personal edition : what shall i do now? : thanks a lot.
|
|