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 11.2.0.1.0 - 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 11.2.0.1.0 - Production
系统参数文件为/u01/app/tom/product/11.2.0/dbhome_1/network/admin/listener.ora
写入/u01/app/tom/diag/tnslsnr/ocp/listener/alert/log.xml的日志信息
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocp)(PORT=1521)))

正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ocp)(PORT=1521)))
LISTENER 的 STATUS
------------------------
别名                      LISTENER
版本                      TNSLSNR for Linux: Version 11.2.0.1.0 - 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
监听端点概要...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocp)(PORT=1521)))
监听程序不支持服务
命令执行成功
[tom@ocp admin]$

Start OEM, Oracle Enterprise Manager

[tom@ocp bin]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
https://ocp:1158/em/console/aboutApplication
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
/u01/app/tom/product/11.2.0/dbhome_1/bin
[tom@ocp bin]$

Use below link to access OEM, Oracle Enterprise Manager
https://192.168.26.130:1158/em/
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  envVars.properties  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
/u01/app/tom/product/11.2.0/dbhome_1/install
[tom@ocp install]$

Reference

SQL developer- the network adapter could not establish the connection


Write a Comment

Comment