Skip to content

Posts from the ‘Uncategorized’ Category

Clear memory cache in linux

The below command will remove cache memory

 sudo sh -c “sync; echo 3 > /proc/sys/vm/drop_caches” 

 

 

 

How do i delete all files older than six days in linux

Use this command

[applprod@ebs ~]$ find access_log*  -mtime +6 | xargs rm -rf

 

 

EBS list of username with responsibility

select d.full_name,a.USER_NAME USER_ID, a.EMPLOYEE_ID, c.RESPONSIBILITY_NAME
from apps.FND_USER a, apps.FND_USER_RESP_GROUPS b, apps.FND_RESPONSIBILITY_VL c, apps. per_all_people_f d
where a.USER_ID=b.USER_ID and b.RESPONSIBILITY_ID=c.RESPONSIBILITY_ID and a.employee_id=d.person_id and sysdate between d.effective_start_date and d.effective_end_Date group by a.USER_NAME,a.EMPLOYEE_ID,c.RESPONSIBILITY_NAME,d.full_name order by a.USER_NAME

delete responsibility for user EBS

If you want to delete responsibility for user, you can’t delete the responsibility filed in user define forms.

See this forum thread for more detail

You can able to disable the responsibility using end date field.

System Administrator –> Security –> User –> Define — > query the user (F11, Ctrl+F11)

ebs

OBIEE 11.1.1.7.0

OBIEE 11.1.1.7.0 was released earlier this week . So this is the time to upgrade your OBIEE to higher version.

Refer this site for upgrade

Cannot open connection to FALSE The Synch Manager component on the server is most likely unavailable.

When I’m trying to configure local database extract for developers, After login of user, it shows below error

Unable to connect server

Cannot open connection to FALSE The Synch Manager component on the server is most likely unavailable.

I checked that appropriate component running or not, but its running

srvrmgr:siebsrvr01> list comp SynchMgr

SV_NAME CC_ALIAS CC_NAME CT_ALIAS CG_ALIAS CC_RUNMODE CP_DISP_RUN_STATE CP_STARTMODE CP_NUM_RUN_TASKS CP_MAX_TASKS CP_ACTV_MTS_PROCS CP_MAX_MTS_PROCS CP_START_TIME CP_END_TIME CC_INCARN_NO CC_DESC_TEXT
———- ——– ———————– ——– ——– ———– —————– ———— —————- ———— —————– —————- ——————- ———– ———— ————
siebsrvr01 SynchMgr Synchronization Manager SynchMgr Remote Interactive Online Auto 0 100 1 1 2013-03-27 15:07:24

1 row returned.

The problem is we need to edit the siebel tools tools.cfg file and changed the  DockConnString parameter of local datasource

DockConnString = servername of siebel server running

oracle.as.provisioning.weblogic.ASDomain._addTemplate(ASDomain.java:4224)

While I’m trying to configure Oracle OBIEE 11.1.1.6.0, I got a deployment base setup failed. So often I check with installation log files it shows below error

oracle.as.provisioning.exception.ASProvWorkflowException: Problem invoking WLST – Traceback (innermost last):
File “/tmp/tmp1364695495957.py”, line 15, in ?
File “/tmp/WLSTOfflineIni6851419804217349118.py”, line 89, in addTemplate
Oracle BI SYSMANOracle BI JDBC
at com.oracle.cie.domain.script.jython.CommandExceptionHandler.handleException(CommandExceptionHandler.java:51)
at com.oracle.cie.domain.script.jython.WLScriptContext.handleException(WLScriptContext.java:1538)
at com.oracle.cie.domain.script.jython.WLScriptContext.addTemplate(WLScriptContext.java:420)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)

com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.ScriptException: com.oracle.cie.domain.template.dependency.SelectionConflictException: The following prerequisites were found to be missing:
Oracle BI SYSMANOracle BI JDBC
at oracle.as.provisioning.weblogic.ASDomain._addTemplate(ASDomain.java:4224)
at oracle.as.provisioning.weblogic.ASDomain.addTemplate(ASDomain.java:4020)
at oracle.as.provisioning.engine.WorkFlowExecutor._addTemplates(WorkFlowExecutor.java:1396)
at oracle.as.provisioning.engine.WorkFlowExecutor.executeWLSWorkFlow(WorkFlowExecutor.java:473)
at oracle.as.provisioning.engine.Config.executeConfigWorkflow_WLS(Config.java:866)
at oracle.as.install.bi.biconfig.standard.StandardWorkFlowExecutor.executeHelper(StandardWorkFlowExecutor.java:31)
at oracle.as.install.bi.biconfig.standard.ConfigTemplateTask.doExecute(ConfigTemplateTask.java:34)
at oracle.as.install.bi.biconfig.standard.AbstractProvisioningTask.execute(AbstractProvisioningTask.java:70)
at oracle.as.install.bi.biconfig.standard.StandardProvisionTaskList.execute(StandardProvisionTaskList.java:61)
at oracle.as.install.bi.biconfig.BIConfigMain.doExecute(BIConfigMain.java:113)
at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:371)
at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:88)
at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:105)
at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15)
at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:64)
at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:160)
at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:81)
at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:86)
at java.lang.Thread.run(Thread.java:662)

 

I got more confused about this error, Why I got this error even all prerequisites setup completed successfully. Finally I realized this issue may be happen due to incomplete Software downloaded zip file. Because Sometimes thesoftware files are downloaded done with partially.So I try to find out chksum file value of  OBIEE downloaded five files using cksum and compare this output value with related Oracle software downloaded site, Yes Now I got  One software file was not completely downloaded. So Again I downloaded that appropriate file and then I can able to configure without failure message.

 

Oracle OBIEE 11.1.1.6.0 step by step installation guide on linux

Please find the attached document about Oracle OBIEE 11.1.1.6.0 step by step installation guide on linux

 

Oracle OBIEE 11 installation guide

 

Unable to find node in database while doing database extract in siebel

I am facing this below issues while I’m trying to configure database extract for multiple users.

GenericLog      GenericError    1       0000051651517293:0      2013-03-30 11:19:58     Unable to find node in database^M

GenericLog      GenericError    1       0000051651517293:0      2013-03-30 11:19:58     Message: GEN-13,

the problem comes because I’m not register mobile client for this siebel application. first register mobile client using following method.

Step 1:

Create users in database and give to sse_role privilege to theses users

Step 2:

create new employee from Administration- User as same user id

Step 3:

Administration – Siebel Remote tab–> Mobile Client

bip_83

Here Mobile Client — User id

User Id — User Id

Last Name :  M

First Name : Balaji

No need other value for this row and save this mobile client

Step 4:

Administration — Server Management — jobs

create new tab– > Database Extract  and Requested Server is your siebel server name

bottom of the tab –> create new parameter –> Client Name — list of users

Client Database encryption method  — None

Encrypt client Db password — False

Now submit the job and then the new job will be created successfully

Generate New Database job remain in queue

When you’re trying to create generate new database component for siebel, this job remain in queue long time. Here Check the apporpriate siebel component are enabled or not.

Check remote server component enabled or not through server manager

srvrmgr:siebsrvr01> list compgrp

If it’s not enable, enable the remote component.

srvrmgr:siebsrvr01>enable compgrp remote

Restart the siebel server

srvrmgr:siebsrvr01> list compgrp Remote

CG_NAME CG_ALIAS CG_DESC_TEXT CG_DISP_ENABLE_ST CG_NUM_COMPONENTS SV_NAME CA_RUN_STATE
————- ——– ———————— —————– —————– ———- ————
Siebel Remote Remote Siebel Remote Components Enabled 8 siebsrvr01 Running

1 row returned.

srvrmgr:siebsrvr01> list comp DbXtract

SV_NAME CC_ALIAS CC_NAME CT_ALIAS CG_ALIAS CC_RUNMODE CP_DISP_RUN_STATE CP_STARTMODE CP_NUM_RUN_TASKS CP_MAX_TASKS CP_ACTV_MTS_PROCS CP_MAX_MTS_PROCS CP_START_TIME CP_END_TIME CC_INCARN_NO CC_DESC_TEXT
———- ——– —————- ——– ——– ———- —————– ———— —————- ———— —————– —————- ——————- ———– ———— ————
siebsrvr01 DbXtract Database Extract DbXtract Remote Batch Online Auto 0 10 2013-03-27 15:07:24

1 row returned.

srvrmgr:siebsrvr01>

Follow

Get every new post delivered to your Inbox.

Join 139 other followers