Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto dbstart on Linux problems and confusions

Status
Not open for further replies.

sillyVM

Technical User
Feb 14, 2007
144
US
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
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.
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.
 
Greetings,

Which Linux are you using?

Regards,



William Chadbourne
Oracle DBA
 
It's ubuntu server 7.04, does it matter? I installed by making the installer think it's a redhat.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top