Posts from the ‘Uncategorized’ Category

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

sqlplus: error while loading shared libraries: /u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1: cannot restore segment prot after reloc: Permission denied

[root@bip ~]# cat /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing – SELinux security policy is enforced.
# permissive – SELinux prints warnings instead of enforcing.
# disabled – SELinux is fully disabled.
SELINUX=enforcing
# SELINUXTYPE= type of policy in use. Possible values are:
# targeted – Only targeted network daemons are protected.
# strict – Full SELinux protection.
SELINUXTYPE=targeted
[root@bip ~]#

Change enforcing — disabled
[root@bip ~]# cat /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing – SELinux security policy is enforced.
# permissive – SELinux prints warnings instead of enforcing.
# disabled – SELinux is fully disabled.
SELINUX=disabled
# SELINUXTYPE= type of policy in use. Possible values are:
# targeted – Only targeted network daemons are protected.
# strict – Full SELinux protection.
SELINUXTYPE=targeted
[root@bip ~]#
reboot the linux machine

the VMware Authorization service not running

When you‘re try to open your virtual machine, it shows below error

Don’t confuse ” Start the VMware authorization service and agent service from windows service panel”

run –> services.msc –> start the both service

World Cancer Day

Insha Allah everyone gets well soon who is infected by cancer.

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

You can face the below error sometimes in siebel application

“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”

The problem may come your SADMIN and GUESTCST user password expired. so change your SADMIN and GUESTCST password.

The problem may come If your *.srf file permission was changed. so check your *.srf file permision.

The problem may come after restarted the server, the *.shm file not created on the siebel server. check here /siebel/appenterprise/siebsrvr/admin/*.shm

Atlast I don’t know if everything is okay but still you’re facing this issues, just delete *.shm and osdf file from siebel and gateway server, restart the gateway and siebel server.