I am not in a position access metalink as I dont have account there. If you can help me out other way then I ll be very much thankful to you.

My first question is Whethere can I create 2 databases with same name on two different machines which are on same network?

I am giving the network conf file (listener.ora and tnsnames.ora) below. These are for my win 2000 machine.

Listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 2481))
)
)

and Tnsnames.ora is

GEODB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = geodb)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

The Sqlnet.ora file was never required to be modified. Can anyone tell me where is the problem.

There is one more thing. Before installing oracle my network administrator has changed the name of server. Earlier it was kenatilab and then now it is lab server.

However when I opened the tnsnames.ora I found the even installing oracle after changing the name of Serevr the tnsnames.ora and listener.ora were showing old name in HOST string. Does that mean that I have to reinstall oracle on that machine.

Now I tried both old name new name and also the IP address on that machine in place of HOST but still listener is not configured. it is still showing tns-01103 tns-12450 errors
when I say lsnrctl status.

thanks in Advance

Amol


Remember to edit your host/ip addresses before posting.

Sam

[Edited by sambavan on 10-09-2001 at 12:24 AM]