Usually I start the database use
sqlplus / as sysdba
startup
works fine, but now I want to start with dbstart script, say I used $ORA_HOME/bin/dbstart $ORA_HOME, my log says
So far so good right? Now I do again sqlplus / as sysdba, it still says "Connected to an idle instance". Okay? and if I do sqlplus sys/password@orcl as sysdba and now I am connected to the right database. I don't understand why my sqlplus / as sysdba won't point me to the right database since my ORACLE_SID is set to orcl. What am I missing here? Strangely DBCONSOLE works fine too. I am so confused.
sqlplus / as sysdba
startup
works fine, but now I want to start with dbstart script, say I used $ORA_HOME/bin/dbstart $ORA_HOME, my log says
Code:
/home/oracle/oracle/product/10.2.0/db_1/bin/dbstart: Starting up database "orcl"
Fri Nov 16 11:13:11 CST 2007
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 16 11:13:12 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 1090519040 bytes
Fixed Size 2020128 bytes
Variable Size 301993184 bytes
Database Buffers 771751936 bytes
Redo Buffers 14753792 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
/home/oracle/oracle/product/10.2.0/db_1/bin/dbstart: Database instance "orcl" warm started.