{"id":1497,"date":"2015-02-01T12:01:29","date_gmt":"2015-02-01T18:01:29","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=1497"},"modified":"2015-02-01T12:01:29","modified_gmt":"2015-02-01T18:01:29","slug":"1497","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2015\/1497\/","title":{"rendered":"Oracle Tidbits – January 2015"},"content":{"rendered":"

\u201cOracle *daily* TidBits<\/strong>\u201d (#oratidbit) published at\u00a0https:\/\/www.facebook.com\/oraclenotes<\/strong><\/a>\u00a0on weekdays\u00a0in January 2015. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well\u2026 Hope you find these helpful to learn something new or to remind you of its existence and use\u2026<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Publish Date<\/strong><\/td>\nTidBit<\/strong><\/td>\n<\/tr>\n
2-Jan<\/td>\n#oratidbit the SCHEMA_EXPORT_OBJECTS view shows the valid values you can use with EXCLUDE and INCLUDE parameters when using schema level export\/import. DATABASE_EXPORT_OBJECTS and TABLE_EXPORT_OBJECTS are views for full database\u00a0 and table level export\/import respectively.<\/td>\n<\/tr>\n
5-Jan<\/td>\n#oratidbit The tables beginning with ROLLING$ owned by SYSTEM are internal system tables used by the DBMS_ROLLING PL\/SQL package used to implement the Rolling Upgrade Using Active Data Guard feature, which streamlines the process of upgrading Oracle Database software in a Data Guard configuration in a rolling fashion.<\/td>\n<\/tr>\n
6-Jan<\/td>\n#oratidbit The SYSTEM_PRIVILEGE_MAP table lists all system privileges in the Oracle database. Similar table is STMT_AUDIT_OPTION_MAP.<\/td>\n<\/tr>\n
7-Jan<\/td>\n#oratidbit The EXPTIME column in SYS.USER$ shows the actual password expiration time of the user. The LTIME column shows time when account is locked.<\/td>\n<\/tr>\n
8-Jan<\/td>\n#oratidbit Transparent sensitive data protection (TSDP) is a new feature in #DB12c that enables you to quickly find all table columns in a database that hold sensitive data.<\/td>\n<\/tr>\n
9-Jan<\/td>\n#oratidbit Starting with 11g, the $ORACLE_HOME\/rdbms\/admin\/sql.bsq script is modularized, and calls multiple *.bsq scripts. In #DB12c 12.1.0, there are 25 *.bsq scripts called in sql.bsq.<\/td>\n<\/tr>\n
14-Jan<\/td>\n#oratidbit In #DB12c when Unified Auditing is enabled, audit records are queried from UNIFIED_AUDIT_TRAIL view. For better efficiency, audit records are written to SGA first and not written to disk until the in-memory queues are full. You may force a flush using SYS.DBMS_AUDIT_MGMT.FLUSH_UNIFIED_AUDIT_TRAIL procedure.<\/td>\n<\/tr>\n
15-Jan<\/td>\n#oratidbit AUDIT_SYSLOG_LEVEL init parameter enables SYS and standard OS audit records to be written to the system audit log using the SYSLOG utility.<\/td>\n<\/tr>\n
16-Jan<\/td>\n#oratidbit To enable unified auditing in #DB12c, relink the oracle executable using the uniaud_on option.
\ncd $ORACLE_HOME \/rdbms\/lib
\nmake -f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME<\/td>\n<\/tr>\n
19-Jan<\/td>\n#ortidbit Per MOS DOC 161818.1 Oracle Database (RDBMS) Releases Support Status Summary, 12.1.0.2 is the terminal 12.1 Patch Set and is currently only available for Enterprise Edition.<\/td>\n<\/tr>\n
20-Jan<\/td>\n#oratidbit RAC and DB Support Tools Bundle MOS in Doc 1594347.1. Tools include
\nORAchk (formerly RACcheck)
\nTrace File Analyzer Collector (TFA)
\nOSWatcher
\nProcwatcher
\nORATOP
\nSQLT
\nRemote Diagnostic Agent (RDA)
\nDiagnostic Assistant (DA)<\/td>\n<\/tr>\n
21-Jan<\/td>\n#oratidbit Check out the Databsae Diagnostic tools in MOS DOC 559339.1. Tools include
\nORA-600 Troubleshooting Tool
\nORA-1578 Troubleshooting Tool
\nORA-2730x Troubleshooting Tool
\nORA-3137 Troubleshooting Tool
\nORA-4030 Troubleshooting Tool
\nORA-4031 Troubleshooting Tool
\nORA-7445 Troubleshooting Tool
\nORA-600\/ORA-7445 Error Look-up Tool
\nDatabase Upgrade Troubleshooting Tool
\nRAC Node Eviction Troubleshooting Tool
\nEMDIAG Troubleshooting Tool<\/td>\n<\/tr>\n
22-Jan<\/td>\n#oratidbit Oracle Database Recommended Pathces in MOS DOC 756671.1. Be proactive!<\/td>\n<\/tr>\n
23-Jan<\/td>\n#oratidbit Check out MOS Doc 1555012.2 Troubleshooting Assistant: Oracle Database – Client \/ Install \/ Deinstall \/ Cloning<\/td>\n<\/tr>\n
26-Jan<\/td>\n#oratidbit Use the DBMS_PDB.DESCRIBE procedure on the non-CDB to generate the XML file, which you can use to plug in the non-CDB as PDB to a CDB.<\/td>\n<\/tr>\n
27-Jan<\/td>\n#oratidbit According to MOS Note 742060.1, Oracle Database 12c Release 2 is expected in First Half 2016.<\/td>\n<\/tr>\n
29-Jan<\/td>\n#oratidbit If Oracle Restart is installed, you can manage ASM instance, database instance, ASM diskgroup, listener, database service and Oracle Notification Services (ONS) using SRVCTL.<\/td>\n<\/tr>\n
30-Jan<\/td>\n#oratidbit “srvctl start home” starts all of the components that are managed by Oracle Restart in the specified Oracle home.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

\u201cOracle *daily* TidBits\u201d (#oratidbit) published at\u00a0https:\/\/www.facebook.com\/oraclenotes\u00a0on weekdays\u00a0in January 2015. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well\u2026 Hope you find these helpful to learn something new or to remind you of its existence and use\u2026 Publish Date TidBit 2-Jan … Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[27],"tags":[],"class_list":["post-1497","post","type-post","status-publish","format-standard","hentry","category-tidbits"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1497","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=1497"}],"version-history":[{"count":0,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1497\/revisions"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=1497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=1497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=1497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}