Pb erreur: ORA-12154

[ZueB]

On obtient cette erreur quand on veut lancer la commande : rman catalog rman/rmanpwd[@aliascatalog]


Avant on a exécuter ces commandes dans SQL*PLUS :

create tablespace rman_ts_data datafile '/u01/oradata/ENTERPR1/rman_ts_data01.dbf' size 50M ;
create user rman identified by rmanpwd default tablespace RMAN_TS_DATA;
grant connect, resource, recovery_catalog_owner to rman;


On a cherché d'où pouvait venir l'erreur, le fichier tnsnames.ora a la configuration suivante :

INST1_HTTP.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.domain)(PORT=1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ENTERPR1.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ENTERPR1)
)
)


dans listener.ora:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(DESCRIPTION=
(ADDRESS=(PROTOCOL= TCP)(HOST=localhost.localdomain)(PORT=1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC=
(SID_NAME = XBC)
(OACLE_HOME = /u01/OraHome1)
(PROGRAM=extproc)
)
(SID_DESC =
(GLOVAL_DBNAME = ENTERPR1)
(ORACLE_HOME = /u01/OraHome1)
(SID_NAME = ENTERPR1)
)
)


Execution de lsnrctl services :

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
Services Summary...
Service "ENTERPR1" has 1 instance(s)
Instance "ENTERPR1", status UNKNOWN, has 1 handlers(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s)
Instance "PLSExtProc", status UNKNOWN, has 1 handlers(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
[/code]

[pifor]

D'après vos fichiers Oracle Net,
il faut que rman se connecte à ENTERPR1 ou MODOSE et non à "aliascatalog".

[ZueB]

erf erreur bete, mais en le remplacant, et en relançant lsnrctl services j'obtient la meme erreur:TNS 12541 Tns no listener...

[pifor]

Si le listener est arrêté, essayez de relancer le listener avec:

Code :

1
2
 
lsnrctl start

[pifor]

Avez-vous modifié les 2 fichiers: listener.ora et tnsnames.ora ?