DBA

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

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>

enable event log level for siebel component

In some situations, If we are getting error from siebel application, We can’t able to find out what exactly happen from log file. So in this case we should increase the log level for certain components. then We run the report again, If  once error raised, you should read the log file from server, Here It notified what exact happen for this components.

We can able to increase the log level using two methods.

1.Server Manager

2.Siebel application

Server Manager

connect the server manager

srvrmgr -g siebeldev:2320 -e ACEDEVCRM81 -s siebsrvr01 -u sadmin -p password

srvrmgr:siebsrvr01> change evtloglvl % = 5 for server siebsrvr01 component XMLPReportserver
Command completed successfully.

For revert back

srvrmgr:siebsrvr01> change evtloglvl % = 1 for server siebsrvr01 component XMLPReportserver
Command completed successfully.

Siebel Application :

Site Map — Administration- Server Configuration — Servers

Components — XMLPReportserver

specified driver could not be loaded due to system error seor823.dll

I had installed siebel tools on my windows 7 64bit machine and then when i try to open siebel tools application, I am getting below error

“An internal error has occurred within the authentication subsystem for the Siebel application”

So I just checked in my odbc driver, its seem like okay. but the issues was we need to add the odbc datasource name in odbc32bit.

So I have to execute 32bit odbc ” c:\Windows\SysWOW64\odbcad32.exe”

I added the datasource name and just test it test connection, it shows error

“specified driver could not be loaded due to system error seor823.dll”

I had installed 64bit client also on my machine before so that I can’t able to connect 64bit using by odbc32bit.  Install Oracle client 32 bit on windows 7 and set the path.  remove the 64bit client path from environmental variables and restart the machine. now try to connect database using by odbc it was successful.

Now I can able to open my siebel tools 8.1.1.54

Java install

Step 1:  Download java

http://www.oracle.com/technetwork/java/javase/downloads/index.html

Step 2:

Copy the appropriate java file to linux server using winscp

jdk-7u15-linux-x64.rpm

Step 3:

[root@bip java]# rpm -ivh jdk-7u15-linux-x64.rpm
Preparing… ########################################### [100%]
1:jdk ########################################### [100%]
Unpacking JAR files…
rt.jar…
Error: Could not open input file: /usr/java/jdk1.7.0_15/jre/lib/rt.pack
jsse.jar…
Error: Could not open input file: /usr/java/jdk1.7.0_15/jre/lib/jsse.pack
charsets.jar…
Error: Could not open input file: /usr/java/jdk1.7.0_15/jre/lib/charsets.pack
tools.jar…
Error: Could not open input file: /usr/java/jdk1.7.0_15/lib/tools.pack
localedata.jar…
Error: Could not open input file: /usr/java/jdk1.7.0_15/jre/lib/ext/localedata.p

Ignore this above error

Step 4:

[root@bip java]# alternatives –install /usr/bin/java java /usr/java/jdk1.7.0_15 /bin/java 2
[root@bip java]# alternatives –config java

There are 3 programs which provide ‘java’.

Selection Command
———————————————–
* 1 /usr/lib/jvm/jre-1.4.2-gcj/bin/java
2 /usr/java/jdk1.7.0_15/bin/java
+ 3 /usr/java/jdk1.6.0_41/bin/java

Enter to keep the current selection[+], or type selection number: 2

Step 5:

[root@bip java]# java -version
java version “1.7.0_15”
Java(TM) SE Runtime Environment (build 1.7.0_15-b03)
Java HotSpot(TM) 64-Bit Server VM (build 23.7-b01, mixed mode)

Step 6 :

If you want set the java home path in oracle

[root@bip ~]# su – oracle
[oracle@bip ~]$ vi .bash_profile

#Java Settings
JAVA_HOME=/usr/java/jdk1.7.0_15; export JAVA_HOME
PATH=/usr/sbin:$PATH; export PATH
PATH=$JAVA_HOME/bin:$PATH; export PATH

save it

Step 7:

[oracle@bip ~]$ which java
/usr/java/jdk1.7.0_15/bin/java

Step 8:

Symbolic creation

[root@bip jvm]# ln -s /usr/java/jdk1.7.0_15 /usr/lib/jvm/jdk1.7.0_15

[root@bip jvm]# ls -l jdk1.7.0_15
lrwxrwxrwx 1 root root 21 Feb 23 22:50 jdk1.7.0_15 -> /usr/java/jdk1.7.0_15