Archive for April, 2008
How to send email from 10g Oracle Database (UTL_MAIL)
Heres a simple solution to send out emails from 10g Database sql prompt.
This solution will be really helpful if the OS utility (mailx, sendmail) is restricted for end users.
Steps to enable Mailing from Database
1. sqlplus ‘/ as sysdba’
2. @$ORACLE_HOME/rdbms/admin/utlmail.sql
3. @$ORACLE_HOME/rdbms/admin/prvtmail.plb
4. Set smtp_server information in init.ora or spfile.ora
alter system set smtp_out_server = ‘SMTP_SERVER_IP_ADDRESS:SMTP_PORT’ scope=both;
25 = Default [...]
Installing / Configuring APEX (Application Express / HTMLDB) in 10gR2 on Windows XP
Apex 3.1 works with all versions above 9203, (including Oracle 11g). In this article the steps are defined for Installing apex_3.1 on 10gR2 (10.2.0.1)
Step 1: Download 10gR2 software (http://www.oracle.com/technology/software/products/database/index.html)
Step 2: Download 10gR2 Companion CD (for HTTP Server) (http://www.oracle.com/technology/software/products/database/index.html)
Step 3: Download apex_3.1 from http://apex.oracle.com or http://www.oracle.com/technology/products/database/application_express/download.html
Step 4: Install 10gR2 software and create a general database as [...]
Snlinaddrlocalhost Error while connecting to 10gR2 Database on Windows XP
I encountered this strange error on one of my testing database when i tried to connect to the database using sqlplus.exe (command line) and not through sqlplusw.exe.
Error Message Popup “Procedure Entry Point Snlinaddrlocalhost Could Not Be Located In The Oranl10.Dll”
Environment Details
10gR2 DB Oracle Home : C:\oracle\product\1020
10gAS Oracle Home: C:\product\as\1020
To troubleshoot this further i opened windows [...]
How to change the default banner / logo / image on the Apps Login Page?
Here are the steps to change the default Oracle Logo to a Custom Corporate Logo.
Step – 1: Create cusom image (gif/jpeg) (eg. aaa.gif)
Step – 2: Copy custom logo (aaa.gif) to $OA_MEDIA
Step – 3: Check & update Profile Option name “FND_CORPORATE_BRANDING_IMAGE” to point to aaa.gif
Step – 4: Backup existing image files under $OA_MEDIA
mv FNDSSCORP.gif FNDSSCORP.gif.old
Step – [...]
DISPLAY variable in 11i and R12
Is DISPLAY variable must in R12 to display chart/graphs and reports?
Before going into that, lets see whats the impact of setting a wrong value to the DISPLAY variable in 11i.
1) Charts & Graphs cant be viewed (it will be blank with x mark)
2) Reports cannot be viewed in browser (like concurrent request output etc.,)
Troubleshooting the [...]
Where are the log files located in R12?
For DBA’s who mostly worked on 11i environments, finding the log files (Concurrent manager log, apache log etc.,) on a R12 environment might pose a threat initially, because these log files no longer reside in their old location ie., $APPLCSF/$APPLLOG or $APACHE_TOP/Apache/logs.
In R12, the log files are located in $LOG_HOME (which translates to $INST_TOP/logs)
Concurrent Reqeust [...]
Staging files for Oracle Apps installation
Hi,
Heres a single “for loop” (Unix) to stage the installation files (*.zip) under specific directories without creating the required directories.
$cd <location where .zip files are copied>
for i in ls -l *.zip
do
unzip -od <staging locaion> $i
done
It is always advisable to verify the zip files before extracting. You can use the same “for loop” with different unzip [...]
