asked on

netca is giving error while deleting listener and configuring

Hello experts,

i am having the problem,while creating listener. here is the error message. could you please guide me to fix this problem.

oracle$ ./netca

Oracle Net Services Configuration:
Configuring Listener:LISTENER
ServiceAliasException: Could not save Service Alias: TNS-04406: Object already exists
Default local naming configuration complete.
qispoemdb01...
qispoemdb02...
Listener configuration complete.
Configuring Listener:LISTENER
qispoemdb01...
qispoemdb02...
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0

fluglash

show your $ORACLE_HOME/network/admin/listener.ora file

pavan27

ASKER

Experts,

here is the listener.ora file entry.

# listener.ora.qispoemdb01 Network Configuration File: /opt/mis/oracle/product/db/network/admin/listener.ora.qispoemdb01
# Generated by Oracle configuration tools.

SID_LIST_LISTENER_QISPOEMDB01 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/mis/oracle/product/db)
(PROGRAM = extproc)
)
)

LISTENER_QISPOEMDB01 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = qispoemdb01-vip)(PORT = 1522)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.6.37)(PORT = 1522)(IP = FIRST))
)
)

ASKER CERTIFIED SOLUTION

fluglash

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pavan27

ASKER

i have fixed the problem, by dropping the listener and cleanup listener.ora and tnsnames.ora files.

Thanks for helping me