28 October 2010

adbldxml.pl DB tier errors out: FOLLOWING ERROR OCCURED : 3 >= 3

adbldxml.pl DB tier errors out: FOLLOWING ERROR OCCURED : 3 >= 3

The critical error i faced during the upgrade database to 11.2.0 from 9.2.0.5 in oracle Applications 11.5.10.2

Error during adbldxml.pl on Database Tier

FOLLOWING ERROR OCCURED :

3 >= 3


StackTrace:
java.lang.ArrayIndexOutOfBoundsException: 3 >= 3
at java.util.Vector.setElementAt(Vector.java:505)
at oracle.apps.ad.context.GenerateContext.setJRETOP(GenerateContext.java:7471)
at oracle.apps.ad.context.GenerateContext.InstantiateRestForDB(GenerateContext.java:3045)
at oracle.apps.ad.context.GenerateContext.main(GenerateContext.java:8138)



Cause for this issue:
  • GenerateContext.java Release reported in the logfile is 115.87
  • Latest version of GenerateContext.java is 115.103
You need to apply the patch 4709948 in the apps Tier using the tnsnames.ora and listener.ora just we created during the upgrade process in latest RDBMS_ORACLE_HOME (11.2.0)


once applied the patch, synchronize the DB Tier with Apps Tier using admkappsutil.pl from $AD_TOP/bin

Run adbldxml.pl from db Tier now. The error should not appear now.

27 October 2010

ERROR: OPatch failed because of Path problem.

[oracle@muthu 2615271]$ /oracle/NEW/newdb/9.2.0/OPatch/opatch apply
PERL5LIB=/oracle/NEW/newdb/9.2.0/Apache/perl/lib/5.00503:/oracle/NEW/newdb/9.2.0/OPatch/perl_modules; export PERL5LIB
/oracle/NEW/newdb/9.2.0/Apache/perl/bin/perl /oracle/NEW/newdb/9.2.0/OPatch/opatch.pl apply

OPatch Version 1.0.0.0.48
Perl Version 5.00503

/oracle/NEW/newdb/9.2.0/OPatch/opatch.pl version: 1.0.0.0.48
Copyright (c) 2001,2002,2003 Oracle Corporation. All Rights Reserved.

Some commands below are not in your path:
  Command= fuser
  Path= /oracle/NEW/newdb/9.2.0/Apache/perl/bin:/oracle/NEW/newdb/9.2.0/bin:/usr/bin:/usr/sbin:
/oracle/NEW/newdb/9.2.0/jre/1.4.2/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/kerberos/bin:
/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin

ERROR: OPatch failed because of Path problem.
[oracle@muthu 2615271]$ which fuser
/usr/bin/which: no fuser in (/oracle/NEW/newdb/9.2.0/Apache/perl/bin:/oracle/NEW/newdb/9.2.0/bin:
/usr/bin:/usr/sbin:/oracle/NEW/newdb/9.2.0/jre/1.4.2/bin:/usr/ccs/bin:/bin:/usr/bin/X11:
/usr/local/bin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin)
[oracle@muthu 2615271]$ find / -type f -name fuser
[oracle@muthu 2615271]$ su
Password:
[root@muthu 2615271]# find / -type f -name fuser
/sbin/fuser
[root@muthu 2615271]# exit
exit
[oracle@muthu 2615271]$ vi /oracle/NEW/newdb/9.2.0/NEW_muthu.env

[oracle@muthu 2615271]$ . /oracle/NEW/newdb/9.2.0/NEW_muthu.env

[oracle@muthu DBupdate]$ cd 4167403/
[oracle@muthu 4167403]$ /oracle/NEW/newdb/9.2.0/OPatch/opatch apply
PERL5LIB=/oracle/NEW/newdb/9.2.0/Apache/perl/lib/5.00503:/oracle/NEW/newdb/9.2.0/OPatch/perl_modules; export PERL5LIB
/oracle/NEW/newdb/9.2.0/Apache/perl/bin/perl /oracle/NEW/newdb/9.2.0/OPatch/opatch.pl apply

OPatch Version 1.0.0.0.48
Perl Version 5.00503

Oracle Home = /oracle/NEW/newdb/9.2.0
Location of Oracle Inventory = /oracle/NEW/newdb/9.2.0/inventory
Oracle Universal Installer shared library = /oracle/NEW/newdb/9.2.0/oui/lib/linux/liboraInstaller.so
Path to Java = /oracle/NEW/newdb/9.2.0/jre/1.4.2/bin/java
Location of Oracle Inventory Pointer = /etc/oraInst.loc
Location of Oracle Universal Installer components = /oracle/NEW/newdb/9.2.0/oui
Required Jar File under Oracle Universal Installer = jlib/OraInstaller.jar


Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /oracle/NEW/newdb/9.2.0)
Is this system ready for updating?
Please respond Y|N >
y
Patching...
Updating inventory...
/oracle/NEW/newdb/9.2.0/OPatch/opatch.pl version: 1.0.0.0.48
Copyright (c) 2001,2002,2003 Oracle Corporation. All Rights Reserved.


OPatch succeeded.
[oracle@muthu 4167403]$

20 October 2010

Oracle Application R12.1.1 inactive manager error

inactive manager error

[oracle@balaji scripts]$ ps -ef |grep FNDLI
oracle    7411  3765  0 11:27 pts/2    00:00:00 grep FNDLI
[oracle@balaji scripts]$

Use sqlplus, login as APPLSYS
SQL>update fnd_concurrent_queues set running_processes=0;

go to your sidappl dirctory and
ls *.env
run APPSSID*.env
-cd $COMMON_TOP/admin/scripts/*
sh adstpall.sh apps/apps this will sto apps tire
-run the follwoing file form the same path adautocfg.sh
then start every thing up by runing adstrtal.sh apps/apps

[oracle@balaji scripts]$ ps -ef |grep FNDLI
oracle   14318 14313  0 01:48 pts/1    00:00:00 FNDLIBR                                                                                                                                               
oracle   14593 14472  0 01:48 ?        00:00:00 FNDLIBR                                                                                                                                                                                                                                       
oracle   14594 14472  0 01:48 ?        00:00:00 FNDLIBR                                                                                                                                                                                                                                       
oracle   14595 14472  0 01:48 ?        00:00:00 FNDLIBR                                                                                                                                                                                                                                       
oracle   14596 14472  0 01:48 ?        00:00:00 FNDLIBR                                                                                                                                                                                                                                        
oracle   15185   953  0 01:50 pts/1    00:00:00 grep FNDLI
[oracle@balaji scripts]$

19 October 2010

error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory undefined symbol: dbm_firstkey

 I have installed the new R12.1.1 on Linux 5.5 32bit OS

i am getting below error   

Error1:-

error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory
Error2:-
Cannot load /oracle/BALAJI/apps/tech_st/10.1.3/Apache/Apache/libexec/mod_ossl.so into server: /oracle/BALAJI/apps/tech_st/10.1.3/Apache/Apache/libexec/mod_ossl.so: undefined symbol: dbm_firstkey

Solution:-

Please download below patch

https://updates.oracle.com/ARULink/PatchDetails/process_form?patch_num=6078836

Patch Number is =6078836

then unzip the patch login as a root user copy libdb.so.2  past to  /usr/lib

Then start all services

SP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE may not be functioning properly

I have upgraded the 9.2.0.8 to 11.2.0 am using DBUA installation is finished with out error .
I have source the ENV file am getting below error

Error:-
[oracle@muthu 11.2.0]$ sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

Solution:-
Problem is Zonal file is missing

[oracle@muthu ~]$cd /oracle/NEW/newdb/11.2.0/oracore/zoneinfo/
[[oracle@muthu zoneinfo]$ ln -s timezone_11.dat timezone.dat
[oracle@muthu zoneinfo]$ ln -s timezlrg_11.dat timezlrg.dat
Then error is resolved

18 October 2010

R12 prerequisite for Linux32bit

You need to have the following packages installed before you start R12 installation (32-bit) on OEL:

glibc-2.3.4-2.25
glibc-common-2.3.4-2.25
binutils-2.15.92.0.2-21
compat-libstdc++-296-2.96-132.7.2
gcc-3.4.6-3
gcc-c++-3.4.6-3
libgcc-3.4.6-3
libstdc++-3.4.6-3
libstdc++-devel-3.4.6-3
openmotif21-2.1.30-11.RHEL4.6**
pdksh-5.2.14-30.3
setarch-1.6-1
make-3.80-6.EL4
gnome-libs-1.4.1.2.90-44.1
sysstat-5.0.5-11.rhel4
compat-db-4.1.25-9
control-center-2.8.0-12.rhel4.5
xscreensaver-4.18-5.rhel4.11
libaio-0.3.105-2
libaio-devel-0.3.105

To query all installed packages. This command will print the names of all installed packages installed on your Linux system

# rpm -qa  package name

To query a RPM package. This command will print the package name, version, and release number of the package foo only if it is installed. Use this command to verify that a package is or is not installed on your Linux system.

Check the operating system media for information on obtaining and applying packages. You may also check:

RPM Search
http://rpm.pbone.net/

RPM repository
http://rpmfind.net/linux/RPM/

Note: 402310.1 - Oracle Applications Installation and Upgrade Notes Release 12 (12.0) for Linux (32-bit)
https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=402310.1

VMWare Server 2.0 fails installation with Windows Installer Error 1718 - MSI was rejected by digital signature policy

VMWare Server 2.0 fails installation with Windows Installer Error 1718 - MSI was rejected by digital signature policy

  I was recently installing VMWare Server 2.0 (the freely available VMware virtualization platform) and I found that after the installation initialized it threw this error message:
In doing a quick bit of research, I discovered that this is some type of an issue with Windows Installer engine with large MSIs.  Essentially Windows Installer is unable to allocate the necessary virtual memory to verify the integrity of the MSI.  The strange part about this issue for me is that this server has 6 GB of RAM and there's absolutely nothing else running on it....Strange eh?
Anyway, MS has a hotfix for this issue.  Download and install KB925336 and you'll be good to go.

13 October 2010

How to create context file in DB tier

[oracle@muthu bin]$ ./adbldxml.pl tier=db appsuser=apps appspass=apps

Starting context file generation for db tier..
Using JVM from /oracle/NEW/newdb/11.2.0/jre/1.4.2/bin/java to execute java programs..

The log file for this adbldxml session is located at:
/oracle/NEW/newdb/11.2.0/appsutil/log/adbldxml_10131027.log
AC-20010: Error: File - listener.ora could not be found at the location:
        /listener.ora
indicated by TNS_ADMIN. Context file can not be generated.

Could not Connect to the Database with the above parameters, Please answer the Questions below


Enter Hostname of Database server: muthu.testserver.com

Enter Port of Database server: 1526

Enter SID of Database server: NEW

The context file has been created at:
/oracle/NEW/newdb/11.2.0/appsutil/NEW_muthu.xml
[oracle@muthu bin]$

08 October 2010

Oracle : Unlimited Tablespace, User Creation,Tablespace creation

Oracle : Unlimited Tablespace, User Creation


SQL> create user muthu identified by oracle
2 default tablespace users;
User created.
SQL> grant connect to muthu;
Grant succeeded.
SQL> grant create any table to muthu;
Grant succeeded.
SQL> grant create table to muthu;
Grant succeeded.
SQL> grant unlimited tablespace to muthu;
Grant succeeded.

Create table space
SQL>create tablespace data datafile '/home/oracle/databases/ora10/data.dbf' size 30m autoextend on;

06 October 2010

ORA-12537 TNS: Connection Closed

When I was trying to establish client connection to one of our databases running on Oracle 11g, I received “ORA-12537 TNS: Connection Closed” error.
Upon investigation, I came across “TCP.VALIDNODE_CHECKING” parameter in “sqlnet.ora” file. This was set to “YES”. please set tp "NO" or   simply commented this parameter and every thing went fine. Clients were able to establish connection to the database. By setting TCP.VALIDNODE_CHECKING to “YES”, you inform Oracle database to allow/deny connections to the listed nodes. You may list the invited nodes using TCP.INVITED_NODES parameter in sqlnet.ora file or, alternatively, you may use the TCP.EXCLUDED_NODES parameter to disallow database connections from the listed nodes. Hope you find this information helpful!!!

04 October 2010

Basic Linux Commands


Basic Linux Commands
Command                  Example                                            Description
cat           Sends file contents to standard output. This is a way to list the contents of short files to the screen. It works well with piping.
       cat .bashrc   Sends the contents of the ".bashrc" file to the screen.


cd            Change directory
       cd /home      Change the current working directory to /home. The '/' indicates relative to root, and no matter what directory you are in when you execute this command, the directory will be changed to "/home".
      

cd httpd      Change the current working directory to httpd, relative to the current location which is "/home". The full path of the new working directory is "/home/httpd".
      

cd ..  Move to the parent directory of the current directory. This command will make the current working directory "/home.
      

cd ~   Move to the user's home directory which is "/home/username". The '~' indicates the users home directory.
cp            Copy files
       cp myfile yourfile   Copy the files "myfile" to the file "yourfile" in the current working directory. This command will create the file "yourfile" if it doesn't exist. It will normally overwrite it without warning if it exists.
      

cp -i myfile yourfile      With the "-i" option, if the file "yourfile" exists, you will be prompted before it is overwritten.
      
cp -i /data/myfile . Copy the file "/data/myfile" to the current working directory and name it "myfile". Prompt before overwriting the file.
      
cp -dpr srcdir destdir     Copy all files from the directory "srcdir" to the directory "destdir" preserving links (-p option), file attributes (-p option), and copy recursively (-r option). With these options, a directory and all it contents can be copied to another directory.


dd     dd if=/dev/hdb1 of=/backup/       Disk duplicate. The man page says this command is to "Convert and copy a file", but although used by more advanced users, it can be a very handy command. The "if" means input file, "of" means output file.


df            Show the amount of disk space used on each mounted filesystem.
less   less textfile Similar to the more command, but the user can page up and down through the file. The example displays the contents of textfile.

ln            Creates a symbolic link to a file.
       ln -s test symlink   Creates a symbolic link named symlink that points to the file test Typing "ls -i test symlink" will show the two files are different with different inodes. Typing "ls -l test symlink" will show that symlink points to the file test.

locate        A fast database driven file locator.
       slocate -u    This command builds the slocate database. It will take several minutes to complete this command. This command must be used before searching for files, however cron runs this command periodically on most systems.
       locate whereis       Lists all files whose names contain the string "whereis".

logout        Logs the current user off the system.

ls            List files
       ls     List files in the current working directory except those starting with . and only show the file name.
       ls -al List all files in the current working directory in long listing format showing permissions, ownership, size, and time and date stamp

more          Allows file contents or piped output to be sent to the screen one page at a time.
       more /etc/profile    Lists the contents of the "/etc/profile" file to the screen one page at a time.
      
ls -al |more  Performs a directory listing of all files and pipes the output of the listing through more. If the directory listing is longer than a page, it will be listed one page at a time.

mv            Move or rename files
       mv -i myfile yourfile      Move the file from "myfile" to "yourfile". This effectively changes the name of "myfile" to "yourfile".
      
mv -i /data/myfile . Move the file from "myfile" from the directory "/data" to the current working directory.

pwd           Show the name of the current working directory
       more /etc/profile    Lists the contents of the "/etc/profile" file to the screen one page at a time.

shutdown             Shuts the system down.
       shutdown -h now      Shuts the system down to halt immediately.
       shutdown -r now      Shuts the system down immediately and the system reboots.

whereis              Show where the binary, source and manual page files are for a command
       whereis ls    Locates binaries and manual pages for the ls command.
      


How to block website address for server2003


  1. Login to your server through Terminal Services or Remote Desktop Connection.

  2. Click Start, select Programs, and then click Administrative Tools.


    • For IIS 5.0 click Internet Services Manager.

    • For IIS 6.0 click Internet Information Services.


  3. In the left column you will see the Server Name.


    • In IIS 5.0, expand the Server Name to find the domain name.

    • In IIS 6.0, expand the Server Name and then Web Sites to find the domain name.


  4. Right-click on the domain name and select Properties

  5.  

  6. On the Directory Security Tab under IP Address and Domain Name Restrictions click Edit.

You have two options, you can grant access to all computers and restrict individual IP's or you can deny access to all computers and grant access to specific IP's. By default, all users will be granted access to your site except the IP addresses you specify.

To add an IP address to the restriction list, please follow these steps:

  1. Click Add.


  2. Select the type:


    • Single Computer - add a single IP Address.

    • Group of Computers - add a block IP Address using the starting IP address of the block and the appropriate subnet mask.

    • Domain Name - add a domain name (this method is not recommended).


  3. Click Ok.

http://www.hostmysite.com/support/dedicated/IIS/blockip/

How to change ip address in solaris

# touch /etc/resolv.conf

Open /etc/resolv.conf using vi text editor:
# vi /etc/resolv.conf
Add the following lines to it:

search domainname
nameserver 202.54.1.30
nameserver 202.54.1.18

Where,

    * nameserver IP : It is IP of first DNS server
    * search nixcraft.in : Default domain name to search. For example, if you type command nslookup www, it will search it as www.nixcraft.in

2) Enable the name resolving using DNS as follows:
# cp /etc/nsswitch.dns /etc/nsswitch.conf
3) Test new name server by running the nslookup command as follows:
# nslookup nixcraft.in
OR
# /usr/sfw/sbin/nslookup nixcraft.in
Output:

Server:  (domain name)
Address:  address

Non-authoritative answer:
Name:    (domain name)
Address:  address



I recently needed to change the IP address of 2 new Solaris 10 Sparc boxes. I made the normal changes
/etc/hosts
/etc/hostname.bge0
/etc/resolv.conf
/etc/netmasks
/etc/nodename &
/etc/defaultrouter
(why can't we get these into one file?)

But when rebooted, the server still remembered its old IP address and settings even though
I couldn't grep that IP anywhere. I eventually had to do a sys-unconfig which I was hoping to avoid.
 Is there some other way to change an IP in solaris 10?

This is a great 'feature'. ;-)
/etc/inet/ipnodes
is the /etc/hosts for IPv6.

It's been there, pretty much
empty, for ages and ages, but
in S10 it is populated at install
time -- so edit that file too, and
all will be well. It's entries trump
those in /etc/hosts...

01 October 2010

FRM-92150 Web client version too new

FRM-92150: WEB Client version too new

The fix is as below:
Source the Apps ENV 

#cd $ORACLE_HOME
#cd forms/lib 

run
$make -f ins_forms.mk sharedlib

then check it your problem is resolved  if not try second method

 Second Method

FRM-92150 Web client version too new

Error:

While we click the responsibility, the form opens at that time the following error comes:

FRM-92150 Web client version too new

Solution:
========

1. Remove all folder named Java, Jinit etc and go to the program file in that delete the oracle folder itself because it contains Jar files only.

2. From control panel add/remove Programs remove java versions.

3. Clear the temp, cache etc.

4. Go to Regedit

A) HKEY_CURRENT_USER -> software - >ORACLE // remove that oracle folder itself.

B) HKEY_LOCAL_MACHINE -> software -> ORACLE // remove that oracle folder.

5. Now clear and check all jar files are removed.

6. Go to internet properties --> securities --> In that Local Internet option --> custom level -->Low and ok.

7. Now restart the PC and go to that responsibilty and click . New Jar files will be downloaded and it will be proper.

Note:

This Jar files are loaded from the apps server in the location COMMON_TOP/util/jinitiator.jinit.exe