Pb lsnrctl - Message 850

Version imprimable

Hello,

Je suis sous solaris 5.10 / Oracle 10.1.0.3

J'ai un soucis avec lsnrctl aujourd'hui et je cherche encore pourquoi.

Code:

1
2
3
4
5
6
7
8
9
 
-bash-3.00$ lsnrctl
 
LSNRCTL for Solaris: Version 10.1.0.3.0 - Production on 19-AVR. -2006 11:53:07
 
Copyright (c) 1991, 2004, Oracle.  All rights reserved.
 
Message 850 not found; No message file for product=network, facility=NL
LSNRCTL> quit

Mes variables d'environnement semble correct :

Code:

1
2
3
4
5
6
 
LSNRCTL> quit
-bash-3.00$ env | grep ORA
ORACLE_SID=CFPROD
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/opt/oracle/product

J'ai testé en faisant ça :

Code:

1
2
 
-bash-3.00$ export TNS_ADMIN=/opt/oracle/product/network/admin/

et j'ai la même erreur ;(

voici le listener.ora :

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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
 
-bash-3.00$ cat /opt/oracle/product/network/admin/listener.ora
# listener.ora Network Configuration File: /opt/oracle/product/network/admin/listener.ora
 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product)
      (PROGRAM = extproc)
    )
  )
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = oracle2)(PORT = 1521))
      )
    )
  )
-bash-3.00$ cat /opt/oracle/product/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /export/home/oracle/product/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
 
CFPROD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle2)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = CFPROD)
    )
  )
 
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

Aucune modification n'a été apportée et cela fonctionnait bien avant. Je peux accéder à la base en local sans problème. Voici le netstat :

Code:

1
2
3
4
5
 
-bash-3.00$ netstat -an | grep 1521
192.168.242.2.53627  192.168.242.2.1521   49152      0 49152      0 ESTABLISHED
192.168.242.2.1521   192.168.242.2.53627  49152      0 49152      0 ESTABLISHED
      *.1521               *.*                0      0 49152      0 LISTEN

Si quelqu'un a une idée ???

@+

Petit détail :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
-bash-3.00$ tnsping
 
TNS Ping Utility for Solaris: Version 10.1.0.3.0 - Production on 19-APR-2006 16:17:25
 
Copyright (c) 1997, 2003, Oracle.  All rights reserved.
 
TNS-03502: Message 3502 not found; No message file for product=network, facility=TNS
-bash-3.00$ oerr tns 3502
03502, 00000, "Insufficient arguments.  Usage:  tnsping <address> [<count>]"
// *Cause:  Some required command-line arguments are missing.
// *Action: Re-enter the command using the correct arguments.
-bash-3.00$ which tnsping
/opt/oracle/product/bin/tnsping
-bash-3.00$ which oerr
/opt/oracle/product/bin/oerr

8O8O8O8O8O8O8O8O8O8O8O

c'est à ni rien comprendre ... Je n'arrive absolument pas à identifier le problème

19/04/2006, 16h22
bouyao
Ca fait quoi ?
Code:

1 2 tnsping CFPROD

hé bien le tnsping fonctionne, mais l'affichage est bizarre :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
-bash-3.00$ tnsping CFPROD
 
TNS Ping Utility for Solaris: Version 10.1.0.3.0 - Production on 19-APR-2006 16:42:05
 
Copyright (c) 1997, 2003, Oracle.  All rights reserved.
 
Message 3511 not found; No message file for product=network, facility=TNSMessage 3512 not found; No message file for product=network, facility=TNSAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oracle2)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = CFPROD)))
Message 3509 not found; No message file for product=network, facility=TNS
-bash-3.00$ oerr tns 3511
03511, 00000, "Used parameter files:\n%s\n"
// *Cause:  Prints out the path of the parameter files(sqlnet.ora,tnsnames.ora)
//          used in the process of resolving the NAME.
// *Action: NONE
-bash-3.00$ oerr tns 3509
03509, 00000, "OK (%d msec)"
// *Cause:  The operation succeeded, in this amount of time.
// *Action: No action necessary.

il ne trouve tout simplement pas les messages alors que la commande 'oerr' les trouvent ...
Etrange, d'autant plus que je devais ajouter des listener et que je n'ai eu aucun problème pour les start ...

19/04/2006, 18h41
LeoAnderson
Avez-vous positionné votre environnement Unix, en particulier les variables
- $ORACLE_HOME
- $PATH=$ORACLE_HOME/bin:$PATH
- $LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

oui

Code:

1
2
3
4
5
6
7
 
-bash-3.00$ env | egrep -e '(ORA|PATH|LD)'
LD_LIBRARY_PATH=/opt/oracle/product/lib:/opt/oracle/product/network/lib:
ORACLE_SID=CFPROD
ORACLE_BASE=/opt/oracle
PATH=/opt/oracle/product/bin:/opt/oracle/product/OPatch:/opt/oracle/product/jre/1.4.2/bin:/opt/oracle/product/jdk/bin:/usr/ccs/bin/:/bin:/sbin:/usr/local/bin:/usr/usb/bin:/usr/sbin/:/usr/bin
ORACLE_HOME=/opt/oracle/product

et dans ~/.profile :

Code:

1
2
3
4
5
6
7
8
9
 
-bash-3.00$ cat ~/.profile | egrep -e '(ORA|PATH|LD)'
ORACLE_BASE=/opt/oracle
ORACLE_HOME=$ORACLE_BASE/product
ORACLE_SID=CFPROD
TNS_ADMIN=$ORACLE_HOME/network/admin
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/jre/1.4.2/bin:$ORACLE_HOME/jdk/bin:/usr/ccs/bin/:/bin:/sbin:/usr/local/bin:/usr/usb/bin:/usr/sbin/:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib:$LD_LIBRARY_PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID NLS_LANG PATH LD_LIBRARY_PATH TMPDIR PATH TEMP TNS_ADMIN