Skip to Main Content
Forums

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Connected to an idle instance

474942Apr 23 2007 — edited May 3 2007
Hi,
I have the message 'Connected to an idle instance' when trying to connect to XE database without connect string :

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 23 13:57:59 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter password:
Connected to an idle instance.


I checked the envrironment variables as show below :


SQL>oracle@opaseweb1:~$ env | grep ORA
ORACLE_SID=XE
ORACLE_BASE=/usr/lib/oracle/xe/app/oracle
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
oracle@opaseweb1:~$

I ran sqlplus using connect sring and can connection succeded :


oracle@opaseweb1:~$ sqlplus system@XE

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 23 14:06:45 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL>


And when connecting without connect string I have

oracle@opaseweb1:~$ sqlplus system

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 23 14:07:44 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

Enter user-name:

Althought the isntance is running :

oracle@opaseweb1:~$ ps -ef | grep XE
oracle 1763 1 0 12:41 ? 00:00:02 oracleXE (LOCAL=NO)
oracle 13243 1 0 Apr11 ? 00:00:00 xe_pmon_XE
oracle 13245 1 0 Apr11 ? 00:00:00 xe_psp0_XE
oracle 13247 1 0 Apr11 ? 00:00:00 xe_mman_XE
oracle 13249 1 0 Apr11 ? 00:00:03 xe_dbw0_XE
oracle 13251 1 0 Apr11 ? 00:00:52 xe_lgwr_XE
oracle 13253 1 0 Apr11 ? 00:00:00 xe_ckpt_XE
oracle 13255 1 0 Apr11 ? 00:00:22 xe_smon_XE
oracle 13257 1 0 Apr11 ? 00:00:00 xe_reco_XE
oracle 13259 1 0 Apr11 ? 00:00:04 xe_cjq0_XE
oracle 13261 1 0 Apr11 ? 00:00:04 xe_mmon_XE
oracle 13263 1 0 Apr11 ? 00:00:00 xe_mmnl_XE
oracle 13265 1 0 Apr11 ? 00:00:00 xe_d000_XE
oracle 13267 1 0 Apr11 ? 00:00:01 xe_s000_XE
oracle 13269 1 0 Apr11 ? 00:00:01 xe_s001_XE
oracle 13271 1 0 Apr11 ? 00:00:00 xe_s002_XE
oracle 13273 1 0 Apr11 ? 00:00:00 xe_s003_XE
oracle 13289 1 0 Apr11 ? 00:00:01 xe_arc0_XE
oracle 13293 1 0 Apr11 ? 00:00:02 xe_arc1_XE
oracle 13299 1 0 Apr11 ? 00:00:00 xe_qmnc_XE
oracle 13309 1 0 Apr11 ? 00:00:00 xe_q000_XE
oracle 13570 6765 0 14:08 pts/6 00:00:00 grep XE
oracle 30210 1 0 Apr16 ? 00:00:00 xe_q001_XE
oracle@opaseweb1:~$


What could be the problem ?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 31 2007
Added on Apr 23 2007
4 comments
675 views