Listner and tnsnames configuration for oracle 8i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Listner and tnsnames configuration for oracle 8i

  1. #1
    Join Date
    Dec 2000
    Posts
    255
    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

    amol

  2. #2
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    The error may be TNS-12540. look into again.
    if that is the error. it is a memeory problem.
    read metalink doc 108180.1
    sonofsita
    http://www.ordba.net

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    can you do a tnsping hostname ?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Dec 2000
    Posts
    255
    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]

  5. #5
    Join Date
    May 2001
    Posts
    736
    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
    regards
    akhadar

  6. #6
    Join Date
    Dec 2000
    Posts
    255
    No

    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

    Amol

  7. #7
    Join Date
    May 2001
    Posts
    736
    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.
    regards
    akhadar

    [Edited by akhadar on 10-07-2001 at 06:42 AM]

  8. #8
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    you have two different ports.
    set them to 1521.
    Most commonly the Net8 listener
    listens on port 1521
    sonofsita
    http://www.ordba.net

  9. #9
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    I do not find sid_lis for the listener.

    may be that you omitted to paste.

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = )
    (ORACLE_HOME = )
    (SID_NAME = )
    )
    (SID_DESC =
    (GLOBAL_DBNAME = )
    (ORACLE_HOME = )
    (SID_NAME = )
    )
    )
    sonofsita
    http://www.ordba.net

  10. #10
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Here are some of the things.

    1.Confirm DNS is working
    Code:
       c:> nslookup host_name
    
       c:> nslookup ip_address
    They both should be the same. Don't post the output!


    2.Confirm the network connection to the server goes through.
    Code:
        c:> ping host_name
    Just confirm that you were able to ping again don't post your output to this forum

    3.Check your services have been started,
    Code:
       c:> net start
    Confirm that you see the following:

    OracleOraHome81TNSListener
    OracleServiceSID

    4.Confirm the sqlnet connection goes through
    Code:
         c:> tnsping service_name
    Post if you were to encounter any errors,

    5. If nothing works post me your sqlnet.ora which I would like to take a look.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width