As suggested by another poster, I installed the prebuilt appliance at [http://www.oracle.com/technetwork/community/developer-vm/index.html] and [http://www.oracle.com/technetwork/server-storage/virtualbox/downloads/index.html] with the intent of running oracle database in a linux vm as a guest on windows 7 and connecting to it using JDBC from the windows host.
This is running but I don't know how to install other stuff. I tried "sudo yum install openssh" and "sudo yum install emacs" and "sudo service sshd status" and none of these worked (it could not find these packages). I could not get apt-get or app-get or aptget to work either. I was hoping that "uname -a" would tell me if this was fedora or debian or something else but no luck. What command do I use to learn the distro name?
How do I make ifconfig tell me what the ip address so I can use "scp" and "ssh" to get into the box? Ok, /sbin/ifconfig works and I see there is only a loopback address. Ack! How do I create a socket so I can ssh into this little beastie?
How do I disable the firewall or (better yet) punch holes in it so I get use JDBC and ssh, scp and samba from windows 7?
I tried firing up the SQL Developer 3.1 and getting a test connection with username and password of "oracle" with no luck. How do I get a test connection to work?
How do I determine if the database is running? If not, how do I start it and stop it and restart it?
There is no "oracle" account native to the database itself. This is just the default account that owns the application. Log on as oracle/oracle to the OS. (OEL) You can change the passwords of the sys and system account by setting your $ORACLE_HOME and $ORACLE_SID. Default SID is orcl on a database install. Also set a path to the oracle binaries in the form of $ORACLE_HOME/bin.
Then sqlplus / as sysdba
Change passwords of sys and system using the following example.
ALTER USER SYS IDENTIFIED BY [password];
ALTER USER SYSTEM IDENTIFIED BY [password];
The supplied appliance runs oracle enterpirse linux. Not debain or fedora.
Why do you need "emacs"?
I haven't personally load this appliance with Virtual Box but there has to be a readme file somewhere that details all the passwords and etc.
If you have you variables set right.... then you don't need a password to do sqlplus / as sysdba
The command will connect the $ORACLE_HOME and $ORACLE_SID of the values set. This will not challenge you for a password. You will still have sysdba privileges. You can then change the passwords to whatever you want to set them to using the commands I gave you.