Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2003
    Posts
    7

    Unanswered: Oracle not available

    Hi DBAs,

    We have created a UTF8 oracle database. We are able to connect to it from the server itself. But when we try to connect it from client machine it fails to do so throwing 'ORACLE not available'. But when we use 'TNSPING servicename' it is pinging to it. We tried even configuring client thru NET CONFIGURATION ASSISTANT where it fails when we ask for 'Test the connection'.

    Details:
    OS : SUN SOLARIS 8 (Server)
    Windows2000 (Client)
    Oracle 8.1.7 (Both server and client)

    Since UNIX is case-sensitive we had taken care in naming the SID name in init.ora, tnsnames.ora, listener.ora as the same, lower case. We have the rwsr-s--x permissions for oracle and tnslsnr files in orahome/bin also. even then we are unable to connect from client machine. any help is appreciable.

    Thanks in advance

    Raju

  2. #2
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Arrow Windows Client Connection

    Raju
    Yesterday itself, I was finally able to get the connection between my server (oracle) and the client (windows).
    Make sure that TNS listener is running on the server, as that is one of the main reasons the connection fails.
    Also check the tnsnames.ora on the client for correctness. Also check the port in the tnsnames.ora matches that on the server.
    Let me know if it helps or else we get into more details.
    Thanx and Regards
    Aruneesh

  3. #3
    Join Date
    Jun 2003
    Posts
    7

    oracle not available

    Thanks for ur response..I verified tnsnames.ora and listener.ora files. they are correct only and listener is also up. One thing here is If I use IP I am able to ping to my server but If I use hostname it doesn't. Does it matter? For ur reference I am sending you the trace info from listener and network as well..Help me to come out of this head-ache plz..???

    (part of listener log)

    TNSLSNR for Solaris: Version 8.1.5.0.0 - Production on 19-JUL-03 18:07:41

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


    --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
    New trace stream is "/u01/app/oracle/product/8.1.5/network/trace/listener.trc"
    New trace level is 16
    --- TRACE CONFIGURATION INFORMATION ENDS ---
    nsinherit: entry
    nsinherit: doing connect handshake...
    nsc2addr: entry
    nlpcaini: entry
    nlpcaini: No process parameters set
    nlpcaini: exit
    nsc2addr: normal exit
    nsinherit: inheriting the connection...
    nsopen: entry
    nsmal: entry
    nsmal: 428 bytes at 0xf88d8
    nsmal: normal exit
    nsopenmplx: entry
    nsmal: entry
    nsmal: 1620 bytes at 0xf8a90
    nsmal: normal exit
    nsopenmplx: normal exit
    nsopen: opening transport...
    nsopen: transport is open
    nsnainit: entry
    nsnainit: inherit
    nsnadct: entry
    nsnadct: normal exit
    nsnasvnainfo: entry
    nsnasvnainfo: NA disabled for this connection
    nsnasvnainfo: normal exit
    nainit: entry
    nagblini: entry
    nau_gin: entry
    nau_gparams: entry
    nam_gbp: Reading parameter "sqlnet.authentication_required" from parameter file
    nam_gbp: Parameter not found
    nau_gparams: Using default value "FALSE"
    nau_gslf: entry
    nam_gic: entry
    nam_gic: Counting # of items in "sqlnet.authentication_services" parameter
    nam_gic: Parameter not found
    nam_gic: Found 0 items
    nam_gic: exit
    nau_gslf: Using default value "all available adapters"
    nauss_set_state: entry
    nauss_set_state: exit
    nau_gslf: exit
    nau_gparams: exit
    nau_gin: exit
    nagblini: exit
    na_saveprot: entry
    na_saveprot: exit
    nacomin: entry
    nas_init: entry
    nas_init: exit
    nau_ini: entry
    naugcp_get_connect_parameters: entry
    nauss_set_state: entry
    nauss_set_state: exit
    naugcp_get_connect_parameters: exit
    nau_gettab: entry
    nau_gettab: using authentication adapter table "nautab"
    nau_gettab: nautab contains the following services:
    nau_gettab: OSS
    nau_gettab: exit
    nau_sini: entry
    nau_sini: exit
    nau_ini: connection type: "standard"
    nau_ini: exit
    naeeinit: entry
    nam_gbp: Reading parameter "SQLNET.FIPS_140" from parameter file
    nam_gbp: Parameter not found
    nam_gnsp: Reading parameter "SQLNET.ENCRYPTION_SERVER" from parameter file
    nam_gnsp: Parameter not found
    naequad: Using default value "ACCEPTED"
    nam_gic: entry
    nam_gic: Counting # of items in "SQLNET.ENCRYPTION_TYPES_SERVER" parameter
    nam_gic: Parameter not found
    nam_gic: exit
    naesno: Using default value "all available algorithms"
    naeshow: entry
    naeshow: These are the encryption algorithms that the server will accept, in decreasing order of preference:
    naeshow: Choice 0: no algorithm; encryption inactive
    naeshow: Choice 1: 'RC4_40' (ID 1)
    naeshow: Choice 2: 'DES40' (ID 3)
    naeshow: exit
    naeeinit: exit
    naecinit: entry
    nam_gnsp: Reading parameter "SQLNET.CRYPTO_CHECKSUM_SERVER" from parameter file
    nam_gnsp: Parameter not found
    naequad: Using default value "ACCEPTED"
    nam_gic: entry
    nam_gic: Counting # of items in "SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER" parameter
    nam_gic: Parameter not found
    nam_gic: exit
    naesno: Using default value "all available algorithms"
    naeshow: entry
    naeshow: These are the checksumming algorithms that the server will accept, in decreasing order of preference:
    naeshow: Choice 0: no algorithm; checksumming inactive
    naeshow: Choice 1: 'MD5' (ID 1)
    naeshow: exit
    naecinit: exit
    nainit: native services disabled - disconnecting
    nadisc: entry
    nacomtm: entry
    nacompd: entry
    nacompd: exit
    nacompd: entry
    nacompd: exit
    nacomtm: exit
    nas_dis: entry
    nas_dis: exit
    nau_dis: entry
    nau_dis: exit
    naeetrm: entry
    naeetrm: exit
    naectrm: entry
    naectrm: exit
    nagbltrm: entry
    nau_gtm: entry
    nau_gtm: exit
    nagbltrm: exit
    nadisc: exit
    nainit: exit
    nsnainit: NS Connection version: 310
    nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd
    nsnainit: "or" info flags: 0xd Translations follow:
    native service(s) is (are) wanted
    NA disabled remotely for this connection
    NA services unavailable on both processes - negotiation not needed

    nsnainit: "or" info flags: 0xd Translations follow:
    native service(s) is (are) wanted


    (Part Of SQLNET.log)

    Fatal NI connect error 12641, connecting to:
    (LOCAL=NO)

    VERSION INFORMATION:
    TNS for Solaris: Version 8.1.5.0.0 - Production
    Oracle Bequeath NT Protocol Adapter for Solaris: Version 8.1.5.0.0 - Production
    TCP/IP NT Protocol Adapter for Solaris: Version 8.1.5.0.0 - Production
    Time: 19-JUL-03 18:08:01
    Tracing to file: /u01/app/oracle/product/8.1.5/network/trace/svr_7127.trc
    Tns error struct:
    nr err code: 0
    ns main err code: 12641
    TNS-12641: Authentication service failed to initialize
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0


    Thanks in advance
    Raju

  4. #4
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Arrow Oracle no reachable

    It really doesnt matter whether you are using IP or the hostname. I do all the communication through the hostname itself.
    Can u enlist the following information.

    1. SID (ORACLE_SID)
    2. HOSTNAME
    3. Commands you are using for performing tnsping.

    Also, did u happen to try the command ping hostname. And also try the command tracert from the server and the solaris box.

    Thanx and Regards
    Aruneesh

  5. #5
    Join Date
    May 2003
    Location
    Dublin, Ireland
    Posts
    44

    Re: Oracle no reachable

    It does matter if you are using IP or hostname. For the connection via hostname you need a DNS server access. If it is down or unaccessible you will not get connection.

    If you could post your listener.ora and tnsnames.ora files and command that fails to connect it will be easier to analise the problem.

    Cheers,

    Jacek

    Originally posted by aruneeshsalhotr
    It really doesnt matter whether you are using IP or the hostname. I do all the communication through the hostname itself.
    Can u enlist the following information.

    1. SID (ORACLE_SID)
    2. HOSTNAME
    3. Commands you are using for performing tnsping.

    Also, did u happen to try the command ping hostname. And also try the command tracert from the server and the solaris box.

    Thanx and Regards
    Aruneesh

Posting Permissions

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