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 usually ends in …/trace/alert_.log
select * from v$diag_info; The Oracle alert log can be found in the same sub-directory as Default Trace File which usually ends in …/trace/alert_.log
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 …
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 DDL in SQLcl
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 …
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 $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] …
— 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 ———- ——– …
http://www.oracle.com/technetwork/database/performance/opt-storage-conf-130048.pdf
With 12c Oracle provides a couple of new views that report IOs that take over 500ms. That 500ms threshold is modifiable via the hidden parameter _IO_OUTLIER_THRESHOLD. V$IO_OUTLIER V$LGWRIO_OUTLIER