Loading...
Oracle DBA Place by Noreply@blogger.com (yossi Nixon) - 2w ago

Problem: - AWR snapshots cannot be taken in a read-only standby environment - Performance monitoring and analysis is limited to basic STATSPACK functionality Solution: In Oracle Database 12.2, AWR...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

RequirementI was asked to have smart code that can connect to a local ASM instance without the need for any prior preparations like setting up the listener or any other changes in the database. And...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Making my day to day job easier and convenient I like having some utilities and some aliases.We, the DBAs nation, have a need to look at the alert.log file frequently. So basically, I did the...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Did you find yourself trying to convert your DBA scripts to work on other OS or UNIX flavors ?This is a typical issue DBAs cope with, the solutions can be: Each system has its own best scripting code...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Hi, In the next few blogs I will discuss on scripting technics that DBA usually needs.I am concentrating in the commands, that are usually part of larger script.Later on I will submit some scripts...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

At the source site  Enable the database to write to a directory you choose, in this example I use /tmpalter system set utl_file_dir='/tmp' scope=spfile; Restart of the database is...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

From Oracle 12.1 we have the ability to "record" the usage of permissions in our application and then we can narrow the permissions only to the minimal requirement.InstallationCREATE USER YOSSI...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

In Oracle Restart, there are two confusing commands for setting up restart behavior. 1. SRVCTL command. srvctl add/modify database -y {AUTOMATIC | MANUAL}Management policy for the database. If...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Look at the current port configured for the scan_listener$ srvctl config scan_listener SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521 SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521 SCAN...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

When a given tns alias is not working, via SQL*Plus, database link or within data guard, traditionally I troubleshoot connectivity via tnsping utility, at first just to understand the target host,...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
Read Full Article
Visit website

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview