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

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

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

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

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