Database Networking (MOSC)

MOSC Banner

port number changes in listener.log

edited Nov 7, 2013 10:00PM in Database Networking (MOSC) 5 commentsAnswered ✓

Hi,

on 10.2.0.3

In my listener.ora I have given port 1521.

In tnsnames.ora also 1521.

When I try to connect to my db on the dbserver,  I receive :

sqlplus system@MYDB

ORA-12514: TNS:listener does not currently know of service requested.

 

in listener.log I have

07-NOV. -2013 09:04:54 * (CONNECT_DATA=(SERVICE_NAME=MYDB)(CID=(PROGRAM=D:\oracle\bin\sqlplus.exe)(HOST=SERVER)(USER=user))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=4358))

 

or

(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1858))

or

(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1869))

 

In sqlnet.log I have

TNS-12564: TNS : connetion refused

 

My question is why in listener.log I have different port numbers instead of 1521 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center