I installed oracle developer days in virtualbox, and I'm having trouble starting the server, which I believe is causing issues with sqlplus.
setup: oracle developer days installed as is within windows 7 virtualbox.
uname -a inside developer days console:
Linux localhost.localdomain 2.6.18-194.17.1.0.1.el5 #1 SMP Wed Sep 29 15:40:03 EDT 2010 i686 i686 i386 GNU/Linux
http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
Any help would be much appreaciated
What I found particiularly interesting about my error message is that I was missing the listener at /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora, a file that doesn't exist. the also is no dbhome_1 subdirectory.
To start my database instance, I'm using Oracle Enterprise Manager
with the command emctl start dbconsole
and am getting these errors:
Database Instance Host
0.0.0.0
Port
1521
SID
orcl
Oracle Home
/home/oracle/app/oracle/product/11.2.0/dbhome_2
Listener
Status Down
Host 0.0.0.0
Port 1521
Name LISTENER
Oracle Home /home/oracle/app/oracle/product/11.2.0/dbhome_2
Location /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin
Details
Although a Listener with name "LISTENER", is running on this host at port: "1521", it was not started using this target's "LISTENER.ORA" file. CORRECTIVE ACTION: To monitor this "EM Listener Target" with its present configuration, you must stop the currently running listener process, and start it again using the Listener Parameter file:
/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora . Alternatively, you can update this target's "LISTENER.ORA Location" parameter with the location of the currently running Listener, which was started using:
/home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin/listener.ora
Agent Connection to Instance
Status
Failed
Details ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html It came with a readme file that says
Log into sqlplus with username hr and password oracle.
All passwords are oracle or noted if otherwise.
The SQL Developer and Data Modeler scripts are in the directory:
/home/oracle/Desktop/SQLDev_Tutorials/sqldev
To Reset the labs:
SQL Developer: /home/oracle/reset_sqldev
Application Express: /home/oracle/reset_apex
In-Memory Database Cache: /home/oracle/reset_imdbcache
XML Database: /home/oracle/reset_xmldb Oracle Enterprise Manager
Start: emctl start dbconsole
Stop : emctl stop dbconsole
URL : https://127.0.0.1:1158/em
*** Please note that this appliance is for testing purposes only,
as such it is unsupported and should not be used as a production environment.
Check of system:
[oracle@localhost ~]$ ps -f | grep pmon
oracle 8866 7756 0 11:58 pts/2 00:00:00 grep pmon
my SID is orcl, does this make a difference?
Trying outstuff on the web:
http://www.unix.com/emergency-unix-linux-support-help-me/152271-unable-connect-oracle-red-hat-linux.html
[oracle@localhost ~]$ /home/oracle/app/oracle/product/11.2.0/dbhome_2/bin/oraenv
ORACLE_SID = [orcl] ? y
ORACLE_HOME = [home/oracle] ? y
ORACLE_BASE environment variable is not being set since this
information is not available for the current user ID oracle.
You can set ORACLE_BASE manually if it is required.
I think this could be my resolution, but Im not sure which targets.xml to change
Update: My listener is now working.
629886
Now, when I try to run startup as sysdba I get this error:
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
2378116
I'm also looking into this error:
http://stackoverflow.com/questions/3267850/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript
one located at /home/oracle/app/oracle/product/11.2.0./dbhome_2/sysman/emd, last modified Oct 2010.
the other is located at ~/app/oracle/product/11.2.0/dbhome_2/localhost.localdomain_orcl/sysman/emd , last modified today.
Edited by: 946459 on Jul 14, 2012 11:33 AM
Edited by: 946459 on Jul 14, 2012 11:38 AM
Edited by: 946459 on Jul 14, 2012 11:59 AM
Edited by: 946459 on Jul 14, 2012 12:09 PM
Edited by: 946459 on Jul 14, 2012 12:30 PM