dimanche 15 mars 2015

Right way to restart Oracle 12c Server with pluggable databases


I am new to oracle. I installed Oracle 12c on windows with a pluggable database on a test VM. Everything was working fine. After the installation I was able to connect via EM Express on port 5500, via SQLPlus and via SQL Developer.


Them I restarted the server (windows shutdown and restart) and nothing worked. After some serious reading and a lot of trial and error I was able to connect again by starting the listener, the container database and the pluggable database. Also I had to restart the Listener service via the windows services application.


Now I have a couple of questions. Given my environment what is the recommended procedure to restart my oracle server? Is shutting down windows OK or should I shut down the oracle databases and listener before shutting down windows? What is the right startup process after a restart? Startup the container and pluggable databases and them the listener or vice versa?


All of those questions translate into just one: What is the right way (procedure and order) to shutdown and restart a windows server with Oracle 12c that has a pluggable database?


I have been reading about all those aspects but given my inexperience I haven’t found a guide about what to do in what order and why.


Thanks in advance!





Aucun commentaire:

Enregistrer un commentaire