I have searched high and low. I am certain there is something out there about this, but I can't find it. Maybe someone can point me in the right direction.
Before I start explaining the issue, I know there are other ways to do this and that this setup is may not be recommended. I have already done those and my software that uses 12c is running and in production. Now I am trying to figure out why I can't...or how I can do it the way I initially intended.
Here is what I wanted to do:
To keep with the ideology of server consolidation, I wanted to create a second database on an existing Oracle Linux server running Oracle 12c. I am currently running one staging database on this server right now, and was looking to add a second. Normally I would just add additional tablespaces, but the initialization parameters between the two databases are very different. So instead I decided to use the dbca utility to create an entirely separate database. It has it own listener, own listener port, own pfile, own set of database files, etc. etc, etc. The only commonality is I was using the same Oracle 12c installation. I must admit I am not a dba, and I know Oracle the least of all of the database softwares I have implemented in the past. I am trying to do this with Oracle 12c because that is required of both software selections we have chosen. I am trying to do this with a single Oracle installation as it seems that a single database application should be able to have multiple databases (thinking back to the times of mainframe and server consolidation of log ago), I am also trying to not do this as a Pluggable\Container database, because...well I can do that and I want to see about doing this as standalone. It seems to me that this is possible and I am missing something. I will look into the PDC type setup when I am more versed with it.
The problem:
So initially this all goes great. I create the listener, run dbca and create the database as specified by vendor documentation. After dbca finishes everything seems GREAT! I can connect to it with sqlplus locally, sql developer remotely, EM Express is working, all ports are listening, I even got the software installed and connected to the database, created tablespaces and schemas. I was actually even ready for testing before sending the new software into production. The only reason I found out something was wrong was when I shutdown the VM to take a snapshot before testing. I found when restarting the VM and subsequently trying to start databases by running the dbstart command (I have set /etc/oratab to start all of the databases) that the database doesn't start. Looking at the startup log I get two errors. An invalid username and password and an insufficient privileges error. Now the other database on this server starts perfectly fine. I am not sure what I am missing, but is very much seems to be something with the ORACLE_SID. I have workarounds such as creating other VMs on the same host, etc, but this is just an issue that is both picking at my brain and showing I am lacking a piece of knowledge that maybe inherent to administering an Oracle system properly.
I apologize in advance for any issues with this post such as wrong forum, if there is another post that deals with this issue etc. I am new to the Oracle forums and having some trouble navigating around.
+Gris