Skip to content

Instantly share code, notes, and snippets.

@sergiosouzalima
Created May 19, 2020 14:21
Show Gist options
  • Save sergiosouzalima/376b561fb75a5f80e54b32254e4757df to your computer and use it in GitHub Desktop.
Save sergiosouzalima/376b561fb75a5f80e54b32254e4757df to your computer and use it in GitHub Desktop.
Enterprise_Manager_not_working
$ ps -ef | grep smon
oracle 3351 1 0 10:10 ? 00:00:00 ora_smon_orcl
oracle 6336 1855 0 11:03 pts/0 00:00:00 grep --color=auto smon
[oracle@ol7-dba ~]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 19-MAY-2020 11:08:15
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 19-MAY-2020 10:01:00
Uptime 0 days 1 hr. 7 min. 15 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/ol7-dba/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=ol7-dba.localdomain)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/orcl/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "86b637b62fdf7a65e053f706e80a27ca.localdomain" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "a5edaa63f8e55296e0533601a8c07f25.localdomain" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl.localdomain" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.localdomain" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclpdb.localdomain" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB MOUNTED
SQL> alter pluggable database orclpdb open;
Pluggable database altered.
SQL> show con_name;
CON_NAME
------------------------------
CDB$ROOT
SQL> alter session set container=CDB$ROOT;
Session altered.
SQL> select dbms_xdb_config.gethttpsport() from dual;
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
5500
-----------------------------------------------------------------------------
| $ ping 192.168.1.54
PING 192.168.1.54 (192.168.1.54): 56 data bytes
64 bytes from 192.168.1.54: icmp_seq=0 ttl=64 time=0.387 ms
64 bytes from 192.168.1.54: icmp_seq=1 ttl=64 time=0.582 ms
64 bytes from 192.168.1.54: icmp_seq=2 ttl=64 time=0.511 ms
64 bytes from 192.168.1.54: icmp_seq=3 ttl=64 time=0.710 ms
64 bytes from 192.168.1.54: icmp_seq=4 ttl=64 time=0.524 ms
64 bytes from 192.168.1.54: icmp_seq=5 ttl=64 time=0.422 ms
64 bytes from 192.168.1.54: icmp_seq=6 ttl=64 time=0.451 ms
64 bytes from 192.168.1.54: icmp_seq=7 ttl=64 time=0.527 ms
^C
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment