Hi all,
Hope this is the correct place to ask this question - since its post installation issue.
Im very excited since I just installed yesterday manually Oracle Linux 6.5 and Oracle 11gr2 all on a Virtualbox vm. Ive been developing for long time but either in Banks already installed oracle in linux by DBAs or at home installation of Oracle in windows. But I decided to try something I was curious for long time which was to install oracle in linux running in a vm and then usinfg developement tools from vm host *sql developer etc..). Im happy that in just 2 days I was able to do all necessary steps from virtualbox additions for sharedfolders, linux with x, pre-requirements for oracle instalation, rpm and yumo stuff, kernel parameters tune and instalation when smoothly sucessfull yesterday
Today after typical small things missing after starting the VM like:
- missing env vars; oracle bin to PATH;
- sqlplus / as sysdba returned instance idle, so i started it OK with SQL> startup
- also unlocked hr account and in linux was able to connect sqlplus hr/hr
Now im trying to accomplish the following 2 things after starting the linux/oracle vm again today:
1. connect from vm host windows 7 oracle sql developer to my oracle db in linux.
2. access enterprise manager from browser in my windows 7 host. Yesterday just after finishing oracle installation I was able, just needed to open port 1158 in linux firewall and https://192.168.1.71:1158/em opened ok. But today after starting vm again seems some process is not running.. cause i cant access em either locally from inside the vm neither from my host.
Some linux info from my installation:
$ echo $SHELL
/bin/bash
$ set | grep ORACLE
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
ORACLE_SID=orcl
listener shows error before starting instance
$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 24-MAY-2014 14:28:29
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
starting oracle instance since its idle aka not running
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat May 24 14:19:08 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 417546240 bytes
Fixed Size 2213936 bytes
Variable Size 318769104 bytes
Database Buffers 92274688 bytes
Redo Buffers 4288512 bytes
Database mounted.
Database opened.
SQL> select count(*) from hr.employees;
COUNT(*)
----------
107
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
listner still return same error as before starting oracle - so i will start the listener:
$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 24-MAY-2014 14:31:37
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 24-MAY-2014 14:36:10
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/EMANUELDSKLINUX1/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 24-MAY-2014 14:36:12
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/EMANUELDSKLINUX1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
The listener supports no services
The command completed successfully
Ok now seems sqlplus locally working fine.
Now what I need help with is what am i missing to do so i can connect with my oracle sql developer from my windows 7 host ?
In my oracle sql developer im trying following parameters:
Username: sys
Password: oracle
Connection Type: Basic role: SYSDBA
Hostname: 192.168.1.71
Port: 1521
SID: orcl
and im getting the error when i click the Test button:
Status : Failure -Test failed: error input IO : The Network Adapter could not establish the connection.
Please let me know what commands/information you need to help me. Im sure im almost there after so many steps learning how to install and able to do the oracle setup in linux in a virtualbox im really looking forward to complete this exercice, thank you very much for your help.
Cheers,
Zen