Hi all,
I'm trying to duplicate a database in oracle 8i (Windows 2k), I did everything as the doc says (create a windows service,init file and configured the listener), but when I try to connect in the Dup database to startup it, the TNS Listener just can't find the database, there goes my listener.ora, is there anything wrong?
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC1-DG)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = PC1-DG)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = DUP.pc1dg)
(ORACLE_HOME = c:\oracle\ora81)
(SID_NAME = DUP)
)
(SID_DESC =
(GLOBAL_DBNAME = oradb04.pc1dg)
(ORACLE_HOME = c:\oracle\ora81)
(SID_NAME = oradb04)
)
)
Since Now Thanks, Pedro Valiati
Oracle LazyDBA home page