Hello Gents,
I'm now passing hour 14 on trying to get Oracle Database 12c (12.1.0) Enterprise Edition installed on Amazon Web Services. Yes, I've read the installation instructions. Yes, I've tried tutorials. And yes, I've searched both google and these very forums. I'm still having problems and I'm hoping I can find a hero.
Here's a condensed version of what I've done so far. As a quick aside, in 14 hours, I've done this more than once, and in more than one way.
AWS | Oracle and Amazon Web Services
I picked the Oracle Linux 6.5 x86_64 AMI, created the instance, and set the security group. I then ssh'd right on into it, setup my pre-install package by following instructions as seen
here Installing Database 12c on Oracle Linux 6 in VirtualBox – Part 2 | Nikolay Manchev
here How I Simplified Installation of Oracle Database on Oracle Linux (the title is absurdly misleading)
and here Automatically Configuring Oracle Linux with Oracle Preinstallation RPM
I then run the ./runInstall to get the GUI installation to popup. For those reading along, you'll want to ssh with the -X parameter and setup some other stuff so the GUI will actually display through SSH. This is a good post: https://blogs.oracle.com/observatory/entry/zones_x_and_roles. You'll also want to know how to secure copy the database files into your AWS instance (Example syntax for Secure Copy (scp), how to add users to groups (Howto: Linux Add User To Group), how to create a swap file (Linux Add a Swap File – Howto) because the stated 150MB requirement when running ./runInstall is incorrect, and how to add sqlplus to your path when you're done (configuration - Adding a directory to $PATH in CentOS? - Server Fault).
So, anyway, I get the ./runInstall gui to function over ssh, follow the Installing Database 12c on Oracle Linux 6 in VirtualBox – Part 2 | Nikolay Manchev link and get the install all the way to the Database Creation Assistant, which fails. The details button tells me to look at the log file ... whose last line says "INFO: Completed Plugin named: Oracle Database Configuration Assistant" and contains no errors. Not the kind of error logging I was hoping for.
At any rate, I press Skip a few times and close out the wizard and try to pull up SqlPlus. Be sure to check out that "Adding a directory to $PATH" link! That's a good one to have. You'll also want to put export $ORACLE_HOME= ... and $ORACLE_SID=orcl in there as well.
root> su oracle
oracle> sqlplus / as sysdba
I receive a "Connected to an idle instance" warning ... Not good.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/12.1.0/dbhome_1/dbs/initorcl.ora'
Bummer. Well, there IS an init.ora file. Why don't I just copy that and rename it to the expected initorcl.ora? And I do just that .... Startup sqlplus, reminded I'm connected to an idle instance, and type 'startup'.
ORA-48108: invalid value given for the diagnostic_dest init.ora parameter
ORA-48140: the specified ADR Base directory does not exist [/u01/app/oracle/product/12.1.0/dbhome_1/dbs/<ORACLE_BASE>]
ORA-48187: specified directory does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
Yes! I have "Additional information: 1". I'm on a roll (sarcasm). I use vi to modify the initorcl.ora file, replacing <ORACLE_BASE> with /u01/app/oracle where applicable. Drum roll ... more errors.
ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-01262: Stat failed on a file destination directory
Linux-x86_64 Error: 2: No such file or directory
At this point I thought I'd better just stop, retreat to the forums, and ask for some help. No doubt you'll want these ...
[oracle@ip-10-81-160-225 dbs]$ ps -ef | grep ORA
oracle 5200 5159 0 22:50 pts/0 00:00:00 grep ORA
[oracle@ip-10-81-160-225 dbs]$ echo $ORACLE_HOME
/u01/app/oracle/product/12.1.0/dbhome_1
[oracle@ip-10-81-160-225 dbs]$ echo $ORACLE_SID
orcl
[oracle@ip-10-81-160-225 dbs]$ echo $ORACLE_BASE
/u01/app/oracle
I'm now at hour 15. Logs and stuffs are attached. Passwords have been removed to protect the innocent. Thanks in advance.
http://www.williverstravels.com/JDev/Forums/Threads/12552405/dborcl.rsp
http://williverstravels.com/JDev/Forums/Threads/12552405/installActions2014-07-22_09-20-10PM.log
And by the way, if one of you guys has got a rock-solid way to make this thing install, I've got no problem firebombing what I've got and starting over from scratch. I've done it three times already.
Will