DOGANAY'S BLOG: Temmuz 2013

25 Temmuz 2013 Perşembe

Comment Out addisctl.sh R11

comment out addisctl.sh on 11i
-----------------------------

Set the AutoConfig variable s_discostatus to disabled. AutoConfig will still create the addisctl.sh, but adstrtal.sh won't run it.

1)vi $CONTEXT_FILE

2)set s_discostatus variable to disable

3)Shutdown appstier(run adstpall.sh)

4)run autonconfig(run adautocfg.sh)

5)Start appstier/run adstrtall.sh)

While appstier restarting

'addisctl.sh' will not running.

Ref:

How To Stop Autoconfig Creating Addisctl.Sh After Discoverer Upgrade (Doc ID 398835.1)

After upgrading Discoverer from version 4.1.48 to 10.1.2 per Metalink note 313418.1

Error creating new OC4J instance: create oc4j instance fails:

PROBLEM:

While running $FND_TOP/bin/txkrun.pl -script=DeployForms-c4ws for Configuring Integrated SOA Gateway

I got an error:

Error creating new OC4J instance: create oc4j instance fails:
Invalid protocol or port range. invalid jvm options:
-Xss512k -Djava.awt.headless=true
-Xjit:exclude={orac

SOLUTION:

1) Backup the below files:

$IAS_ORACLE_HOME/opmn/conf/opmn.xml
$ORA_CONFIG_HOME/10.1.3/opmn/conf/opmn.xml

2) Remove the -Xss & -Xjit entries from both opmn files mentioned below:

$IAS_ORACLE_HOME/opmn/conf/opmn.xml
$ORA_CONFIG_HOME/10.1.3/opmn/conf/opmn.xml

3) Execute the following command to deploy the changes:

$FND_TOP/bin/txkrun.pl -script=DeployForms-c4ws

Ref:

Configuring OC4J Instance Fails: Invalid Protocol or Port Range. Invalid JVM Options (Doc ID 1386470.1)

Not:
It is AIX's bug

My error log is below:

##############################################################################################################################################################

Stopping all OPMN processes.
Execute SYSTEM command : /data_appl/test_appl_05072013/apps/tech_st/10.1.3/opmn/bin/opmnctl stopall
opmnctl: stopping opmn and all managed processes...
OPMN stopped.
Removing OC4J instance if it exists: forms-c4ws
Execute SYSTEM command : /data_appl/test_appl_05072013/apps/tech_st/10.1.3/bin/removeinstance -instanceName forms-c4ws
Removing OC4J instance "forms-c4ws"...
Jul 25, 2013 11:47:08 AM oracle.security.jazn.JAZNConfig getJAZNProperties
SEVERE: JAAS: Configuration file "/data_appl/test_appl_05072013/apps/tech_st/10.1.3/j2ee/forms-c4ws/config/jazn.xml" does not exist. Check your configuration settings.
The OC4J instance "forms-c4ws" does not exist.
OC4J instance "forms-c4ws" does not exist.
Creating OC4J instance: forms-c4ws
Execute SYSTEM command : /data_appl/test_appl_05072013/apps/tech_st/10.1.3/bin/createinstance -instanceName forms-c4ws
Creating OC4J instance "forms-c4ws"...
Set OC4J administrator password for "forms-c4ws" (password text will not be displayed as it is entered):
Error creating new OC4J instance: create oc4j instance fails: Invalid protocol or port range. invalid jvm options: -Xss512k -Djava.awt.headless=true -Xjit:exclude={orac
le/sysman/emSDK/eml/util/iAS/IASLogConfig.getViewLogsURL(Ljavax/servlet/ServletContext;Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)L
java/lang/String;},exclude={oracle/security/jazn/util/OHSH.update([B)V},exclude={com/phaos/ASN1/ASN1Sequence.<init>(Ljava/io/InputStream;)V},exclude={com/phaos/crypto/D
ES.l([B[IZ)V} -Djava.security.policy=$ORACLE_HOME/j2ee/forms-c4ws/config/java2.policy -Dhttp.webdir.enable=false -Xms512M -Xmx1024M
Execute SYSTEM command : /data_appl/test_appl_05072013/apps/tech_st/10.1.3/opmn/bin/opmnctl start
opmnctl: opmn started.
Execute SYSTEM command : /data_appl/test_appl_05072013/apps/tech_st/10.1.3/opmn/bin/opmnctl startproc instancename=forms-c4ws

Errors encountered running /data_appl/test_appl_05072013/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkDeployForms-c4ws.pl

*******FATAL ERROR*******
PROGRAM : /data_appl/test_appl_05072013/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkDeployForms-c4ws.pl(/data_appl/test_appl_05072013/apps/apps_st/appl/fnd/12.0.0/bin
/txkrun.pl)
TIME : Thu Jul 25 11:47:11 2013
FUNCTION: TXK::Process::run [ Level 3 ]
MESSAGES:
Command error: <rc> = 38400, <command> = /data_appl/test_appl_05072013/apps/tech_st/10.1.3/opmn/bin/opmnctl startproc instancename=forms-c4ws

STACK TRACE
TXK::Error::abort('TXK::Error','HASH(0x20119984)') called at /data_appl/test_appl_05072013/apps/apps_st/appl/au/12.0.0/perl/TXK/Common.pm line 299
TXK::Common::doError('TXK::Process=HASH(0x213aacd0)','Command error: <rc> = 38400, <command> = /data_appl/test_appl...','undef') called at /data_appl/test_appl_
05072013/apps/apps_st/appl/au/12.0.0/perl/TXK/Common.pm line 314
TXK::Common::setError('TXK::Process=HASH(0x213aacd0)','Command error: <rc> = 38400, <command> = /data_appl/test_appl...') called at /data_appl/test_appl_0507201
3/apps/apps_st/appl/au/12.0.0/perl/TXK/Process.pm line 449
TXK::Process::run('TXK::Process=HASH(0x213aacd0)','HASH(0x213aaa00)') called at /data_appl/test_appl_05072013/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkDepl
oyForms-c4ws.pl line 1008

##################################################################################################################################################################

15 Temmuz 2013 Pazartesi

Shell Script to Send Mail via Telnet

Sometimes you need to test send mail via telnet,but it's bored after 5-6 times.So you can a script.This script send mail via telnet.This script for solaris.If you use another operating system,you have to change .profile line;otherwise you can use direct.

Script takes two parameter.

MAIL=first parameter(mail adress)

STRING=second parameter(message body)

example;

ksh send_mail.ksh necati@natica.com.tr "Hello"

###############################send_mail.ksh########################################
#!/bin/ksh
. /export/home/oracle/.profile
MAIL=$1
STRING=$2

{
echo "helo"
sleep 1
echo "mail from:sender@doganay.com"
sleep 1
echo "rcpt to:$MAIL"
sleep 10
echo "data"
sleep 1
echo "subject:Mail Test"
sleep 1
echo "from: receiver@doganay.com"
sleep 1
echo "to: $MAIL"
sleep 2
echo data
sleep 2
echo subject: Mail Test
echo
echo
echo "$STRING"
sleep 5
echo .
sleep 5
echo "quit"
} | telnet 10.10.67.102 25
#################################################################################
10.10.67.102=SMTP server ip
25=SMTP server port

OPMN Starting Process Time Out

Problem:

Time out while waiting for a managed process to start

Solution:

Make timeout change in $IAS_ORACLE_HOME/opmn/conf/opmn.xml file

<start timeout="1200"/>

Reload opmn services

$IAS_ORACLE_HOME/opmn/bin/opmnctl reload

OGG-00717-Found unsupported in-memory undo record in sequence ... Minimum supplemental log

Problem:

ERROR OGG-00717 Found unsupported in-memory undo record in sequence 3, at RBA 1089040, with SCN 0.1030748 (1030748) ... Minimum supplemental log
ging must be enabled to prevent data loss.

I got an error while starting extract ext1;it abended.Viewed report then I saw;

Solution:

1. Make sure supplemental logging is enabled properly

SQL>SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
---------
YES

If it is not enabled, use the following commands to enable it.

SQL>ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
SQL>ALTER SYSTEM SWITCH LOGFILE;

2. Alter the extract to a position when the supplemental logging has been enabled.

GGSCI>alter extract, ext1 begin now

3)Then start extract ext1.

Reference:OGG Error "OGG-00717: Found Unsupported In-Memory Undo Record in ..." When Starting, Extract Abends [ID 1362136.1]

RMAN-06043 TAG option not supported for archive log copies

Problem:

Error » RMAN-06043
Detailed information about the Oracle error RMAN-06043:
DESCRIPTION
TAG option not supported for archive log copies

Solution:

Remove the TAG operand and re-enter the command

Reference : Metalink Note 576587.1

9 Temmuz 2013 Salı

Error In Writing to File $ORACLE_HOME/jdk/bin/libiverel23.so

Problem:

Error in writing to file
'/data02/data_appl/apps/tech_st/10.1.3/jdk/bin/libiverel23.so'.
/data02/data_appl/apps/tech_st/10.1.3/jdk/bin/libiverel23.so(Cannot open or remove a file containing a running program.)

Solution:

While upgrading oracle ebs application server upgrade(from 10.1.3.0 to 10.1.3.5.0) I got this error above.My file operating system is IBM AIX

I checked these are below:

1)Any running process?

ps -ef | grep $ORACLE_HOME

2)run /usr/sbin/slibclean as a root

3)All of two are normal.There is no process and I run slibclean.But problem isn't resolve

Finally I tried this;

mv $ORACLE_HOME/lib32/libiverel23.so $ORACLE_HOME/lib32/libnjssl10.so.ba

mv $ORACLE_HOME/lib32/libnjssl10.so.ba $ORACLE_HOME/lib32/libiverel23.so

And installation finished successfully:))

Note:This problem is AIX's bug.