in Oracle

Oracle Start listener and Start OEM

Encountered SQL developer- the network adapter could not establish the connection, it is quite simple, the Oracle listener was not start up. Resolved by below command, after startup the listener, can connect through SQL developer with successful result.

Error 1: Oracle SQL Developer error – IO Error: The Network Adapter could not establish the connection.
Error 2: cannot connect through OEM, Oracle Enterprise Manager.

Below are two solutions,

Start listener

[tom@ocp admin]$ lsnrctl start

LSNRCTL for Linux: Version - Production on 21-12月-2018 20:18:20

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

启动/u01/app/tom/product/11.2.0/dbhome_1/bin/tnslsnr: 请稍候...

TNSLSNR for Linux: Version - Production

别名                      LISTENER
版本                      TNSLSNR for Linux: Version - Production
启动日期                  21-12月-2018 20:18:20
正常运行时间              0 天 0 小时 0 分 0 秒
跟踪级别                  off
安全性                    ON: Local OS Authentication
SNMP                      OFF
监听程序参数文件          /u01/app/tom/product/11.2.0/dbhome_1/network/admin/listener.ora
监听程序日志文件          /u01/app/tom/diag/tnslsnr/ocp/listener/alert/log.xml
[tom@ocp admin]$

Start OEM, Oracle Enterprise Manager

[tom@ocp bin]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
Starting Oracle Enterprise Manager 11g Database Control ..... started.
Logs are generated in directory /u01/app/tom/product/11.2.0/dbhome_1/ocp_orcl/sysman/log
[tom@ocp bin]$ pwd
[tom@ocp bin]$

Use below link to access OEM, Oracle Enterprise Manager
username / password = sys/oracle, role as sysdba

Below command to check the EM port usage,

[tom@ocp ~]$ cd $ORACLE_HOME
[1]+  Exit 255                LANG=zh_CN.utf8 dbca  (wd: ~)
(wd now: /u01/app/tom/product/11.2.0/dbhome_1)
[tom@ocp dbhome_1]$ cd install/
[tom@ocp install]$ ls
chainedInstall  make.log  portlist.ini  root_ocp_2018-12-19_21-20-28.log  utl
config          jlib                oratab    readme.txt    unix
[tom@ocp install]$ cat portlist.ini
Enterprise Manager Console HTTP 端口 (orcl) = 1158
Enterprise Manager 代理端口 (orcl) = 3938
[tom@ocp install]$ pwd
[tom@ocp install]$


SQL developer- the network adapter could not establish the connection

Write a Comment