VIRTUALDBA.NL

some notes about oracle

ORA-00604 / ORA-12705

ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified You might see this combination of error messages in a situation where an Oracle 12c listener is used to service an Oracle11G database, and static service registration is used in the listener (without specifying the NLS_ORA10 variable) Read more about ORA-00604 / ORA-12705[…]

dgmgrl should prompt for password when using a tnsname to connect

We would like to start the observer with a script, but don’t want to provide the password on the command line. We have a framework in place which expects the oracle tool to ask for the password, unfortunate it seems not to be possible to use the same behaviour when using a tns connect string Read more about dgmgrl should prompt for password when using a tnsname to connect[…]

Dataguard Performance Tab not showing Charts – OEM 13c

If your Dataguard Performance tab is not showing the graphs in Oracle Enterprise Manager 13C, but your screen look like this: Then this might be solved by running the ‘Verify Dataguard Configuration’ which will fix a mismatch between the OEM and the actual broker configuration. I have found a post on the site of ItConquer for Oracle Enterprise Read more about Dataguard Performance Tab not showing Charts – OEM 13c[…]