Oracle Database Discussions

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!

ORA-01506: missing or illegal database name

Ant13Feb 14 2013 — edited Feb 15 2013

I cannot startup the database instead I get the above error. Please help

[oracle@localhost /]$ pwd
/
[oracle@localhost /]$ cd /u01/app/oracle
[oracle@localhost oracle]$ export ORACLE_BASE=/u01/app/oracle
[oracle@localhost oracle]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
[oracle@localhost oracle]$ export ORACLE_SID=orcl
[oracle@localhost oracle]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@localhost oracle]$ export TNS_ADMIN=/u01/app/oracle/product/11.2.0/dbhome_1/network/admin
[oracle@localhost oracle]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 14 17:33:11 2013

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

Connected to an idle instance.

SQL> startup
ORA-01506: missing or illegal database name
SQL>

This post has been answered by Srini Chavali-Oracle on Feb 14 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 15 2013

Added on Feb 14 2013

#general-database-discussions

10 comments

22,273 views