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 […]
Oracle Database
Oracle Database
Oracle, Oracle Database, Uncategorized
Show Oracle Alert Log Location
select * from v$diag_info; The Oracle alert log can be found in the same sub-directory as Default Trace File which
12c, Oracle, Oracle Data Guard, Oracle Database, RMAN
Oracle 11gR2 and 12c etc. – Create a script that will help recreate a controlfile – using: alter database backup controlfile to trace;
The “alter database backup controlfile to trace;” will create a text based file – human readable – that contains the
12c, Oracle, Oracle Database
Open all Oracle pluggable databases within a container database with a trigger on the container database as follows:
create or replace trigger sys.after_startup after startup on database begin execute immediate ‘alter pluggable database all open’; end after_startup; /
12c, Oracle, Oracle Database, sqlCL
Generating Oracle DDL with SQLcl
This one is powerful enough that I would just like to reference Jeff Smith’s post on the subject: Generating User
Bash, Linux RHEL/CentOS/OEL, Oracle Database
Using rlwrap for rman and maybe sqlplus, RHEL, CentOS, Oracle Linux 6 & 7, and Amazon Linux 1, and 2
FYI newest verision of sqlplus installed with 12.2 has command recall built in – but not rman… and anything older
Linux RHEL/CentOS/OEL, Oracle Database
Want to automate an Oracle install … somebody is helping
See this post about Atlas from Dizwell Informatics… https://www.dizwell.com/wordpress/atlas-a-universal-oracle-preinstaller/
Oracle Database
Oracle RAC crsctl syntax 12c
crsctl commands in Oracle RAC crsctl – Cluster Ready Service Control $crsctl — to get help $crsctl query crs activeversion
Oracle Database
Oracle 12c show shared pool used
— 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
Oracle Database
Oracle Optimal Storage Solution Made Easy
http://www.oracle.com/technetwork/database/performance/opt-storage-conf-130048.pdf