Error Code 01034? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Error Code 01034?

Error Code 01034?# Database - 数据库

G*o2000-08-06 07:08

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*o2000-08-06 07:08

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 的大作中提到】

: 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*h2000-08-06 07:08

3 楼

Database Server is started, but instance is not started.
Run "startup" in sqlplus.

【在 G***o 的大作中提到】

: 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*a2000-08-06 07:08

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 的大作中提到】

: 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.