Oracle Database

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 steps necessary to recreate an Oracle controlfile for a specific database (the database you were connected to when you issue the alter command). See Oracle’s documentation on how to use this file. It actually has …

Oracle 11gR2 and 12c etc. – Create a script that will help recreate a controlfile – using: alter database backup controlfile to trace; Read More »

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 and rman you want this… RLWrap Installation From EPEL Extra Packages for Enterprise Linux (or EPEL) a set of additional packages for Enterprise Linux, including, but not limited to, Red Hat Enterprise Linux (RHEL), CentOS …

Using rlwrap for rman and maybe sqlplus, RHEL, CentOS, Oracle Linux 6 & 7, and Amazon Linux 1, and 2 Read More »

Oracle RAC crsctl syntax 12c

crsctl commands in Oracle RAC crsctl – Cluster Ready Service Control $crsctl — to get help $crsctl query crs activeversion $crsctl query crs softwareversion [node_name] #crsctl start crs #crsctl stop crs (or) #/etc/init.d/init.crs start #/etc/init.d/init.crs stop #crsctl enable crs #crsctl disable crs (or) #/etc/init.d/init.crs enable #/etc/init.d/init.crs disable $crsctl check crs $crsctl check cluster [-node node_name] …

Oracle RAC crsctl syntax 12c Read More »

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 v$parameter.name=’shared_pool_size’ and v$sgastat.pool=’shared pool’; — Regardless of the value of shared_pool_size the following — query shows the breakdown of shared pool select sum(ksmchsiz) Bytes, ksmchcls Status from x$ksmsp group by ksmchcls; BYTES STATUS ———- ——– …

Oracle 12c show shared pool used Read More »