how to stop / start / open an Oracle pluggable container database
alter pluggable database orclpdb open; Of course you will want to connect as sys “sqlplus / as sysdba” or equivalent […]
alter pluggable database orclpdb open; Of course you will want to connect as sys “sqlplus / as sysdba” or equivalent […]
select * from v$diag_info; The Oracle alert log can be found in the same sub-directory as Default Trace File which
The “alter database backup controlfile to trace;” will create a text based file – human readable – that contains the
create or replace trigger sys.after_startup after startup on database begin execute immediate ‘alter pluggable database all open’; end after_startup; /
This one is powerful enough that I would just like to reference Jeff Smith’s post on the subject: Generating User
FYI newest verision of sqlplus installed with 12.2 has command recall built in – but not rman… and anything older
See this post about Atlas from Dizwell Informatics… https://www.dizwell.com/wordpress/atlas-a-universal-oracle-preinstaller/
crsctl commands in Oracle RAC crsctl – Cluster Ready Service Control $crsctl — to get help $crsctl query crs activeversion
— shared_pool_size must be non-zero select to_number(v$parameter.value) “value”, v$sgastat.bytes “bytes”, (v$sgastat.bytes/v$parameter.value)*100 “Percent Free” from v$sgastat, v$parameter where v$sgastat.name=’free memory’ and
http://www.oracle.com/technetwork/database/performance/opt-storage-conf-130048.pdf