Is there any difference in tns and listener conf for oracle 8i on windows 2000 and NT server.
I have installed oracle 8i on NT where it is working fine and just now I have installed Oracle 8i (same version) on win2000 on a machine and I have given the same name to global database name which I have on win nt machine
While configuring on 2000 I found that listner is not properly set. I have set the machine's listener.ora file very correctly, Even I have tried using ipaddress at the place of host in the 2000 machine still listener is giving problem
Is this problem bcos of same name of database on 2000 machine (I am getting tns-01103, tns-12450 here description said problem with ADDRESS but I found my syntax was absolutely the same as of NT except).
is there problem bcos of global naming
10-06-2001, 02:20 PM
The error may be TNS-12540. look into again.
if that is the error. it is a memeory problem.
read metalink doc 108180.1
10-06-2001, 08:49 PM
can you do a tnsping hostname ?
10-07-2001, 03:49 AM
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.
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
Remember to edit your host/ip addresses before posting.
[Edited by sambavan on 10-09-2001 at 12:24 AM]
10-07-2001, 05:45 AM
u have not replied for sambavan question. Did u tested the TNSPING utility to test the hostname.one more thing in your LISTENER printout u didnot specifed the second part which describes SID_LIST_LISTENER.check the second part of LISTENER.
all the best
10-07-2001, 06:26 AM
Just now It was started (Listener). In morning my net admin started the machine and it was tested. I dont know how it was started but it started. I have just stopped the listener and tried to started it again and it got locked. Since 15 min it is starting only. I guess this is a problem with win 2000 what u guys think.
Hi Sambavan, Khadar, It is was not pinging . the error was tns-12541 After it was started it was pinging and when I stopped it again the same error (I am pinging from another machine where I have oracle on nt). I have typed LSNRCTL>start but it is not starting. I dont know in early morning how it was started. Do I have to make shutdown and restart
10-07-2001, 07:36 AM
Its not the problem with the Windows2000 as iam using the same platform with Oracle 8i. Surely the problem lies with the way u are using the IPaddress and hostnames. Better check this as the the address which u are giving in your TNSPING is not able to match with the address given in your LISTENER and TNSNAMES. check with your system and network connection also.
[Edited by akhadar on 10-07-2001 at 06:42 AM]
10-09-2001, 12:10 AM
you have two different ports.
set them to 1521.
Most commonly the Net8 listener
listens on port 1521