Its purely for educational purposes.
OS Centos 7
Oracle 12.2
I installed a new database(2nd one) by the name of cleartrade using DBCA. After installation, on sqlplus command line i used username/password@cleartrade and was connected to the database without any problem. Then i also used sql developer and was connected there also also. I worked in the database creating many tables and populating them with a lot of data. For some maintenance had to restart my PC. After that I am unable to connect to the database. After googling a few tutorials I realized I had to create a seperate listener for the database. There must be a listener entry in listener.ora.
1st question: There was no entry in listener.ora for cleartrade at 1st startup. How did it started then ??
So using Net manager Asistant i created a listener with the same name cleartrade on port 1528 and try to start the listener with lsnrtctl start cleartrade. Here is the result along with tnsping cleartrade.
you can see lsnrctl staus is showing uptime and start date but tnsping is showing no listener.
LISTENER.ORA
# listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
CLEARTRADE =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaserver0.hardstoneus.net)(PORT = 1528))
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaserver0.hardstoneus.net)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
TNSNAMES.ORA
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORA12C =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaserver0.hardstoneus.net)(PORT = 1521))
(CONNECT\_DATA =
(SERVER = DEDICATED)
(SERVICE\_NAME = ora12c.hardstoneus.net)
)
)
CLEARTRADE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaserver0.hardstoneus.net)(PORT = 1521))
(CONNECT\_DATA =
(SERVER = DEDICATED)
(SERVICE\_NAME = cleartrade.hardstoneus.net)
)
)
LISTENER_ORA12C =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaserver0.hardstoneus.net)(PORT = 1521))
LISTENER_CLEARTRADE =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaserver0.hardstoneus.net)(PORT = 1521))