DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 24

Thread: SqlPlus connection error ORA-12545

  1. #11
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Could you provide me the OS and DB version of your server and the clients... Is your DB us SE/EE?

    Code:
    mts_dispatchers = "(protocol=TCP)(DISPATCHERS=2)" 
    mts_servers = 5
    mts_max_servers = 10 
    mts_max_dispatchers = 10

    Sam

    [Edited by sambavan on 10-30-2001 at 03:55 PM]
    Thanx
    Sam



    Life is a journey, not a destination!


  2. #12
    Join Date
    Apr 2001
    Posts
    35
    Here is the result. I noticed the dispatcher host is NT3.MYCOMPANY.NET instead of just NT3. I think it is caused by the recent DNS configuration of the machine into the MYCOMPANY.NET domain, while before it was empty.

    C:\>lsnrctl services

    LSNRCTL for 32-bit Windows: Version 8.1.7.2.0 - Production on 30-OCT-2001 15:56:
    44

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=111.111.111.11)(PORT=1521)))
    Services Summary...
    PLSExtProc has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
    LOCAL SERVER
    orcl has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
    LOCAL SERVER
    orcl has 2 service handler(s)
    DEDICATED SERVER established:1 refused:0
    LOCAL SERVER
    DISPATCHER established:5 refused:0 current:0 max:1022 state:ready
    D000
    (ADDRESS=(PROTOCOL=tcp)(HOST=nt3.MYCOMPANY.NET)(PORT=1664))
    The command completed successfully

  3. #13
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What do you get when you do

    Code:
     
    
    select * from global_name;

    This should be the service name in your tnsnames.ora file.

    Could you check that please...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #14
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    also please post your sqlnet.ora file specs


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #15
    Join Date
    Apr 2001
    Posts
    35
    OS is NT4.0 Sp6; DB is Oracle8.1.7.2.1.

    The global name was orcl.world. But after changed to orcl.nt3, the result is the same. The global_name does not affect the connection (as by definition, it affects dblinks), since the tnsname is using service_name defined as orcl.nt3.

    SQLNET.ORA

    SQLNET.AUTHENTICATION_SERVICES= (NTS)
    NAMES.DIRECTORY_PATH= (TNSNAMES)

    It just seems that the dispatcher constructed the host name from the DNS setup. How can I force it to be nt3 instead of nt3.mycompany.net?

    *********
    DISPATCHER established:5 refused:0 current:0 max:1022 state:ready
    D000
    (ADDRESS=(PROTOCOL=tcp)(HOST=nt3.MYCOMPANY.NET)(PORT=1664))
    ************

  6. #16
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Now, could you comment out the

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    in your sqlnet.ora file and try the connection again.

    On the other hand you can set the

    local_listener = "(Address=(PROTOCOL=TCP)(HOST=...)(PORT=1521))"

    in your initSID.ora file and restart the instance and then check that the dispatcher registers the correct server. Also make sure that things are configured as you want in the listener.ora file too...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #17
    Join Date
    Apr 2001
    Posts
    35
    Still no luck. I am going to contact Oracle support.

  8. #18
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Did you configure your host name to the dispatcher host name and try?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  9. #19
    Join Date
    Apr 2001
    Posts
    35
    Yes. Same result.

  10. #20
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Ann,

    I couldn't think of any thing more other than this

    MTS_DISPATCHERS = "(ADDRESS= (PROTOCOL=TCP)(HOST=chmweckerl1) ) (DISPATCHERS=4)"

    Stop and start the instance

    check listener services and try your connection again...
    Extract from metalink
    You can fix the problem by adding the Oracle listener host name and IP to the
    hosts file on the Microsoft client machine.

    The file is located in the following directory:

    C:\WINNT\system32\drivers\etc

    The filename is "hosts"

    Edit the file to include the IP address and the host name of the Oracle server
    to which you wish to connect, thus:

    126.34.10.244 hostname.domainname.com hostname othernames


    Be careful not to add any extention to the file when saving it.

    This is a workaround in the absence of a domain names server (DNS). The best
    thing is to have DNS up and running and the client configured to use it.

    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