Posts from the ‘Uncategorized’ Category

SIEBEL Changing sadmin password difficulties

This post contents may helpful for whom a changing sadmin password through database server. But this post totally what I face while during changing the password.

First Unfortunely browser showing this below error ““The server you are accessing is either busy or experiencing difficulties. Please close the web browser, start a new one and try logging in again.”

I went to the server and delete the *.shm and osdf file and then I restarted the siebel and gateway services, But it still shows Local process is not running and later I realized the *.shm files also not created.

I checked in my database sadmin status, It shows the password expired, so I just changed the password through sqlpromt and then I executed the both services, but still siebel services not running.

So I checked in my Namesrvr.log in gateway server, It showing the below error

[siebel@siebelgw log]$ vi NameSrvr.log
2021 2012-11-06 20:36:19 0000-00-00 00:00:00 +0300 00000000 001 003f 0001 09 GtwyNS 5870 1439066880 /u02/acegtw/gtwysrvr/log/NameSrvr.log 8.1.1.5 [21229] ENU
DBCLog DBCLogError 1 00000002509916ee:0 2012-11-06 20:36:19 523 80
GenericLog GenericError 1 00000002509916ee:0 2012-11-06 20:36:19 (secmgr.cpp (2679) err=4597538 sys=0) SBL-SEC-10018: 523 80
GenericLog GenericError 1 00000002509916ee:0 2012-11-06 20:36:19 (secmgr.cpp (2735) err=4597527 sys=0) SBL-SEC-10007: The password you have entered is not correct. Please enter your password again.
GenericLog GenericError 1 00000002509916ee:0 2012-11-06 20:36:19 (client.cpp (313) err=4597527 sys=0) SBL-SEC-10007: The password you have entered is not correct. Please enter your password again.

And later only I realized the sadmin changing password procedure is totally different.

changing sadmin password procedure

Okay. Now I tried to connect srvrmgr, it shows “SBL-SCM-00018: Could not open connection to Siebel Gateway configuration store”

hmmmmm

So we need to recreate svc file in siebel server.

Step 1:

Stop Siebel server

Step 2:

delete the exising siebel service. before delete, just take backup of svc file in siebel server.

siebctl -d -S siebsrvr -i "enterprisename:siebelservername"

Example: $siebctl -d -S siebsrvr -i "ace:siebserver01"

Step 3:

Restart the machine

Step 4:

Recreate siebel service :

siebctl -r "$Siebsrvr" -S siebsrvr -i enterprisename:siebelservername  -a -g "-g siebel gateway name:port -e enterprisename -s siebel server name -u sadmin"  -e newpassword -L ENU

siebctl -r "/u03/aceapp/siebsrvr" -S siebsrvr -i ACE:siebsrvr01 -a -g "-g siebelgw:2320 -e ACE -s siebsrvr01 -u sadmin" -e sadmin -L ENU

Step 5:

Restart the machine

Step 6:

Go to the gateway server, stop gateway service

stop_ns

Move some siebns.dat.001 like files to another location except siebns.dat

start_ns

Step 7:

start siebel service

start_server ALL

Now you can see *.shm file will be created.

Step 8:

Start webserver

Step 9:

Siebel application server

srvrmgr -g siebelgw -e ACE -s siebsrvr01 -u sadmin -p sadmin
Siebel Enterprise Applications Siebel Server Manager, Version 8.1.1.5 [21229] LANG_INDEPENDENT
Copyright (c) 1990-2008, Oracle. All rights reserved.

The Programs (which include both the software and documentation) contain
proprietary information; they are provided under a license agreement containing
restrictions on use and disclosure and are also protected by copyright, patent,
and other intellectual and industrial property laws. Reverse engineering,
disassembly, or decompilation of the Programs, except to the extent required to
obtain interoperability with other independently created software or as specified
by law, is prohibited.

Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of
Oracle Corporation and/or its affiliates. Other names may be trademarks
of their respective owners.

If you have received this software in error, please notify Oracle Corporation
immediately at 1.800.ORACLE1.

Type "help" for list of commands, "help <topic>" for detailed help

Connected to 1 server(s) out of a total of 1 server(s) in the enterprise

srvrmgr:siebsrvr01>

Step 10: 
very important relax :-)

SIEBEL SBL-EAI-04308: Operation ‘uploadReport’ of Web Service

When i‘m trying to upload  files from siebel application, it showing some errors in log file

ObjMgrLog Error 1 0000021950971c1a:0 2012-11-06 09:52:22 (httptransport.cpp (1631)) SBL-EAI-04117: HTTP Request error during ‘Submitting Data SendHTTP request’: ‘Status code – 500’
ObjMgrLog Error 1 0000021950971c1a:0 2012-11-06 09:52:22 (httptransport.cpp (981)) SBL-EAI-04117: HTTP Request error during ‘Submitting Data Send HTTP request’: ‘Status code – 500’
ObjMgrLog Error 1 0000021950971c1a:0 2012-11-06 09:52:22 (soapbinding.cpp (610)) SBL-EAI-04304: Unknown Part ‘:oracle.apps.xdo.webservice.exception.OperationFailedException’ for operation ‘uploadReport’ exists in SOAP message.ObjMgrBusServiceLog Error 1 0000021950971c1a:0 2012-11-06 09:52:22 (outdisp.cpp (233)) SBL-EAI-04308: Operation ‘uploadReport’ of Web Service ‘http://xmlns.oracle.com/oxp/service/v11/PublicReportService.PublicReportServiceService’ at port ‘PublicReportService_v11’ failed with the following explanation: “oracle.apps.xdo.webservice.exception.OperationFailedException: PublicReportService::executeUploadReport Failure: Due to unable to create new Report as AbsolutePath [/SiebelCRMReports/BIP ACE Renewal List/BIP ACE Renewal List.xdo] due to java.util.zip.ZipException: error in opening zip file”.

Solution :

Check your *.xlf file in your server directory path properly named as same like siebel application uploading file name.

Or check whether that particular xlf file there on the same directory.

Eid Mubarak

Wish you and your family good health and a very happy & prosperous Eid.

With all good wishes 🙂

” O Allah! Forgive me(my sins) that I have already done, and will do (in the future), and what i have done in private, and what I have done in public, and all(sins) that You know from me. ”
الله أكبر الله أكبرلااله الا الله والله أكبر الله أكبر ولله الحمد
அல்லாஹு அக்பர், அல்லாஹு அக்பர்., லாஇலாஹ இல்லல்லாஹு வல்லாஹு அக்பர், அல்லாஹு அக்பர் வலில்லாஹில் ஹம்து.

EBS Patch apply task

I would like to share you this information who willingly to apply patches in ebs environment

Step 1: Download appropriate patches

Step 2: Transfer this file to appropriate location

Step 3: change the application user permission read and write , execute of this file

Step 4: Unzip the patch file and then you should read the README.txt file before you go to apply patches because If this patch said you need to do preinstall a task , you should finish the job before you start the task.

Step 5:  stop the application service $ADMIN_SCRIPTS_HOME\adstpall.sh apps/apps

Step 6: Enable maintenance mode using adadmin

Step 7:  apply the patch using adpatch command.

It will ask where is your patch directory, please locate it.

Autopatch file : example.drv

Step 8 : After successfully applied the patch, you should disable maintenance mode using adadmin

Step 9 : Start the application service $ADMIN_SCRIPTS_HOME\adstrtal.sh apps/apps

Step 10: Finish the job and then go and take a cup of coffee 🙂

Packt 1000th Title Marketing campaign – Pre Launch press release

PRESS RELEASE

13^th September 2012

Packt Publishing reaches 1000IT titles and celebrates with an open invitation

Birmingham-based IT publisher Packt Publishing is about to publish its 1000^th title. Packt books are renowned among developers for being uniquely practical and focused.  Packt books cover highly specific tools and technologies which IT professionals might not expect to see a high quality book on.

Packt would like you to join them in celebrating this milestone with a surprise gift – to get involved you just need to have already registered, or sign up for a free Packt account before 30^th September 2012.

Packt published their first book in April 2004. One of the most prolific and fastest growing tech book publishers in the world, they now have books on everything from web development to web graphics, e-learning to e-commerce, IT architecture to games, and app development.

Packt supports many of the Open Source projects covered by its books through a project royalty donation, which has contributed over £300,000 to Open Source projects up to now. As part of the celebration Packt is allocating $30,000 to share between projects and authors in a genuinely unique way, soon to be disclosed on their website.

Dave Maclean, founder of Packt Publishing explains, “At Packt we set out 8 years ago to bring practical, up to date and easy to use technical books to the specialist tools and technologies that had been largely overlooked by IT publishers. Today, I am really proud that with our authors and partners we have been able to make useful books available on over 1000 topics and make our contribution to the development community.”

For more information about Packt, the kind of books they publish, and to sign-up for a free account before the 30th of September, 2012, please visit their website: www.PacktPub.com.

EBS Routine FDPREP cannot read the file report

While users trying to get report from EBS application, they face below issues

Routine FDPREP cannot read the file /u01/ERPPROD/apps/apps_st/appl/xxace/12.0.0/reports/US/test.rep.

Check if the file exists under correct product directory.

Check if the person who started the Concurrent Manager has read privileges on the
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 3756150.

Solution :

• Check whether that particular report file exists on the same directory.  The file extension should be *.rdf format.
• Check read write permission there for that file.
• If three tiers running in your environment,  try to bounce the application step by step like first application tier and then web tier. Because the concurrent manager process working with application tier.

Easily connect mapped network using pushd command

I would like to share this information

If you want to connect map network using command prompt in windows , you can use pushd command.

C:\Users\mazar>pushd \\10.1.xx.xxx\export

Z:\>dir
Volume in drive Z has no label.
Volume Serial Number is 3CF7-C48C

Directory of Z:\

05/14/2012 02:55 PM <DIR> .
05/14/2012 02:55 PM <DIR> ..
01/23/2012 11:43 AM 866,799 itsupport-db_2012-01-23.sql
01/29/2012 04:15 PM 1,094,435 itsupport-db_2012-01-29.sql
01/31/2012 11:57 AM 1,144,597 itsupport-db_2012-01-31.sql
02/04/2012 04:18 PM 1,267,529 itsupport-db_2012-02-04.sql
02/05/2012 03:23 PM 1,305,221 itsupport-db_2012-02-05.sql

popd command use to disconnect mapped network.

Z:\>popd

C:\Users\mazar>

More Detail :

http://www.techrepublic.com/blog/window-on-windows/use-the-pushd-popd-commands-for-quick-network-drive-mapping-in-windows-7/6144

Oracle Database 11g R2 Certification on Oracle Linux 6

Oracle Announces the Certification of the Oracle Database on Oracle Linux 6 and Red Hat Enterprise Linux 6

Please see Oracle press report from here

New Support note : How to find Oracle E business suite recommanded patches

After I read it from here, I just would like to share this information . the new support note resource avilable for Oracle Ebusiness suite guys.

2011 in review

The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog.

Here’s an excerpt:

The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 81,000 times in 2011. If it were an exhibit at the Louvre Museum, it would take about 3 days for that many people to see it.

Click here to see the complete report.