Re: ORA-12505: TNS:listener does not currently know

Posted by big on Jan 30, 2021; 10:59am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORA-12505-TNS-listener-does-not-currently-know-tp9289p9295.html

Hi,
Thanks. Here are what you asked:
==Listener.ora===================
# Net8 definition for Database listener
#

mydb =
  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROCmydb))
        (ADDRESS= (PROTOCOL= TCP)(Host= server.com )(Port= 1533))
  )

SID_LIST_mydb =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME= /db-xxxx-dev/product/oracle/distrib/ora11204/0717)
      (SID_NAME = mydb)
    )
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /db-xxxx-dev/product/oracle/distrib/ora11204/0717)
      (PROGRAM = extproc)
    )
  )

STARTUP_WAIT_TIME_mydb = 0
CONNECT_TIMEOUT_mydb = 10
TRACE_LEVEL_mydb = OFF

LOG_DIRECTORY_mydb = /db-xxxx-dev/product/oracle/distrib/ora11204/0717/network/admin
LOG_FILE_mydb = mydb
TRACE_DIRECTORY_mydb = /db-xxxx-dev/product/oracle/distrib/ora11204/0717/network/admin
TRACE_FILE_mydb = mydb
ADMIN_RESTRICTIONS_mydb = OFF


IFILE=/db-xxxx-dev/product/oracle/distrib/ora11204/0717/network/admin/mydb_server/listener_ifile.ora

=====================listener_ifile.ora=======
it is an empty file

===============easy connect==================
sqlplus user/password@' (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =(PROTOCOL = TCP)
(HOST = ip_address) (PORT = 1533) )) (CONNECT_DATA =(SID = mydb)))

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
mydb

Regards.