Download Discoverer Administrator

Hi All,

You Can download Oracle Discoverer Administrator from below URL.

http://www.oracle.com/technology/software/products/ids/htdocs/101202winsoft.html

Regards,
Phani.K

ERROR - ORA-20001: -: ORA-01422: exact fetch returns more than requested number of rows

I have encountered this error after migration from windows to Linux.

It can be reproducible from AR,AP modules.

The form Error is : A unpected error occurred in the programax_setup_pkg.refresh.

Issue Resolution:
Deleted duplicate entries in ax_setup_global table.

Regards,
Phani.K

j2sdk-1_4_2_04-linux-i586.bin Installation Issue in Linux5

Its for folks who want to install/migrate with same version of java in linux 5-32bit.

Change From "tail +466 $0 > $outname” To
"tail -n +466 $0 > $outname"

Change From

"if expr $sum1 != 06699 expr $sum2 != 34967 ; then" To
if "expr $sum1 = 06699 expr $sum2 != 34967 ; then"


Check the Java forum for more details.

http://forums.java.net/jive/thread.jspa?threadID=41305&tstart=0

Regards,
Phani.K

Archive Location for Java/Cygwin

Find the below urls for quick download of J2se and Cygwin releases.

http://java.sun.com/products/archive/

http://cygwin.paracoda.com/release/

Hope it helps for quick download.

Regards,
Phani.K

Cygwin to Maintain Release 11i/12i on Windows

Use cygwin in place of MKS toolkit to maintain Oracle Applications Release 11i/12i in on Windows. However oracle recommends to use MKS toolkit for all critical production and test systems.

Useful metalink notes for Cygwin installation

Note: 302859.1 Release 11i on Windows
Note: 414992.1 Release 12 on Windows

Regards,
Phani.K

ORA-01565: error in identifying file

Database cloning error in Windows 2003 environment.

This error message is followed by
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

Issue resolution:

1. Please check the identifying file location and make sure its located in the path.
2. Grant full access permissions to installation (oracle) user on oradata folder.
you can check permissions on folder -select properties - select security tab.

Regards,
Phani.K

FNDCPASS Utility introduced in 11.5.10 and Rollup6

Hi,

Run the new FNDCPASS Utility introduced in 11.5.10 RUP 6 to migrate Oracle Applications User passwords to a non-reversible hash password scheme with a single command-line invocation.

It will helpful to enhance security of applications.

For more details check Metalink Note:457166.1

Regards,
Phani.K

11G Database Upgrade

Hi,

Find the Metalink Note:452783.1 for interoperability note for Oracle EBS11i with Oracle Database 11i.

Regards,
Phani.K

Troubleshooting Guide

Integrating Oracle Application Server 10g with Oracle E-Business Suite Release 11i .

This Metalink note describes issues encounter when integrating or installing Oracle Application Server (Oracle As 10g) in an existing Oracle E-Business Suite Release 11i

Doc: 295606.1:

Oracle Application Server 10g with Oracle E-Business Suite Release 11i Troubleshooting

Doc: 429375.1:

How to unlink a FND_USER user account in Oracle EBusiness Suite that is linked to an SSO Account in Oracle Internet Directory


Note: Users are strongly advised to back up their environments before executing any of the procedures given, and to test the effects of the procedures before running them in a production environment

The Fetch Archive Log (FAL) in Oracle DataGuard

The fetch archive log (FAL) client and server resolve gaps detected in the range of archived redo log files generated at the primary database and received at the physical standby database.

FAL Server services: The FAL server services the FAL requests coming from the FAL client.

FAL Client services: The FAL client requests the transfer of archived redo log files automatically

Different types of Archive gaps and Problems handled by FAL mechanism:

1. When creating physical or logical standby database, the FAL mechanism can automatically
retrieve any archived redo log files generated during a hot backup of the primary database.

2. When you have multiple physical standby databases, the FAL mechanism can automatically
retrieve missing archived redo log files from another physical standby database.

3. The FAL client and server are configured using the FAL_CLIENT and FAL_SERVER
initialization parameters

Oracle Magzine Online

Find the Oracle Magzine for May/June-08

http://www.oraclemagazine-digital.com/oraclemagazine/20080506/

Oracle RAC docs

http://www.scribd.com/search?query=ORACLE+RAC

FATAL:Error inserting oracleasm

Error Message

(lib/modules//kernel/drivers/addon/oracleasm/oracleasm.ko) Permission denied

oracleasm: Unable failed

Kernel Ver:2.6.9-22.EL

Resolution:

Check for O.S

cat /etc/redhat-relase

Disable SELinux(RHEL4 U2 Only)

run as root

/usr/bin/system-config-securitylevel

After making changes need to reboot the server.


For more details check http://www.oracle.com/technology/pub/articles/hunter_rac10gr2_2.html#17

Hope it helps

Two Background Processes specific to an ASM

Apart from standard back ground processes, in ASM there are two new background processes.

RBAL: The Primary function of this background process is to open all disks listed under each disk group and to make them available to the various clients. It also created rebalance plan to move extents between the disks when a disk is added to disk group or removed from an existing disk group.

ARBn: The primary function of this background process is messaging and extent management this invoked only when disk rebalance or extent redistribution activity is required. Such activity happens when disk is added to the existing disk group or a disk is dropped from an existing disk group.

Ref:Murali V

Command to find Oracle Internet Directory(OID) version

$ORACLE_HOME/bin/ldapsearch -p port -D cn=orcladmin -w passwd -L -s base -b "" "objectclass=*" orcldirectoryversion

port: LDAP Port on OID server.

Docs for Migrating data between Oracle EBS and OracleID

http://download.oracle.com/docs/cd/B40089_05/current/acrobat/120sasg.pdf
section "Migrating Data between Oracle E-Business Suite Release 12 and Oracle Internet Directory"


Note 261914.1 - Integrating Oracle E-Business Suite Release 11i with Oracle Internet Directory and Oracle Single Sign-On
Download PDF document by clicking on the link "Integrating Oracle E-Business Suite Release 11i with Oracle Internet Directory and Oracle Single Sign-On".

Docs will help in migrating users from EBS to OID and OID to EBS.

Oracle open source

http://oss.oracle.com/

Oracle Open Source Software.

OEM Configuration in 10g using response file

create password file using orapwd

Create a response file (ex: resp)with below parameters:

ORACLE_HOME =
PORT =
SID =
HOST =
DBSNMP_PWD =
SYSMAN_PWD =
SYS_PWD =
DBCONTROL_HTTP_PORT =

emca -config dbcontrol db -repos (create/recreate) -silent -respFile resp


Note:If emca is failing with dbsnmp user/password invalid enter password in "" (eg: "welcome")

With out response file create repository.

emca -config dbcontrol db -repos create -SID DEV -PORT 1521 -ORACLE_HOME /u01/oracle/DEV/db/tech_st/10.2.0 -DBCONTROL_HTTP_PORT 1156

Oracle Portal Upgrade from 10.1.2.2 to 10.1.4

Doc: B19135-01 Portal Upgrade from 10.1.2.2 to 10.1.4

Latest: http://www.oracle.com/technology/products/ias/portal/index.html (Download Portal 10.1.4)

Patch 4960210 to Upgrade from 10.1.4 10.1.4.1

Displaying a URL Redirection Screen

You can choose whether to display a URL redirection screen or not. The URLredirection screen displays both the new and old URLs to assist in correctingbookmarks.When you access an old URL, the URL redirection screen is displayed by default. Toalter the default behavior, you can use the pobredir.sql script.

pobredir.sql script is located in portal/admin/plsql/wws directory in the upgrade CD-ROM.
The script takes 1 parameter.

Run the script as portal schema owner.

You need to download script from metalink 392703.1:showpassword to get the PORTAL password.

"Please check Caution in the Note:392703.1 "

Query to find the portal version from database.

Login to portal schema and run below query.

select version from wwc_version$

GNU Tar command to compress/extract files/folders in Linux

Download GNU Tar:
http://www.gnu.org/software/tar/
ftp://mirrors.kernel.org/gnu/tar/

We have many tools to compress files and folders in Linux.

1. Tar
Tar is sued to compress multiple files/folders into new file_name.tar.
It is used to create backup and archives.

2. Gzip
Gzip compress a file and replaces filename with filename.gz gunzip is used to extract filename.gz

3. Zip
Zip –r file_name , it will create new file_name.zip

Eg:
Compress
tar -zcvf file_name_newname.tarz file_name
Extract
tar -xvzf file_name_name.tarz

Configure ASM Using Files Instead of Real Devices in Linux

Sharing this doc from metalink Note:266028.1
This document is for Users intending to test the ASM (Automatic Storage Manager). It explains how to set up ASM, if there are no free partitions on own disk or no free disk device is available. This set-up should be used for testing or educational purposes only.
Steps needed from Linux OS point of viewFirst step: create the files, which will be used as free devices for ASM. As oracle user you can create files using 'dd' command

1- Create virtual disk file with 'dd' command of size 1Gb
$ dd if=/dev/zero of=_file_disk1 bs=1k count=1000000
$ dd if=/dev/zero of=_file_disk2 bs=1k count=1000000
$ ls -l total 200208
-rw-r--r-- 1 oracle dba 1024000000 Mar 19 23:58 _file_disk1
-rw-r--r-- 1 oracle dba 1024000000 Mar 19 23:58 _file_disk2
2- Using 'losetup' command, we will associate a loop device with a file.This time, you need the root account to execute these commands:
# losetup /dev/loop1 _file_disk1
# losetup /dev/loop2 _file_disk2
3- ASM is able to pick up block devices - i।e। /dev/loopXXX - directly without involving 'raw' interface.
If you want to use the raw devices, you need to bind a raw device to an existing block device:
# raw /dev/raw/raw1 /dev/loop1 /dev/raw/raw1: bound to major 7, minor 1 #raw /dev/raw/raw2 /dev/loop2 /dev/raw/raw2: bound to major 7, minor 1

Change the ownership of the raw devices :-
# chown oracle:dba /dev/raw/raw1
# chown oracle:dba /dev/raw/raw2
# chmod 660 /dev/raw/raw1
# chmod 660 /dev/raw/raw2

ORA-29701 Unable to Connect to Cluster Manager in Windows

I got this error when configuring ASM using dbca in windows server.

I have tried to delete and recreate CSS using localconfig delete/add.

But it didn't help in resolving issue. The CSS service shoes its starting....

Issue resolution:

I found there are other oracle products are installed on same server.I have changed environment variable point to new $ORACLE_HOME and restarted windows server.

From $ORACLE_HOME/bin i have deleted and recreated cluster services as given below.

localconfig delete

localconfig add

This process resolved my issue.

Commands to Monitor Memory usage in Linux

1.free

Displays total amount of free and used physical and swap memory in the system.

2.top

It is a command line interface which displays summary of all processes, free and used physical and swap memory in the system. It also includes c.p.u utilization.

3.gnome-system-monitor

Starart xserver and run gnome-system-monitor is a graphical user interface

4.vmstat

It Displays about virtual memory stats. Th information about process, memory,paging ,i/o and cpu utilization.




Ref:Red Hat Linux 9 Docs.

Initialization Parameters for ASM in Oracle 10G

The ASM instance has its own initialization parameter file and Server Parameter file.
ASM installation in clustered environments server parameters are not used unless there is shared ASM Oracle Home

The SID for ASM defaults to +ASM for a single instance database, +ASMnode# for Real Application Clusters


Initialization Parameters

INSTANCE_TYPE: Must be set to ASM

ASM_POWER_LIMIT: Default value 1, Range 0 to 11


ASM_DISKSTRING: Default Value NULL, strings that limits the set of disks that ASM discovers. String format depends on the ASM library in use and on the operating system.

Eg:
/dev/rdsk/*s6
/dev/rdsk/c2t1d*s3

ASM_DISKGROUPS: Default Value NULL

A list of the names of disk groups to be mounted by an ASM instance at startup or

ALTER DISKGROUP ALL MOUNT


Ref: Oracle Database Administrator guide B14231-02

Cluster Synchronization Services in Oracle 10G ASM

Automatic storage Management

Cluster Synchronization Services - CSS

The Cluster Synchronization Services is required to enable synchronization between ASM and its client database.
The CSS daemon is configured to start upon reboot while creating database using DBCA.
If we didn't use DBCA to create the database, we must ensure that the CSS daemon is running before starting ASM instance.

How to check CSS daemon is running

Linux

1. Issue the command crsctl check cssd

If CSS daemon is running the message result is CSS appears healthy.

2.To start CSS daemon and configure the host to always start the daemon with root.

3.Ensure $ORACLE_HOME/bin in PATH environment variable

4. localconfig add

Windows

1.

C:\>crsctl check cssd
Cluster Synchronization Services appears healthy

2. Open windows services and search for OracleCSService


Ref:Oracle Doc

Grid Computing(G)

Grid Computing is all about the concept of computing as a utility.

The Global Grid Forum is a standards body that develops starndards for grid computing.

Oracle is working with the GGF(Global Grid Forum) to help develop grid standards.

http://www.gridforum.org