Re: Default Password Oracle Clients

Hey, the problem has been solved by re-installing the whole package. I took that into account because I wasn't sure of what the other guy did when installing it on my machine. It's working perfectly now.

Thanks for the free consultancy. I've really gain a lot from you guys.

Best regards to you all

"Pete Finnigan" <plsql_at_petefinnigan.com> wrote in message news:uefb$bAVJQMARxXQ_at_peterfinnigan.demon.co.uk...
> Hi,
>
> As Harald pointed out its a TNS issue, you should check first that your
> tnsnames and listener.ora files have the correct entries, server name or
> IP address and SID and global dbname and service name - for instance for
> my 9ir2 database on my XP PC the HOST is set to zulia which is the
> hostname of my WIN XP machine, PORT is the default 1521, service name is
> "sans" as is SID and global_dbname. Then you should use the name (SANS
> in my case) associated with the tnsnames entry such as :
>
> SANS =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = zulia)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = sans)
> )
> )
>
> in my case its SANS. then i can do tnsping as follows:
>
> C:\Documents and Settings\pete>tnsping sans
>
> TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on
> 16-FEB-20
> 04 17:33:57
>
> Copyright (c) 1997 Oracle Corporation. All rights reserved.
>
> Used parameter files:
> C:\oracle\ora90\network\admin\sqlnet.ora
>
>
> Used TNSNAMES adapter to resolve the alias
> Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
> (PROTOCOL = TCP)
> (HOST = zulia)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED)
> (SERVICE_NAME
> = sans)))
> OK (580 msec)
>
> C:\Documents and Settings\pete>
>
> This shows i can ping the listener with TNS protocol. If this fails and
> your files look OK then check the listener is up and running:
>
> C:\Documents and Settings\pete>lsnrctl status
>
> LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 16-FEB-
> 2004 17:41:
> 22
>
> Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
>
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0
> - Produc
> tion
> Start Date 16-FEB-2004 09:29:35
> Uptime 0 days 8 hr. 11 min. 49 sec
> Trace Level off
> Security OFF
> SNMP OFF
> Listener Parameter File C:\oracle\ora90\network\admin\listener.ora
> Listener Log File C:\oracle\ora90\network\log\listener.log
> Listening Endpoints Summary...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zulia)(PORT=1521)))
> <snipped>
>
> as you can see its running and listening on port 1521.
>
> you acn also use netstat -a to check for ports being listened on for
> your machine:
>
> C:\Documents and Settings\pete>netstat -a
>
> Active Connections
>
> Proto Local Address Foreign Address State
> TCP zulia:epmap 0.0.0.0:0 LISTENING
> TCP zulia:https 0.0.0.0:0 LISTENING
> TCP zulia:microsoft-ds 0.0.0.0:0 LISTENING
> TCP zulia:1025 0.0.0.0:0 LISTENING
> TCP zulia:1035 0.0.0.0:0 LISTENING
> TCP zulia:1040 0.0.0.0:0 LISTENING
> TCP zulia:1043 0.0.0.0:0 LISTENING
> TCP zulia:1046 0.0.0.0:0 LISTENING
> TCP zulia:1521 0.0.0.0:0 LISTENING
> ^^^^^^^^^^^^
>
> As the oerr check shows by Harald you can also use trace on sql*net -
> see my paper "detecting sql injection in oracle" on
>
> http://www.petefinnigan.com/orasec.htm for an example of setting trace
> on sql*net.
>
> You can also check the sqlnet.log file for any errors?
>
> hth
>
> kind regards
>
> Pete
> --
> Pete Finnigan
> email:pete_at_petefinnigan.com
> Web site: http://www.petefinnigan.com - Oracle security audit specialists
> Book:Oracle security step-by-step Guide - see http://store.sans.org for
details. Received on Wed Feb 18 2004 - 09:52:30 CET