Oracle VirtualBox & Developer Days. Connection to DB, APEX. How to?
435162May 16 2011 — edited Oct 6 2011Hi everybody!
I installed Oracle VirtualBox (4.0.4) with Oracle Developer Days VM.
Host comp - Windows 7 Home Premium
LocalHost - Linux
Do i have somehow configure VM to be able to :
1. Connect to DB (orcl) from console
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Mon May 16 09:08:53 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected to an idle instance.
SQL> select * from dual;
select * from dual
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
SQL>
2. Work with orcl DB from SQL Developer
-- sample_connection
Get error: "Listener refused the connection with the following error - ORA-12528:TNS:Listener:All Appropriate instances are blocking new connections"
-- sample_connection_IP
with USER HR and password oracle "Loading" takes forever...
3. Start APEX from FF browser (preset link http://localhost:8888/apex/f?p=4550:1)
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
java.lang.IllegalStateException
org.apache.catalina.connector.ResponseFacade.sendError(ResponseFacade.java:407)
oracle.dbtools.apex.ModApexContext.handleError(ModApexContext.java:350)
oracle.dbtools.apex.ModApex.close(ModApex.java:147)
oracle.dbtools.apex.ModApex.doGet(ModApex.java:88)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
===============
Thnks in advence.
Mike.