Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Location
    Singapore
    Posts
    5

    Unhappy Unanswered: Oracle Client to Server problems...

    Following are the config specs:

    The Client : Oracle 9i is running on WinXP
    The server : Oracle 9i database also running on XP ,but different machine and not in the local network, which connects to broadband via an Airport extreme router.

    The PC port 1000 has been mapped to the router port 1521 for the oracle listener.

    Now the issue is as folllows :

    I can connect if i use tnsping :

    tnsping dev2 returns the following :

    ************
    TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 23-AUG-20
    03 16:07:50

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

    Used parameter files:
    D:\oracle\ora92\network\admin\sqlnet.ora


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
    (HOST = diez)(PORT = 1000))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME
    = dev2.bex.vanila) (SID = dev2)))
    OK (110 msec)
    *******************

    But i cannot connect through sqlplus or the odbc client. I get a No listener error.

    I have attached the trc files output as attachment.

    here is the sqlnet.ora

    ********************
    Fatal NI connect error 12560, connecting to:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracl e)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES )(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=OR CL)(CID=(PROGRAM=D:\oracle\ora92\bin\sqlplus.exe)( HOST=NURANI)(USER=Vishi))))

    VERSION INFORMATION:
    TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
    Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
    Time: 23-AUG-2003 15:57:32
    Tracing to file: D:/TEMP\cli_2084_3.trc
    Tns error struct:
    nr err code: 0
    ns main err code: 12560
    TNS-12560: TNSrotocol adapter error
    ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 2
    nt OS err code: 0
    *****************************

    My tnsnames.ora looks like following :
    **************
    DEV2 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = diez)(PORT = 1000))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = dev2.bex.vanila)
    (SID = dev2)
    )
    )
    **************

    My sqlnet.ora looks like following :
    **************
    # SQLNET.ORA Network Configuration File: D:\oracle\ora92\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    SQLNET.DEFAULT_DOMAIN=bex.vanila

    LOG_DIRECTORY_CLIENT=D:\TEMP
    TRACE_DIRECTORY_CLIENT=D:/TEMP
    TRACE_LEVEL_CLIENT=16
    TRACE_UNIQUE_CLIENT=true



    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
    **************


    It will be great if someone can help.

  2. #2
    Join Date
    Aug 2003
    Posts
    1

    Re: Oracle Client to Server problems...

    Hi,
    You may want to check in Regedit, Local Machine/ftware/oracle/ entries.
    If there is anything wrong, change that.
    You may want to check on the path set .
    You may want to check for listener running. (if your db is running in the same machine, you don't need listener). If not running, start it and see.
    You may want to check in tnsnames.ora under network directory.
    Also, check you have more than one tnsnames.ora files in your system by any chance.
    If all fine, remove oracle entries in regedit, and reinstall oracle client software. Hope this helps you.


    Originally posted by vnurani
    Following are the config specs:

    The Client : Oracle 9i is running on WinXP
    The server : Oracle 9i database also running on XP ,but different machine and not in the local network, which connects to broadband via an Airport extreme router.

    The PC port 1000 has been mapped to the router port 1521 for the oracle listener.

    Now the issue is as folllows :

    I can connect if i use tnsping :

    tnsping dev2 returns the following :

    ************
    TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 23-AUG-20
    03 16:07:50

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

    Used parameter files:
    D:\oracle\ora92\network\admin\sqlnet.ora


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
    (HOST = diez)(PORT = 1000))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME
    = dev2.bex.vanila) (SID = dev2)))
    OK (110 msec)
    *******************

    But i cannot connect through sqlplus or the odbc client. I get a No listener error.

    I have attached the trc files output as attachment.

    here is the sqlnet.ora

    ********************
    Fatal NI connect error 12560, connecting to:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracl e)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES )(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=OR CL)(CID=(PROGRAM=D:\oracle\ora92\bin\sqlplus.exe)( HOST=NURANI)(USER=Vishi))))

    VERSION INFORMATION:
    TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
    Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
    Time: 23-AUG-2003 15:57:32
    Tracing to file: D:/TEMP\cli_2084_3.trc
    Tns error struct:
    nr err code: 0
    ns main err code: 12560
    TNS-12560: TNSrotocol adapter error
    ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 2
    nt OS err code: 0
    *****************************

    My tnsnames.ora looks like following :
    **************
    DEV2 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = diez)(PORT = 1000))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = dev2.bex.vanila)
    (SID = dev2)
    )
    )
    **************

    My sqlnet.ora looks like following :
    **************
    # SQLNET.ORA Network Configuration File: D:\oracle\ora92\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    SQLNET.DEFAULT_DOMAIN=bex.vanila

    LOG_DIRECTORY_CLIENT=D:\TEMP
    TRACE_DIRECTORY_CLIENT=D:/TEMP
    TRACE_LEVEL_CLIENT=16
    TRACE_UNIQUE_CLIENT=true



    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
    **************


    It will be great if someone can help.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: Oracle Client to Server problems...

    Originally posted by vnurani
    Following are the config specs:

    The Client : Oracle 9i is running on WinXP
    The server : Oracle 9i database also running on XP ,but different machine and not in the local network, which connects to broadband via an Airport extreme router.

    The PC port 1000 has been mapped to the router port 1521 for the oracle listener.

    Now the issue is as folllows :

    I can connect if i use tnsping :

    tnsping dev2 returns the following :

    ************
    TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 23-AUG-20
    03 16:07:50

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

    Used parameter files:
    D:\oracle\ora92\network\admin\sqlnet.ora


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
    (HOST = diez)(PORT = 1000))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME
    = dev2.bex.vanila) (SID = dev2)))
    OK (110 msec)
    *******************

    But i cannot connect through sqlplus or the odbc client. I get a No listener error.

    I have attached the trc files output as attachment.

    here is the sqlnet.ora

    ********************
    Fatal NI connect error 12560, connecting to:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracl e)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES )(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=OR CL)(CID=(PROGRAM=D:\oracle\ora92\bin\sqlplus.exe)( HOST=NURANI)(USER=Vishi))))

    VERSION INFORMATION:
    TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
    Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
    Time: 23-AUG-2003 15:57:32
    Tracing to file: D:/TEMP\cli_2084_3.trc
    Tns error struct:
    nr err code: 0
    ns main err code: 12560
    TNS-12560: TNSrotocol adapter error
    ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 2
    nt OS err code: 0
    *****************************

    My tnsnames.ora looks like following :
    **************
    DEV2 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = diez)(PORT = 1000))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = dev2.bex.vanila)
    (SID = dev2)
    )
    )
    **************

    My sqlnet.ora looks like following :
    **************
    # SQLNET.ORA Network Configuration File: D:\oracle\ora92\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    SQLNET.DEFAULT_DOMAIN=bex.vanila

    LOG_DIRECTORY_CLIENT=D:\TEMP
    TRACE_DIRECTORY_CLIENT=D:/TEMP
    TRACE_LEVEL_CLIENT=16
    TRACE_UNIQUE_CLIENT=true



    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
    **************


    It will be great if someone can help.
    ====================================
    The problem might involve the following:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)
    (PROGRAM=oracle)(ARGV0=oracleORCL)
    (ARGS='(DESCRIPTION=(LOCAL=YES)
    (ADDRESS=(PROTOCOL=beq)))'))
    (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\or a92\bin\sqlplus.exe)(HOST=NURANI)(USER=Vishi))))

    Everything above indicates that the connection attempt
    is using BEQ protocol to the local machine and is NOT
    using TCP to the remote machine. So I'd say, "Well of
    course it is going to fail!"

    Since I don't do Windoze, I don't understand why you
    are bothering with Port mapping. In the Unix world all
    ports below 1024 are reserved ports so using port 1000
    will likely not work as dersired.

    HTH & YMMV

    HAND!

  4. #4
    Join Date
    Aug 2003
    Posts
    2
    Try removing anyone of SQLNET.ORA or TNSNAMES.ORA file from the Network/Admin directory. Hope that would solve your problem.

Posting Permissions

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