Problème de connexion/listener
(RE) Bonjour !
J'ai un autre souci sur mon serveur ... :oops:
Oracle 9i - HP/UX :
Il y a quelquechose que je ne comprends pas :
lorsque j'effectue :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13
| tnsping PINDB_CMS
TNS Ping Utility for HPUX: Version 9.2.0.5.0 - Production on 08-SEP-2005 14:13:07
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/app/oracle/ora9205/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = vdcrcms)(PORT = 1522))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pindb)))
OK (10 msec) |
Mais :
Code:
1 2 3 4 5 6 7 8 9 10 11
| sqlplus pin/mdp@PINDB_CMS
SQL*Plus: Release 9.2.0.5.0 - Production on Thu Sep 8 14:10:09 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Enter user-name: |
Alors que :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| export ORACLE_SID=pindb
vdcrcms: /app/oracle/ora9205/network/admin > sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.5.0 - Production on Thu Sep 8 14:17:04 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
JServer Release 9.2.0.5.0 - Production
SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_
----------------- --------- ------------ --- ---------- ------- -----------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST
---------- --- ----------------- ------------------ ---------
1 pindb
vdcrcms
9.2.0.5.0 08-SEP-05 OPEN NO 1 STARTED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL |
Je ne comprend pas comment cela est-il possible ?
Sachant qu'il y a 40 fichier tnsnames.ora/listener.ora, je pense que je pointe sur des bases différentes, mais vu le tnsping, on est bien sur la même base :?: 8O
MErci pour votre aide :oops:
Cordialement,