3 Replies Latest reply: Nov 7, 2013 6:54 AM by EdStevens RSS

    can not connect to Database

    user10274093

      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 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 ?

       

      Thanks.