Utilities:Diagnostics

Making "Profile – Utilities:Diagnostics" YES will give enduser the ability to use Diagnostic without entering the APPS Password.

FORMAT_ERROR_STACK

Replace SQLERRM with the much better DBMS_UTILITY.format_error_stack. Now you will see the full error stack information -- but if the string exceeds 255 characters, you get an ERROR!

DBMS_OUTPUT.PUT_LINE (DBMS_UTILITY.format_error_stack);

FORMAT_ERROR_STACK

Replace SQLERRM with the much better DBMS_UTILITY.format_error_stack. Now you will see the full error stack information -- but if the string exceeds 255 characters, you get an ERROR!

DBMS_OUTPUT.PUT_LINE (DBMS_UTILITY.format_error_stack);

MSCA Turkish

After successful installation of Mobile Supply Chain Applications (MSCA) of Oracle Applications Release 11.5.10, we discovered Telnet client can not display characters for the Turkish language.

Telnet Protocol; Mobile Applications Framework's Presentation Manager Layer can send data to telnet clients in multi-byte. However, for telnet clients (whether it be a telnet client software on Microsoft Windows, Unix, etc. or a telnet client on a mobile device) to display characters for the specified language, system administrator's have to set the CHARACTER_SET parameter in their default_key.ini file (or whatever ini file they use for this in $MWA_TOP/secure directory) to the proper character encoding value.

For example, for West European character sets (like French ), CHARACTER_SET has to be set to WE8ISO8859P1. When this fails for you, try using the encoding scheme format for your characterset as referenced from java character codes:

For example, we tried using 'Cp1254' (case sensitive) for Turkish charactersets as the value in CHARACTER_SET.

Also check CLASSPATH. Some charactersets are available by default in the Basic Encoding set (rt.jar) file, while others are available in the Extended Encoding set (i18n.jar or characters.jar in the upper versions of Java). Therefore, CLASSPATH needs to include the correct file.

Tip : Oracle Home

When you have several oracle_home, here is a way to find which is the oracle home for a particular instance:

1) get the pid of a background process:
ps -edf | grep [o]ra_smon_ORAPRD01
oracle 307694 1 0 Jan 24 - 1:43 ora_smon_ORAPRD01

2) get its current working directory from /proc:
ls -l /proc/307694/cwd
lr-x------ 2 oracle dba 0 Feb 28 16:00 /proc/307694/cwd -> /app/oracle/product/9.2.0/dbs/

Here oracle_home is /app/oracle/product/9.2.0

Tip : dbms_java

By executing the following 2 statements in your session :

SET SERVEROUTPUT ON SIZE 1000000;
CALL DBMS_JAVA.SET_OUTPUT (1000000);

All the output of the System.out.println command in your stored procedures will be shown in your serveroutput. This gives you simple and fast way to debug your procedure like any other pl/sql procedure. It's jus like you would use the dbms_output.put_line proc.

Tip : 10g Problem

When you start to work with 10g, you will notice some "new" behavior that you didn't expect.
After install on a unix environment you aren't able to run sqlplus, tnsping from sthat server if you aren't the user or if you don't belong to DBA group.

It looks like that Oracle is not able to get the securirity right.
Their solution is close it for everybody (as in the big, bad world) and your save.
Now you, as a DBA, has to open it for the normal (non DBA) users and now YOU are responsable!
That's an easy solution of Mr. Oracle.

You need to run $ORACLE_HOME/install/changePerm.sh to lift the restrictions.
Note some directories are kep to restrictive, you need to execute in the ORACLE_HOME:
$ chmod O+rx lib lib2 ldap ldap/admin srvm/lib32

(Or better: Checkout Metalink note 363721.1 and download patch 5087548.)

Another effect is that the CONNECT role is changed (is more restrictive in 10g).
Restoring the role CONNECT of 10gR2 as it was in 9i:

SQL> @$ORACLE_HOME/rdbms/admin/rstrconn.sql

Tip : Easy Connect String

EZCONNECT - Easy Connect String
You can avoid having to use a TNSNAMES.ORA file by specifying the full connect string at the command prompt. The hostname is the only mandatory piece.

sqlplus username/password@ [//] hostname [:port] [/service_name]

Eg. sqlplus scott/tiger@10gserver:1521/ORCL


Ex :sqlplus scott/tiger@:1521/

Set up EZCONNECT in the sqlnet.ora file as follows:

NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)

This gives us easy and secure way of connecting to databases from client machine without leaving the DB information in TNSNAMES.ORA

This information is taken from http://www.dba-village.com/

Oracle Firefox Search Plugins

Mozilla Firefox

General Oracle Search Plugins

Install oracle-base-plugin - Searches the ORACLE-BASE.com site.
Install otn-plugin - Searches the Oracle Technology Network site.
Install oracle-metalink-plugin - Searches the Oracle Metalink site.

Oracle Error Search Plugins

Install oracle817-errors-plugin - Searches the Oracle 8.1.7 error messages manual.
Install oracle901-errors-plugin - Searches the Oracle 9.0.1 error messages manual.
Install oracle920-errors-plugin - Searches the Oracle 9.2.0 error messages manual.
Install oracle101-errors-plugin - Searches the Oracle 10.1.0 error messages manual.
Install oracle102-errors-plugin - Searches the Oracle 10.2.0 error messages manual.

Oracle Documentation Search Plugins

Install oracle817-docs-plugin - Searches the Oracle 8.1.7 manuals.
Install oracle901-docs-plugin - Searches the Oracle 9.0.1 manuals.
Install oracle920-docs-plugin - Searches the Oracle 9.2.0 manuals.
Install oracle101-docs-plugin - Searches the Oracle 10.1.0 manuals.
Install oracle102-docs-plugin - Searches the Oracle 10.2.0 manuals.

This information is taken from http://www.oracle-base.com

Standalone Reports Server on 10g R2 Developer

If you tried to install report server as NT service in 10gAS R2(10.1.2.0.2) , when you ran following command at command prompt;

rwserver -install autostart=yes

you will get the error message saying that "Please consult the installation guides for how to setup and run this program"

Beginning with Oracle Reports 10g Release 2 (10.1.2), running Reports Server as a Windows service is no longer supported ( rwserver -install server_name). As a result, the related command line keywords INSTALL and UNINSTALL are also obsolete.

Start or stop a Reports Server registered with Oracle Enterprise Manager 10g only through Oracle Enterprise Manager 10g/OPMN. OPMN automatically restarts Reports Server if it stops responding for some reason. On Windows, OPMN itself is run as a Windows service. Start the Reports Server as a standalone server on Windows using the following command:

rwserver server=server_name

Add the BATCH command line keyword to start up the server without displaying dialog boxes or messages.

rwserver server=server_name batch=yes