Re: password file question ...

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Wed, 12 Jul 2006 12:25:52 +0200
Message-ID: <44b4cfa9$0$29143$9b4e6d93@newsread4.arcor-online.net>

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

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

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 Received on Wed Jul 12 2006 - 05:25:52 CDT