3 Eylül 2012 Pazartesi

ORA-12162 TNS:net service name is incorrectly specified


Problem:

After you installed ORACLE database,if you want to connect database with sqlplus,you get a this error

********************************************************
*ORA-12162 TNS:net service name is incorrectly specified
********************************************************

Solution:

You have to add your database SID in your '.bash_profile' or if you use Solaris file is '.profile'

export ORACLE_SID=<SID>


Good luck:))

10 Ağustos 2012 Cuma

Message dictionary couldn't open the CLE application message file.Can't open file $CLE_TOP/mesg/US.msg for reading















Problem:

Message dictionary couldn't open the CLE application message file.Can't open file
$CLE_TOP/mesg/US.msg for reading

Solution:

Navigate to Applications Developer responsibility:
Run concurrent request: Generate Messages, with the following parameters:
Language: US
Application: CLE
Mode: DB_TO_RUNTIME

Then try
cd $CLE_TOP

cd mesg

ls

US.msg is came:))







7 Ağustos 2012 Salı

The following error occurs during execution of apwdame1.sql


Problem:

When attempting to apply Oracle Internet Expenses Mini-pack 11i.OIE.K (4165000)
the following error occurs during execution of apwdame1.sql


Solution:

Apply Patch 4873179 to Application

Re-apply the OIE Patch 4165000

RC-20200: Fatal: Could not find Unzip



Problem:

0% completed RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.
Please make sure you have UnZip 5.X in your path and try again.

Solution:

Apply patch 9874305 on Application

Then;

Set your java and unzip in your .profile(bash_profile) file


19 Temmuz 2012 Perşembe

ERROR [code=-1] compiling out of date JSP files


Problem:

ERROR [code=-1] compiling out of date JSP files


Solution:

1)cd $ADMIN_SCRIPTS_HOME

bash-4.2$ ./adautocfg.sh

2)cd /data_appl/apps/apps_st/appl/fnd/12.0.0/patch/115/bin

bash-4.2$ perl ojspCompile.pl --compile --quiet


Installing 8626084 10.1.3 Application Server patch(error: writing to file)




Problem:We installed ebs 12.1.1 on IBM AIX on POWER Systems (64-bit) version 6.1.Then started 
the 12.1.3 upgrade;when install 8626084 application server patch we get an error.
This error like below:

Our opmn.xml include 'data1/R12/ab/apps/XB9R1211/apps/tech_st/10.1.3'
But this isn't my ORACLE_HOME.There isn't like this home so upgrade installation
is failed.We created an SR,we gave all of logs.After 1 week one man from oracle
support advice a document.Documnet id is below,also error's screenshot and error logs.

The solution to this document( [ID 1086315.1]):

Solution:edit comps.xml file check all the failure ORACLE_HOME and replace real ORACLE_HOME,
then run adautocfg.sh.

Of course for all of them,firsly you set 10.1.3 env:)))


error blog include:
LPX-00202: could not open "/dbhome/data_appl/inst/apps/BRLPROD_burladb/ora/10.1.2/opmn/conf/opmn.xml" (error 200)
XML parse failed: error 202.


6 Temmuz 2012 Cuma

unzip command not found in AIX

I get this error when I want to extract unzip files

problem:unzip command not found

so you have to install aix unzip rpm

you can download this site:

http://www-03.ibm.com/systems/power/software/aix/linux/toolbox/alpha.html

After you downloaded rpm

su - root

change directory where rpm is  in there

solution:rpm -ivh unzip-5.51-1.aix5.1.ppc.rpm

Then you can unzip .zip files.

good luck:)))