Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
11i Forms Compilation on aix

11i Forms Compilation on aix

2004-03-29       - By April Wells
Reply:     1     2     3     4     5     6     7     8     9  


You are about to use or modify Oracle Applications product tables

in your ORACLE database 'TEST ' <ajw... this is right... and it is what
TWO_TASK evaluates to... >

using ORACLE executables in '/test02vg/testora/8.0.6 '. <this is wrong and
points to where bin/f60gen is located >

Is this the correct database [Yes] ? no <right sid, wrong executables >

****************** see below for tnsping results and TWO TASK results...
******************

[TEST] > echo $TWO_TASK

TEST

[TEST] > tnsping TEST

TNS Ping Utility for IBM/AIX RISC System/6000: Version 8.0.6.3.0 -
Production on

29-MAR-2004 10:49:47

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=tcp)(HOST=#####)(PORT=####))

OK (540 msec)

[TEST] >



April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
@ >-- >-- >--
"Few people really enjoy the simple pleasure of flying a kite "
Adam Wells age 11
"Imagination is the highest kite one can fly. "
Lauren Bacall

-- --Original Message-- --
From: Tanel P?der [mailto:tanel.poder.003@(protected)]
Sent: Monday, March 29, 2004 10:45 AM
To: oracle-l@(protected)
Subject: Re: 11i Forms Compilation on aix


You have to use the application oracle_home for adadmin. You have to source
the APPSORA.env file, that should set the TWO_TASK parameter in your shell
(or LOCAL parameter in windows).

Try to check whether two_taks is correctly set, then check whether you can
tnsping this alias, then whether you can access it with sqlplus. Alos,
adamin under $APPL_TOP/admin/ <inst_id >/log should give you the exect error
message.

Tanel.


-- -- Original Message -- --
From: April Wells <mailto:AWells@(protected) >
To: 'oracle-l@(protected) ' <mailto: 'oracle-l@(protected) ' >
Sent: Monday, March 29, 2004 7:13 PM
Subject: 11i Forms Compilation on aix


Okay guys, what am I missing?

We are migrating from a multi node installation on W2K middle tier and CM
tier to a single node installation on AIX. I have 11.5.8 installed and the
database migrated to 9.2.0.3... BUT

I can 't get forms to regenerate. If I use the application Oracle_home, it
finds the forms60 stuff, but adadmin can 't log into the database, if I set
it to the database 's oracle_home, I can run adadmin, but the worker logs are
bitching that they can 't find f60gen in $ORACLE_HOME/bin (well, duh... it
isn 't in the database 's oracle_home it is in the apps oracle_home.

We have had 2 itars open since Thursday and Friday (one each) and no one can
give me an answer.

I KNOW this is done, what am I missing?

ajw

April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
@ >-- >-- >--
"Few people really enjoy the simple pleasure of flying a kite "
Adam Wells age 11
"Imagination is the highest kite one can fly. "
Lauren Bacall


The information contained in this communication, including attachments, is
strictly confidential and for the intended use of the addressee only; it may
also contain proprietary, price sensitive, or legally privileged
information. Notice is hereby given that any disclosure, distribution,
dissemination, use, or copying of the information by anyone other than the
intended recipient is strictly prohibited and may be illegal. If you have
received this communication in error, please notify the sender immediately
by reply e-mail, delete this communication, and destroy all copies.



Corporate Systems, Inc. has taken reasonable precautions to ensure that any
attachment to this e-mail has been swept for viruses. We specifically
disclaim all liability and will accept no responsibility for damage
sustained as a result of software viruses and advise you to carry out your
own virus checks before opening any attachment.





The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTML > <HEAD >
<META HTTP-EQUIV= "Content-Type " CONTENT= "text/html; charset=iso-8859-1 " >
<TITLE >11i Forms Compilation on aix </TITLE >

<META content= "MSHTML 5.50.4930.1700 " name=GENERATOR >
<STYLE > </STYLE >
</HEAD >
<BODY bgColor=#e0e0e0 >
<DIV >
<P > <FONT size=2 > </FONT > </P >
<P > <FONT size=2 > </FONT > </P >
<P > <FONT size=2 > </FONT > </P >
<P > <FONT size=2 >You are about to use or modify Oracle Applications product
tables </FONT > </P >
<P > <FONT size=2 >in your ORACLE database 'TEST ' <SPAN
class=883585016-29032004 >  <ajw... this is right... and it is what
TWO_TASK evaluates to...> </SPAN >  </FONT > </P >
<P > <FONT size=2 >using ORACLE executables in
'/test02vg/testora/8.0.6 '.  <SPAN class=883585016-29032004 > <this is
wrong and points to where <FONT size=3 >bin/f60gen is
located> </FONT > </SPAN > </FONT > </P >
<P > <FONT size=2 > </FONT > </P >
<P > <FONT size=2 >Is this the correct database [Yes] ? no  <SPAN
class=883585016-29032004 ><right sid, wrong executables> </SPAN > </FONT > </P >
<P > <SPAN class=883585016-29032004 > <FONT size=2 >****************** see below for
tnsping results and TWO TASK results... ****************** </FONT > </SPAN > </P >
<P > <FONT size=2 >[TEST] > echo $TWO_TASK </FONT > </P >
<P > <FONT size=2 >TEST </FONT > </P >
<P > <FONT size=2 >[TEST] > tnsping TEST </FONT > </P >
<P > <FONT size=2 > </FONT > </P >
<P > <FONT size=2 >TNS Ping Utility for IBM/AIX RISC System/6000: Version 8.0.6.3.0
- Production on </FONT > </P >
<P > <FONT size=2 >29-MAR-2004 10:49:47 </FONT > </P >
<P > <FONT size=2 > </FONT > </P >
<P > <FONT size=2 >(c) Copyright 1997 Oracle Corporation. All rights reserved.
</FONT > </P >
<P > <FONT size=2 > </FONT > </P >
<P > <FONT size=2 >Attempting to contact (ADDRESS=(PROTOCOL=tcp)(HOST= <SPAN
class=883585016-29032004 >##### </SPAN >)(PORT= <SPAN
class=883585016-29032004 >#### </SPAN >)) </FONT > </P >
<P > <FONT size=2 >OK (540 msec) </FONT > </P >
<P > <FONT size=2 >[TEST] > </FONT > </P > </DIV >
<DIV >  </DIV >
<P > <FONT face= "Comic Sans MS " size=2 >April Wells </FONT > <BR > <FONT
face= "Comic Sans MS " size=2 >Oracle DBA/Oracle Apps DBA </FONT > <BR > <FONT
face= "Comic Sans MS " size=2 >Corporate Systems </FONT > <BR > <FONT
face= "Comic Sans MS " size=2 >Amarillo Texas </FONT > <BR > <FONT
face= "Times New Roman " > </FONT >  <FONT face= "Comic Sans MS "
size=2 >@>-->-->-- </FONT > <BR > <FONT face= "Comic Sans MS " size=2 > "Few
people really enjoy the simple pleasure of flying a kite " </FONT > <BR > <FONT
face= "Comic Sans MS " size=2 >Adam Wells age 11 </FONT > <BR > <FONT
face= "Comic Sans MS " size=2 > "Imagination is the highest kite one can
fly. " </FONT > <BR > <FONT face= "Comic Sans MS " size=2 >Lauren Bacall </FONT > </P >
<BLOCKQUOTE dir=ltr style= "MARGIN-RIGHT: 0px " >
<DIV class=OutlookMessageHeader dir=ltr align=left > <FONT face=Tahoma
size=2 >-- --Original Message-- -- <BR > <B >From: </B > Tanel P?der
[mailto:tanel.poder.003@(protected)] <BR > <B >Sent: </B > Monday, March 29, 2004 10:45
AM <BR > <B >To: </B > oracle-l@(protected) <BR > <B >Subject: </B > Re: 11i Forms
Compilation on aix <BR > <BR > </FONT > </DIV >
<DIV > <FONT face=Arial size=2 >You have to use the application oracle_home for
adadmin. You have to source the APPSORA.env file, that should set the TWO_TASK
parameter in your shell (or LOCAL parameter in windows). </FONT > </DIV >
<DIV > <FONT face=Arial size=2 > </FONT >  </DIV >
<DIV > <FONT face=Arial size=2 >Try to check whether two_taks is correctly set,
then check whether you can tnsping this alias, then whether you can access it
with sqlplus. Alos, adamin under $APPL_TOP/admin/<inst_id>/log should
give you the exect error message. </FONT > </DIV >
<DIV > <FONT face=Arial size=2 > </FONT >  </DIV >
<DIV > <FONT face=Arial size=2 >Tanel. </FONT > </DIV >
<DIV > <FONT face=Arial size=2 > </FONT >  </DIV >
<BLOCKQUOTE
style= "PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px " >
<DIV style= "FONT: 10pt arial " >-- -- Original Message -- -- </DIV >
<DIV
style= "BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black " > <B >From: </B >
<A title=AWells@(protected) href= "mailto:AWells@(protected) " >April Wells </A >
</DIV >
<DIV style= "FONT: 10pt arial " > <B >To: </B > <A title=oracle-l@(protected)
href= "mailto: 'oracle-l@(protected) ' " > 'oracle-l@(protected) ' </A > </DIV >
<DIV style= "FONT: 10pt arial " > <B >Sent: </B > Monday, March 29, 2004 7:13
PM </DIV >
<DIV style= "FONT: 10pt arial " > <B >Subject: </B > 11i Forms Compilation on
aix </DIV >
<DIV > <BR > </DIV >
<P > <FONT size=2 >Okay guys, what am I missing? </FONT > </P >
<P > <FONT size=2 >We are migrating from a multi node installation on W2K
middle tier and CM tier to a single node installation on AIX.  I have
11.5.8 installed and the database migrated to 9.2.0.3... BUT </FONT > </P >
<P > <FONT size=2 >I can 't get forms to regenerate.  If I use the
application Oracle_home, it finds the forms60 stuff, but adadmin can 't log
into the database, if I set it to the database 's oracle_home, I can run
adadmin, but the worker logs are bitching that they can 't find f60gen in
$ORACLE_HOME/bin (well, duh... it isn 't in the database 's oracle_home it is
in the apps oracle_home.  </FONT > </P >
<P > <FONT size=2 >We have had 2 itars open since Thursday and Friday (one
each) and no one can give me an answer. </FONT > </P >
<P > <FONT size=2 >I KNOW this is done, what am I missing? </FONT > </P >
<P > <FONT size=2 >ajw </FONT > </P >
<P > <FONT size=2 >April Wells </FONT > <BR > <FONT size=2 >Oracle DBA/Oracle Apps
DBA </FONT > <BR > <FONT size=2 >Corporate Systems </FONT > <BR > <FONT
size=2 >Amarillo Texas </FONT > <BR > <FONT
size=2 > @>-->-->-- </FONT > <BR > <FONT size=2 > "Few people really
enjoy the simple pleasure of flying a kite " </FONT > <BR > <FONT size=2 >Adam
Wells age 11 </FONT > <BR > <FONT size=2 > "Imagination is the highest kite one
can fly. " </FONT > <BR > <FONT size=2 >Lauren Bacall </FONT > </P >
<TABLE >
<TBODY >
<TR >
<TD bgColor=#ffffff > <FONT color=#000000 > <PRE >The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
</PRE > </FONT > </TD > </TR > </TBODY > </TABLE > </BLOCKQUOTE > </BLOCKQUOTE > </BODY > </HTML >

<table > <tr > <td bgcolor=#ffffff > <font color=#000000 > <pre >The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
</pre > </font > </td > </tr > </table >