I've installed 12c on Oracle Linux 7 for my development work, as per document
Oracle Database Installation Guide 12c Release 1 for Linux (E41491-10). My previous experience with administering Oracle Database is version 8 on Novell Netware and 10gR2 on Windows x64 at my prevoius workplace. I have not worked with Linux too much, save for some simple services on Ubuntu.
This time I choose not to create database on installation, so I had to run Oracle Database Configuration Assistant to do so, because I needed some options that default database did not have. I've done everything by the book, but I encountered problem one: ORACLE_HOME or ORACLE_BASE env vars were not set after creation. I had to edit .bash_profile to set these.
Database was created in default location, which is
/home/oracle/app/oracle/oradata/<SID>. It was started and configured with listener. Upon completion of database creation, I noticed problem two: I can't connect to oracle instance using sqlplus / AS SYSDBA. I am presented with
ORA-12162: TNS:net service name is incorrectly specified. As document
Oracle Database Error Messages 12c Release 1 (E49325-06) states, I checked if TNSNAMES.ORA doesn't contain any errors in connect descriptor, but it doesn't. Full contents of this file are (KITET is my instance name):
KITET = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ORALINUX7VM)(PORT = 1521)) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = Kitet) ) )
I connected only by specifying
After rebooting my virtual machine, I noticed problem three: listener and oracle do not start automatically. I can start listener by using
lsnrctl start, but can't start up the database (can't connect using
/ AS SYSDBA). I figured I could connect by specifying connection string with service_name, but I was greeted with
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor.
After looking here and there on the internet, I found out that by exporting ORACLE_SID, I could alleviate "can't startup" problem, so I did just that by editing (again)
What I still need done
I need listener and database startup automagically on boot, on Oracle Linux 7. Of course I am in posession of a document
Oracle Linux Administrator's Guide for Release 7 (E54669) but there's no information on how to create startup scripts for Oracle Database and Listener. There's just info on starting and stopping EXISTING services. Of course I can't login to my VM box and startup services everytime I power it up.