Hello,

I just installed Oracle Clients on my PC and wanted to play around with the
SQLs but couldn't login in. I installed using the default settings and I'm
told the username and password by default is system/manager or
sys/change_on_install. I've not successfully login and would be very
grateful if one of you gurus will reply.

Isaac

Hi,

If you look at my site there is a list of default passwords on there:
http://www.petefinnigan.com/orasec.htm - BTW what actual error do you
get? is it really that the password is not correct or something else?

You have got a database to connect to?, haven't you?

kind regards

Pete
--
Pete Finnigan
emailete (AT) petefinnigan (DOT) 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.

Hello Pete,

Your site has great stuff for me as a beginner and would like to thank you
in advance for the link. This is what I get when I try to login:

ERROR:
ORA-12560: TNSrotocol adapter error

don't you think it's the password?

Thanks and waiting for your favourable response.

Br, Isaac



"Pete Finnigan" <plsql (AT) petefinnigan (DOT) com> wrote

"Hanike" <isaac.quarshie (AT) nokia (DOT) com> writes:


$ oerr ora 12560
12560, 00000, "TNSrotocol adapter error"
// *Cause: A generic protocol adapter error occurred. *Action: Check
// addresses used for proper protocol specification. Before reporting
// this error, look at the error stack and check for lower level
// transport errors.For further details, turn on tracing and reexecute
// the operation. Turn off tracing when the operation is complete.

This might help.

Harald

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)(P ORT=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
emailete (AT) petefinnigan (DOT) 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.

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 (DOT) com> wrote