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 188.8.131.52.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