I have installed and created a database in oracle 12c in ubuntu 14.04 . Now I can login to the CLI using sqlplus \ as sysdba
and run sqlcommands , but I can't login to the EM from the web. The name given to me while database was loading was tamim-Inspiron-5421:5500/em
that is just my machine name, but when I type this on the browser , webpage not found error happens.
when I run the command lsnrctl status | grep HTTP
it returns empty i.e blank.
the output of the command in SQL is select dbms_xdb_config.getHttpsPort() from dual;
is
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
5500
I am logged in as oracle user like this oracle@tamim-Inspiron-5421
. I have checked the netstat --listen
and saw that no program is listening to port 5500. What could be the problem ?
Here is the error in lsnrctl
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
I think I need to configure my firewall , or edit my /etc/hosts file somehow , but I don't know how !! here is my /etc/hosts file
127.0.0.1 localhost
127.0.1.1 tamim-Inspiron-5421
after I added localhost like this 127.0.1.1 tamim-Inspiron-5421 localhost
Here is the status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date 21-SEP-2014 18:47:22
Uptime 0 days 0 hr. 9 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /oracle/app/oracle/diag/tnslsnr/tamim-Inspiron-5421/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tamim-Inspiron-5421)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=tamim-Inspiron-5421)(PORT=5500))(Security=(my_wallet_directory=/oracle/app/oracle/admin/tamimdb/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "tamimdb" has 1 instance(s).
Instance "tamimdb", status READY, has 1 handler(s) for this service...
Service "tamimdbXDB" has 1 instance(s).
Instance "tamimdb", status READY, has 1 handler(s) for this service...
The command completed successfully