Hi guys,
I've tried to solve this issue by myself reading all articles available in the net but I'm afraid this is a dead end.
Scenario:
OTN_Developer_Day_VM.ova downloaded from Developer Day - Hands-on Database Application Development
Appliance imported changing only memory (increasing) and network adapter (to bridge).
I've tried to connect to database with SQL Developer and SQLPlus getting these error messages:
SQL Developer:
Listener refused the connection with the following error: ora-12514 TNS: listener does not currently know of service requested in connect descriptor.
sqlplus / as sysdba
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.
Database Information:
Oracle SID : cdb1
Pluggable DB : orcl
$ORACLE_SID = cdb1.
dba and oper groups created with groupadd
oracle user added to dba, oper and oinstall groups.
------------------------------------------------------------------------------------------------------------------------------------------
[oracle@localhost dbs]$ id oracle
uid=1000(oracle) gid=1000(oracle) groups=1000(oracle),10(wheel),990(vboxsf),1001(dba),1003(oper),1004(oinstall)
------------------------------------------------------------------------------------------------------------------------------------------
hostname 127.0.0.1
oracle restart
------------------------------------------------------------------------------------------------------------------------------------------
lsnrctl status:
------------------------------------------------------------------------------------------------------------------------------------------
[oracle@localhost ~]$ lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 22-JUN-2015 08:00:17
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 22-JUN-2015 07:49:42
Uptime 0 days 0 hr. 10 min. 34 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File /home/oracle/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
Any help with this will be much appreciated. I'm trying to solve this to prepare an exam and the fact of not being able to solve it it's killing me.
Thanks in advance.
Alfonso