Re: password file question ...

Maxim Demenko wrote:
> sybrandb schrieb:
> > steph wrote:
> >>
> > If you want to be able to reach a mounted database, try using the
> > SID= syntax (as opposed to the service_name= syntax) in tnsnames.ora
> > Guess this is why OEM sticks to the SID syntax.
> > The listener must have been setup with a proper SID_LIST_<listener>
> > section.
> >
> >
> > Note, that if the database was really down the SID= syntax doesn't help
> > you either.
> >
> >
>
> How about this ?
>
> oracle_at_col-fc3-02:/opt/oracle/product/10gR2/network/admin >cat listener.ora
> # listener.ora Network Configuration File:
> /opt/oracle/product/10gR2/network/admin/listener.ora
> # Generated by Oracle configuration tools.
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = ORA102.world)
> (ORACLE_HOME = /opt/oracle/product/10gR2)
> (SID_NAME = ORA102)
> )
> )
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = col-fc3-02)(PORT = 1521))
> )
> )
>
> oracle_at_col-fc3-02:/opt/oracle/product/10gR2/network/admin >cat tnsnames.ora
> # tnsnames.ora Network Configuration File:
> /opt/oracle/product/10gR2/network/admin/tnsnames.ora
> # Generated by Oracle configuration tools.
>
> ORA102 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = col-fc3-02)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = ORA102.world)
> )
> )
> oracle_at_col-fc3-02:/opt/oracle/product/10gR2/network/admin >echo $ORACLE_SID
> ORA102
> oracle_at_col-fc3-02:/opt/oracle/product/10gR2/network/admin >sqlplus / as
> sysdba
>
> SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 12 12:27:28 2006
>
> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
> With the Partitioning, Oracle Label Security, OLAP and Data Mining
> Scoring Engine options
>
> SQL> grant sysdba to scott;
>
> Grant succeeded.
>
> SQL> shutdown immediate
> Database closed.
> Database dismounted.
> ORACLE instance shut down.
> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release
> 10.2.0.1.0 - Production
> With the Partitioning, Oracle Label Security, OLAP and Data Mining
> Scoring Engine options
> oracle_at_col-fc3-02:/opt/oracle/product/10gR2/network/admin >unset ORACLE_SID
> oracle_at_col-fc3-02:/opt/oracle/product/10gR2/network/admin >echo $ORACLE_SID
>
> oracle_at_col-fc3-02:/opt/oracle/product/10gR2/network/admin >ps -ef|grep pmon
> oracle 27511 2100 0 12:28 pts/0 00:00:00 grep pmon
> oracle_at_col-fc3-02:/opt/oracle/product/10gR2/network/admin >sqlplus
> scott/tiger_at_ora102 as sysdba
>
> SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 12 12:28:34 2006
>
> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
> Connected to an idle instance.
>
> SQL> startup
> ORACLE instance started.
>
> Total System Global Area 167772160 bytes
> Fixed Size 1218316 bytes
> Variable Size 88082676 bytes
> Database Buffers 75497472 bytes
> Redo Buffers 2973696 bytes
> Database mounted.
> Database opened.
> SQL>
>
>
> Best regards
>
> Maxim

Hey thanks. This really works!

regards,
stephan Received on Wed Jul 12 2006 - 06:32:06 CDT