Sandeep Panchal Blog

Hello Everyone, I was a bit busy from last couple of months and was away from writing, I got a new laptop yesterday and i am planning to be in action again. Thanks all for your support and your encouraging comments. Thanks and Regards Sandeep Panchal.

SQL> desc emp; Name Null? Type ----------------------------------------- -------- EMPNO NOT NULL NUMBER(4) ENAME VARCHAR2(10) JOB VARCHAR2(9) MGR NUMBER(4) HIREDATE DATE SAL NUMBER(7,2) COMM NUMBER(7,2) DEPTNO NUMBER(2) SQL> alter table emp rename column sal to salary; Table altered. SQL> desc emp; Name Null? Type ----------------------------------------- -------- ------------------------ EMPNO NOT NULL NUMBER(4) ENAME VARCHAR2(10) JOB VARCHAR2(9) MGR NUMBER(4) HIREDATE DATE SALARY NUMBER(7,2) COMM NUMBER(7,2) DEPTNO NUMBER(2) SQL>

Identifying the trace file is not a complex task. But its not very easy also. Oracle helps in identifying the correct tracefile for a session. ALTER SESSION SET tracefile_identifier=SANDEEP; Then you can easily identify the file. Oracle will generate the file name like sid_ora_pid_SANDEEP.trc OR if you have session id, You can query, v$session to check the column tracefile. Hope this helps. Regards Sandeep Panchal.

Covert to Shared appltop. : This was tested on 11.5.10, Please check the Oracle documentations for the latest patches and updates. (Ref: metalink note : Sharing the Application Tier File System in Oracle Applications Release 11i [ID 233428.1] ) 1 Verify the pre-requisites 1.1 Software Requirements: Ensure that these minimum versions are present in your system. • 5035661 to each iAS ORACLE_HOME in the application tier. • TXK AutoConfig Templates RUP O or higher (Apply patch 5478710 to each APPL_TOP in the application tier) • TXK Technology Stack Minipack B (Apply patch 3219567 to each APPL_TOP in the application tier) • AD Mini-pack I or higher (Apply patch 4038964) • iAS Oracle HTTP Server Rollup 5 or higher (Apply the latest critical patch update available for Oracle E-Business Suite 11i. Refer to section "Oracle HTTP Server Patches for Oracle E-Business Suite 11i" for instructions) • Discoverer 4.1.48.08 (See OracleMetaLink Doc ID: 139516.1 OracleMetaLink Doc...

I was just exploring the 11g software CD and found very interesting script. sshUserSetup.sh , While RAC installation to create the user equivalence this script will be very useful. running keygen and scp is a boring task. This script makes your life easy. cd -mount-/oracle/sshsetup sshUserSetup.sh -hosts "host1 host2" -user oracle -advanced ========================================================================== Script Location [root@rac1 database]# ls -ltr total 36 -rwxr-xr-x 1 root root 3226 Aug 15 2009 runInstaller drwxr-xr-x 2 root root 4096 Aug 15 2009 rpm drwxr-xr-x 4 root root 4096 Aug 15 2009 install drwxr-xr-x 14 root root 4096 Aug 15 2009 stage drwxrwxr-x 2 root root 4096 Aug 15 2009 sshsetup drwxrwxr-x 2 root root 4096 Aug 15 2009 response drwxr-xr-x 12 root root 4096 Aug 17 2009 doc -rw-r--r-- 1 root root 5402 Aug 17 2009 welcome.html [root@rac1 database]# pwd /data3/database [root@rac1 database]# cd sshsetup [root@rac1 sshsetup]# ls ssh...

My suggestion: To start with , Read more and more about Oracle application architecture and Oracle applications Utilities. 1. How to learn Oracle applications Architecture :   Oracle Applications Architecture diagram.   Image from Oracle Applications Concepts Release 12  Part No. B31450-04 This is the very basic explanation of Oracle applications Architecture.   It explains Multi Tiered computing supports Oracle applications Product. 1. Desktop Tier :    The client interface is provided through HTML for HTML-based applications, and via a  Java applet in a Web browser for the traditional Forms-based applications. 2. Application Tier :     In General this is the actual host for Oracle Applications . Three servers or service groups comprise the basic application tier for Oracle Applications: Web services : The Web services component of Oracle Application Server processes requests received  over the network ...