Osama_mustafa wrote:I dont't think this is correct: this what SQL*Plus STARTUP statement will do but if you don't use STARTUP statement and just want to connect to a local instance defined by ORACLE_SID and ORACLE_HOME SQL*Plus is not going to read SPFILE/FILE because it does not need to do it.
When you set ORACLE_SID , oracle will start looking for spfile for this instance to read the instance parameter that enable to start database , if nothing found Error will appear .
Edited by: P. Forstmann on 19 nov. 2012 08:36
[oracle@lx01 dbs]$ echo $ORACLE_SID DB112 [oracle@lx01 dbs]$ echo $ORACLE_HOME /u01/app/oracle/product/11.2.0/EE [oracle@lx01 dbs]$ ls -al $ORACLE_HOME/dbs/s* -rw-r----- 1 oracle oinstall 9748480 Jan 29 2012 /u01/app/oracle/product/11.2.0/EE/dbs/snapcf_DB112.f -rw-r----- 1 oracle oinstall 3584 Nov 19 08:53 /u01/app/oracle/product/11.2.0/EE/dbs/spfileDB112.ora.new [oracle@lx01 dbs]$ ls -al $ORACLE_HOME/dbs/i* ls: /u01/app/oracle/product/11.2.0/EE/dbs/i*: No such file or directory [oracle@lx01 dbs]$ sqlplus test/test SQL*Plus: Release 22.214.171.124.0 Production on Mon Nov 19 08:59:10 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select status from v$instance; STATUS ------------ OPEN SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 188.8.131.52.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
can u figure out what i m trying to say..difference between correct/incorrect sid's and relation between incorrect sid-idle instance..m not talking about pfile/spfile!!The terminology 'connected to idle instance' --- with that word 'connected' could be misleading, depending on one's own understanding. In nix, untill you issue a 'startup' there really is no instance. Go back and look at the definition of an instance. From the Concepts manual: "A database instance is a set of memory structures that manage database files". Until you issue a startup, there are no memory structures. Well, not in nix. In Windows, there is is this concept of the 'service' ...