Can not obtain Oracle client information from registry. Make sure that Oracle Client Software is installed, or use Direct mode of connecting to server.
When using Devart LinqConnect driver to connect to your Oracle database, you receive following error message when running your .NET …
Display OLE DB Providers
Sometimes it can happen that you need to change a property for a certain OLE DB drivers, such as the …
component ‘SET_NO_OUTLINES’ must be declared
When exporting data from a database, you receive following error: EXP-00056: ORACLE error 6550 encountered ORA-06550: line 1, column 41: …
Create an Oracle password file
Oracle password file In order to startup an Oracle database, one need to have either an Oracle password file or …
Write a message to a trace file or the alert.log file
In case you want to write something to the Oracle alert.log file, you can use an undocumented package procedure to …
Location of alert.log file
The alert.log file contain messages related to the startup and running of a specific database. The name of the alert.log …
Enable database auditing
Oracle database auditing can be enabled by setting the audit_trail initialization parameter. You can check the current status using following …
Enable 10046 trace in a session
There are a number of ways to trace a session: Enable trace at the beginning of your session Enable trace …
Generate Workload CPU statistics using dbms_stats.gather_system_stats
In Oracle 9i and up, you can generate CPU cost information during a workload with a procedure of the dbms_stats …
Oracle startup sequence
The Oracle startup phase consist out of 3 steps: nomount phase: during this phase, the initialization file is read mount …
DbMotive is an