Re: Default Password Oracle Clients

From: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Mon, 16 Feb 2004 17:48:05 +0000
Message-ID: <uefb$bAVJQMARxXQ_at_peterfinnigan.demon.co.uk>

Hi,

[Quoted] 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 Mon Feb 16 2004 - 18:48:05 CET