Killing hung database process..

Today We faced an issue, where an database process is kicking off again and again even we killed that in Database level.I identified that process was running as part of job in database  (As the process corresponds to background process – j000 ) and followed the below procedure to kill that session.

I identified the job as ‘203′ ,SID as ‘80′  and username as ‘APEX_PUBLIC_USER’ etc., from dba_jobs_running using below query.

select jr.job,s.username,s.sid,s.lockwait,s.logon_time
from dba_jobs_running jr,v$session s
where jr.sid = s.sid
order by jr.job;

I used below query to broke the job before killing the session.

SQL> execute dbms_job.broken(‘203′,TRUE);
   begin dbms_job.broken
   *
ORA-23421; job number 572400 is not a job in the job queue
ORA-06512: at “SYS.DBMS_SYS_ERROR” line 86
ORA-06512: at “SYS.DBMS_IJOB” line 514
ORA-06512: at “SYSDBMS_JOB”, line 240
ORA-06512: at line 1 

I understood , I need to be the user who initiated the job to broke the job (or) have to use dbms_ijob package to broke the job as DBA.

BEGIN SYS.DBMS_IJOB.BROKEN(‘203′,TRUE); END;
  2  /

PL/SQL procedure successfully completed.

and used below command to kill the session and ensured no process is further kicked off..

alter system kill session ‘SID,SERIAL#’;

Helpful Metalink Docs :

How to kill a hung automated materialized view refresh job : 341842.1
ORA-23421 OR ORA-03421 TRYING TO ALTER A JOB              : 1029977.6

 

 

Generate Triggers in Siebel

 

General procedure for generating triggers is  first removing triggers and then creating the triggers.
To acheive this, we will submit the job Generate Triggers twice with different parameters.

First for REMOVING triggers and next for CREATING triggers.

For Removing triggers we will give comp-specific parameter 
REMOVE = TRUE 
Trigger File Name = Trigger_remove.sql

For Creating triggers we will give comp-specific parameter    
REMOVE = FALSE
Trigger File Name = Trigger_create.sql

Navigation:

Sitemap > Administration – Server management > Jobs

Create new job > Generate Triggers

From JOB PARAMETERS applet Select NEW and give the following component-specific parameters

EXEC                       ALL
MODE                     ALL
Privileged User       Table_owner (siebel_usr)
Privileged Pwd        Table_owner_pwd    (Siebel_usr_pwd)
Remove                  TRUE / False
Trigger File Name   Trigger_remove.sql / Trigger_create.sql (These sql files will be create in siebsrvr root directory and needs to executed manually if EXEC parameter was given as FALSE while executing jobs).

More info about triggers can be found at http://download.oracle.com/docs/cd/B40099_02/books/BPFWorkflow/BPFWorkflow_Admin_Policies4.html

Enabling EM in Oracle iAS 10.1.3

As part of Oracle Health care transactional base (HTB v6)  installation with R12.0.4, I installed oracle AS10.1.3.1 to deploy HTB. After installing 10.1.3.1 Oracle Application server (SOA suite) installation I was not able to access asconsole from the front end.

To access asconsole from the front end,I modified the following files with respective details.

cd $ORACLE_HOME/j2ee/home/config

Take backup of files server.xml & default-web-site.xml

find the lines, in server.xml

<application name=”ascontrol” path=”../../home/applications/ascontrol.ear” parent=”system” start=”false” /> and modified to look like

<application name=”ascontrol” path=”../../home/applications/ascontrol.ear” parent=”system” start=”true” />

find the lines in default-web-site.xml

<web-app application=”ascontrol” name=”ascontrol” load-on-startup=”true” root=”/em” ohs-routing=”false” /> and modified to look like

<web-app application=”ascontrol” name=”ascontrol” load-on-startup=”true” root=”/em” ohs-routing=”true” />

Restart all opmn services and access the url

http://hostname:port/em and able to logged in with user/pwd oc4jadmin/pwd_provided_while_installation.

Installation of Siebel 8.0 on Linux

I am new to siebel installation,After struggling a lot to complete Installation of siebel 8.0 on Linux ,Here I would like to make a note of the points for remembrance.

1.Install Oracle database 10.2.0.1 and upgrade to 10.2.0.2

Before Installing Siebel components,

• Create an Installation Image for the platform for Installing siebel and related components.
• Install database client for multi node(DB+Siebel) installation.
• check write access to /var/adm/siebel directory.
• Uninstall all SIEBEL environment variables before invoking installer, I used the following command to unset SIEBEL related environments at any time.
  unset `env | grep SIEBEL |awk -F \= '{print $1}'`
• Host name should be less that 15 characters.
• Set environament variables related to ORACLE such as ORACLE_HOME,LD_LIBRARY_PATH,PATH and JAVA such as JAVA_HOME.

3.Install Sibel Gateway server
4.configuring gateway server

• we can invoke configuration wizard at any time for a specific siebel component using the executable ssincfgw from bin directory after executing the environament cfgenv.sh.

4.configure an enterprise in gateway server

5.configure profile for Sibel web server extension(SWSE)

Before Installing and configuring siebel server need to perform the following tasks,

• Creating an siebel_data and siebel_index tablespaces
• Run the grantusr.sql script available under $SIEBEL_INSTALL_ROOT/dbsrvr/oracle to create siebel,sadmin and ldapuser.
• Create an ANONYMOUS user, we can use this user while configuring SWSE.

6.Install Sibel server

• Before invoking configuration script for siebel server we need to check ODBC connection to the database as below.
  odbcsql /u database_account_name /p password /s ODBC_DSN where ODBC_DSN could find in $SIEBEL_ROOT/sys/.odbc.ini file

7.configure Sibel server
8.configure Database for Siebel

• Now configuration wizard had created a file master_install.ucf in $SIEBEL_ROOT/bin.
• Run this as $SIEBEL_ROOT/siebsrvr/bin/srvrupgwiz /m master_install.ucf to create seeded siebel data

9.Install siebel web server extension
10.Install Oracle HTTP Server on the same port which was given in creationg SWSE Profile.
11.Install Net Chart server
12.Install Actuate reports server

• Note that Actuate reports server is not certified on LINUX,check latest certification for present status.

OOPS…!! …My system Infected by Rogue ‘AntiSpyCheck’

A couple of days back, my system started crashing frequently with BSOD(Blue Screen Of Death) screen when i tried opening any application or google web page. I observed  an icon like ‘windows security center’ in my system tray and when i opened it is redirecting to the website http://www.antispycheck.com.Even in safe mode this icon is visible.As it is malware both antivirus and spyware removal tools unable to found this culprit. when I tried to delete temp files and recent documents I’am facing BSOD screen.Upon googling found two excellent links where I found step-by-step removal instructions.
http://forums.pcpitstop.com/index.php?showtopic=157774 and

http://forum.securitycadets.com/index.php?showtopic=7152

using these links successfully removed malware and performed complete antivirus scan and created a system restore point.
Thanks to Juliet and Andy for their help in providing instructions,and special thanks to malwarebytes team too.

 

LOV’s are showing Blank pages

Today in an R12 (12.0.4) instance, In any responsibility when i selected an LOV itz popping out in new window .and showing blank page.In the backend in application log located at $INST_TOP//logs/ora/10.1.3/j2ee/oacore/oacore_default_group_1, the following error is repeating when ever I selected LOV button.

08/04/02 18:44:57.612 html: chain failed
javax.servlet.ServletException: oracle.classloader.util.AnnotatedClassNotFoundException:
          Missing class: _cabo._jsps._a
        Dependent class: oracle.jsp.runtimev2.JspPageInfo
                 Loader: oc4j:10.1.3
            Code-Source: /u02/r12incub/apps/tech_st/10.1.3/j2ee/home/lib/ojsp.jar
          Configuration: <code-source> in META-INF/boot.xml in /u02/r12incub/apps/tech_st/10.1.3/j2ee/home/oc4j.jar
This load was initiated at oacore.web.html.jsp22705162:0.0.0 using the loadClass() method.
The missing class is not available from any code-source or loader in the system.
        at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:387)
        at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
        at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
        at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
        at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
        at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
        at java.lang.Thread.run(Thread.java:595)
08/04/02 18:55:36.553 html: 10.1.3.0.0 Stopped

I found the bug:5532796 in metalink for similar type of issue and the issue was resolved after compiling all jsp’s using ojspcompile.pl,and bounced the apps tier.

$FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p20

Active users request failed with REP-0004,REP-0069,REP-50002

Today I installed Oracle applications Release 12.0.4, After Installation did a bounce of complete environament.during sanity check active users concurrent request failed with the followong error
REP-0004: Warning: Unable to open user preference file.
REP-0069: Internal error
REP-50002: Server is shutting down

Debug trace file located at $APPLTMP having the following error.

[2008/4/6 4:22:3:46] Exception 56027 (): Reject engine callback due to security violation
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
        at oracle.reports.utility.Utility.newRWException(Utility.java:758)
        at oracle.reports.server.EngineManager.registerEngine(EngineManager.java:1271)
        at oracle.reports.server.EngineCommImpl.registerEngine(EngineCommImpl.java:98)
        at oracle.reports.engine.RWEngine.init(RWEngine.java:343)
        at oracle.reports.engine.RWEngine.run(RWEngine.java:141)
        at java.lang.Thread.run(Thread.java:534)
[2008/4/6 4:22:3:47] Exception 50125 (oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
        at oracle.reports.utility.Utility.newRWException(Utility.java:758)
        at oracle.reports.server.EngineManager.registerEngine(EngineManager.java:1271)
        at oracle.reports.server.EngineCommImpl.registerEngine(EngineCommImpl.java:98)
        at oracle.reports.engine.RWEngine.init(RWEngine.java:343)
        at oracle.reports.engine.RWEngine.run(RWEngine.java:141)
        at java.lang.Thread.run(Thread.java:534)
): Internal error oracle.reports.RWException: IDL:oracle/reports/RWException:1.0

From metalink I found a bug:6371924 which suggests to apply the patch 6116405 on 10.1.2 Oracle Home using OPatch. as my report server version is 10.1.2.2.0 ( rwrun help=yes | grep Release),applied the corresponding patch.My issue got resolved.

Restrict users to use ‘conn /as sysdba’ from OS Level

To avoid a user to connecting to Database using connect /as sysdba after they log-in to OS,We can follow two methods.
1.In sqlnet.ora file modify the following line to
SQLNET.AUTHENTICATION_SERVICES=(NONE)
2.remove dba group to the user who is logging in to the system.
Note that orapwd file is used to authenticate users over the network only.users who already logged in to the system can’t be restricted to connect ‘/as sysdba’
I found Some useful discussion regarding this Here

OpenID

To day it happened for me to visit http://wiki.oracle.com, there while signigup apart of UserName and Password saw an icon use OpenID,there I started debugging what this OpenID is.It redirected me to http://openid.net where I found some basic information on what excatly it is.As almost all sites require you to log-in,you need to create a saperate login where ever it is required.after some time you will forget the login details for some sites which you won’t use for a period of time.OpenID can be used as your identity on InterNet for accessing multiple sites.Just create an identity for your self from a list of service providers you find here .I get an identity from VerisignLabs which gave an url after registration.

Next question is How to Use this Identity, What ever the web site asks you to login just look for OpenID can be used to authenticate your self. If so just give your identification URL there,you will be redirected to you service provider. if you already having account with that website,yo will be authenticated and you can get in to the site. otherwise you will be asked to register your self by providing some basic info ,with that info that website will be registered with your service provider so that from next time you will be just giving your identity URL and get in to that site.One more advantage is you can manage all your sites you registered at one stop i.e., @your service provider(verisign labs in my case) for deleting that site from your list and all.

For me I would like to map this OpenID with Oracle Single Sign On where OpenID with SSO mail address,OID with service provider(VeriSign) ,like identity management we are managing our sites with our provider.Good news is that Google,Yahoo,IBM and AOL agreed to authenticate OpenID for some of their tasks(If i understand correctly..!!).Any way i like this feature…

Refresh Collection Snapshots request with Inactive Nomanager

I got a request from an user saying the status of the request is Inactive-No manager,I checked the concurrent manager logs and all,and found every thing is working fine.Then I checked the diagnostics of the particular request..there It’s saying the Concurrent manager for this request is currently disabled.I am not sure which CM will pick up the request,So I traced out the parent request for this ,and found a standalone manager(MRP Manager) has been configured for this request using the Doc :275428.1.and with discussion with some of functional persons working on ASCP,came to know that If standerd manager has been configured for collections then planning manager should also be started.

Planning manager can’t be seen in concurrent > manager > administer,This manager will be running as a concurrent request and can be found by searching a request for Planning% .If this manager has been setup,we can start this manager from Advanced Supply Chain Responsibility(material planner) > setup > planning manager > start.This will start planning manager.

Coming back to my issue,I found MRP manager is running and Planning manager has not been started .Informed the user that a standalone manager has been setup and planning manager has not been setup.He didn’t come back yet.hope it is the issue…

Planning Manager FAQ : 114541.1
How To Check Programatically If The Planning Manager Is Active : 1070745.6