Oracle DB:How to start pluggable databases in 12c Oracle DB

In Oracle 12c DB, we have containers or pluggable databases on which the actual schemas are placed. But they wont get started automatically, when DB is started. So, for the pluggable databases to start along with normal DB, small modification should be done. Below is how to do it.


1. Login to sqlplus with sysdba or sysoper user for normal SID or Service name
Eg: orcl is the main service name and pdborcl is the pluggable db, then login to sys user of orcl .

2. Execute the following queries

i. ALTER PLUGGABLE DATABASE ALL OPEN;

ii. alter pluggable database PDBORCL save state;

iii. SELECT name, open_mode FROM v$pdbs;

Snapshots:




Note: Please try it and for clarifications try to read oracle documentations regarding to this in oracle site.

Comments

Post a Comment

Popular posts from this blog

Configure, Modify, Rename,Delete a listener for Oracle 11g database

Image
  Steps to configure listener When a client like SQL Developer, toad etc. wants to establish a connection to an Oracle Server, it usually first contacts the listener . The listener then creates a foreground process ( dedicated mode ) or attaches the request to an existing foreground process ( shared mode ). The client then directly communicates with that foreground process . A listener can accept requests for more than one instance. Likewise, more than one listener can accept requests for the same instance (load balancing). 1.         Open terminal and go to the bin folder under ORACLE_HOME  cd /u01/app/oracle/product/11.2.0/dbhome_1/bin ./netca 2.         Since there are no existing listeners we will get only add listener as option. Click on Add option and click next. 3.         Provide the name for the listener (Eg. ORCL, DB11G etc.) 4.         Select the protocol in which the listener will be listening for the connections.
Read more

Oracle DB:Oracle 12C DB installation Error -Failed to access the temporary location

Image
While installing Oracle 12 database in Windows 7, an error "Failed to access the temporary location" occurs. Error: Cause - Failed to access the temporary location.  Action - Ensure that the current user has required permissions to access the temporary location.  Additional Information:  - Framework setup check failed on all the nodes  - Cause: Cause Of Problem Not Available  - Action: User Action Not Available Summary of the failed nodes <>- Version of exectask could not be retrieved from node “<>”  - Cause: Cause Of Problem Not Available  - Action: User Action Not Available Solution:  To get rid of this issue, add share in "Computer Management" 1. In Run (Win symbol+R) , type  compmgmt.msc 2. Under Shared Folders, Shares 3. Right click, Click on "New Share" 4. Click Next 5. Provide "C:\" in the Folder path and  click Next 6. Click Yes to continue  7. Provider "C$" fo
Read more

OSB : DB Adapter-Poll - Delete Logical Records using Oracle Service Bus 12c

Image
In this section, we will see how to use the Logical delete of records from table for polling tables from database.  Note: For creating connection factory, datasource, deployment , DBAdapter for poll and merge please verify my blog page  OSB : DB Adapter-Poll - Delete Physical Records using Oracle Service Bus 12c Here will explain only the essence of logical delete and how the data is picked and processed.  VERSION USED:  SOA SUITE 12C - 12.2.1.3 DB  12C - 12.2.0.1.0 SOURCE SCHEMA - SCOTT  SOURCE TABLE - EMP_UI TARGET SCHEMA - TGT  TARGET TABLE - EMP_UI_TGT Create table and insert records . In this option we have to add one more column for performing the logical delete just by updating the values.  Here we are making logical delete on column "STATUS" by changing poll value from "N" to "Y"  Physically the data will be available in the database but the process wont pick it as the condition mentioned for the pr
Read more