STEP:-1
#. PREPARE THE SOURCE SYSTEM DATABASE TIER FOR CLONING:-

[oracle@prasad ~]$ cd /oracle/idea/db/tech_st/11.1.0/appsutil/scripts/idea_prasad

[oracle@prasad idea_prasad]$ ll
total 60
-rwx------ 1 oracle dba  1525 Nov 24 11:56 adautocfg.sh
-rwx------ 1 oracle dba  5079 Nov 24 11:56 adchknls.pl
-rwx------ 1 oracle dba  2772 Nov 24 11:56 addbctl.sh
-rwx------ 1 oracle dba  4110 Nov 24 11:56 addlnctl.sh
-rwx------ 1 oracle dba  7112 Nov 24 11:56 adexecsql.pl
-rwx------ 1 oracle dba  3405 Nov 24 11:56 adlsnodes.sh
-rwx------ 1 oracle dba 15247 Nov 24 11:56 adpreclone.pl
-rw------- 1 oracle dba   805 Nov 24 11:56 adstopdb.sql
-rw------- 1 oracle dba  1207 Nov 24 11:56 adstrtdb.sql

[oracle@prasad idea_prasad]$ perl adpreclone.pl dbTier
Enter the APPS User Password:apps
 59% completed    

Completed Stage...
Fri Nov 25 10:26:17 2011

STEPS:-2
#. PREPARE THE SOURCE SYSTEM APPLICATION TIER FOR CLONING:-

[oracle@prasad /]$ cd /oracle/idea/apps/apps_st/appl/
[oracle@prasad appl]$ . APPSidea_prasad.env
[oracle@prasad appl]$ cd $ADMIN_SCRIPTS_HOME

[oracle@prasad scripts]$ perl adpreclone.pl appsTier

 /     80% completed    
Completed Stage...
Fri Nov 25 11:23:39 2011

STEPS:-3
#. DOWN APPLICATION TIER AND DATABASE TIER:-

[oracle@prasad idea_prasad]$ cd /oracle/idea/apps/apps_st/appl/
[oracle@prasad appl]$ . APPSidea_prasad.env
cd [oracle@prasad appl]$ cd $ADMIN_SCRIPTS_HOME
[oracle@prasad scripts]$ ./adstpall.sh apps/apps

[oracle@prasad scripts]$ cd /oracle/idea/db/tech_st/11.1.0/appsutil/scripts/idea_prasad/
[oracle@prasad idea_prasad]$ ./addlnctl.sh stop idea

[oracle@prasad idea_prasad]$ ./addbctl.sh stop immediate

STEPS:-4
#. COPY Base dir Source to target System:-

[oracle@prasad R12_clone]$ cd /oracle/
[oracle@prasad oracle]$ ll
drwxr-xr-x 5 oracle dba 4096 Nov 24 10:54 idea
[oracle@prasad oracle]$ du -sh
78G     .

[oracle@prasad oracle]$ cp -r idea/ /R12_clone/
time:-11:54am-1:43pm

STEPS:-5
#. CONFIGURE THE TARGET SYSTEM DATABASE NODE:-

[oracle@prasad ~]$ cd /R12_clone/idea/db/tech_st/11.1.0/appsutil/clone/bin/

[oracle@prasad bin]$ ls
adcfgclone.pl  adchkutl.sh  adclonectx.pl  adclone.pl

[oracle@prasad bin]$ perl adcfgclone.pl dbTier

Enter the APPS password :apps
Target System Hostname (virtual or normal) [prasad] :
Target Instance is RAC (y/n) [n] : n
Target System Database SID : idea
Target System Base Directory : /R12_clone/idea
Target System utl_file_dir Directory List : /tmp
Number of DATA_TOP's on the Target System [1] :
Target System DATA_TOP Directory 1 [/oracle/idea/db/apps_st/data] : /R12_clone/idea/db/apps_st/data
Target System RDBMS ORACLE_HOME Directory [/R12_clone/idea/db/tech_st/11.1.0] :
Do you want to preserve the Display [null] (y/n) ? : n
Target System Display [prasad:0.0] :
Target System Port Pool [0-99] : 11
15% completed    

Completed Apply...
Fri Nov 25 14:16:38 2011

[oracle@prasad bin]$ cd /R12_clone/idea/db/tech_st/11.1.0/
[oracle@prasad 11.1.0]$ . idea_prasad.env
[oracle@prasad 11.1.0]$ sqlplus
Enter user-name: sys as sysdba
Enter password:sys
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size                  1318172 bytes
Variable Size             427819748 bytes
Database Buffers          629145600 bytes
Redo Buffers               13049856 bytes
Database mounted.
Database opened.
SQL> !
[oracle@prasad 11.1.0]$

STEPS:-6
#. CONFIGURE THE TARGET SYSTEM APPLICATION NODE:-

[oracle@prasad ~]$ cd /R12_clone/idea/apps/apps_st/comn/clone/bin

[oracle@prasad bin]$ perl adcfgclone.pl appsTier

Enter the APPS password : apps
Target System Hostname (virtual or normal) [prasad] :
Target System Database SID : idea
Target System Database Server Node [prasad] :
Target System Base Directory : /R12_clone/idea
Target System Tools ORACLE_HOME Directory [/R12_clone/idea/apps/tech_st/10.1.2] :
Target System Web ORACLE_HOME Directory [/R12_clone/idea/apps/tech_st/10.1.3] :
Target System APPL_TOP Directory [/R12_clone/idea/apps/apps_st/appl] :
Target System COMMON_TOP Directory [/R12_clone/idea/apps/apps_st/comn] :
Target System Instance Home Directory [/R12_clone/idea/inst] :
Target System Root Service [enabled] :
Target System Web Entry Point Services [enabled] :
Target System Web Application Services [enabled] :
Target System Batch Processing Services [enabled] :
Target System Other Services [disabled] :
Do you want to preserve the Display [prasad:0.0] (y/n) ? : y
RC-00217: Warning: Configuration home directory (s_config_home) evaluates to /R12_clone/idea/inst/apps/idea_prasad. A directory with this name already exists and is not empty.
Do you want to continue (y/n) ?  : y
Target System Port Pool [0-99] : 11
Checking the port pool 11
done: Port Pool 11 is free
Report file located at /R12_clone/idea/inst/apps/idea_prasad/temp/portpool.lst
Complete port information available at /R12_clone/idea/inst/apps/idea_prasad/temp/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /tmp
3. /R12_clone/idea/db/tech_st/11.1.0/appsutil/outbound/idea_prasad
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :

STEPS:-7
#.CHECK APPLICATION LOGIN PAGE WORKS:-

OPEN mozilla
URL:-http://prasad.oracle.com:8011/
HOME PAGE OPEN

USER:-sysadmin
password:-sysadmin


Oracle ebs-R12.1.1 COLD CLONING Signal node Signal User.

COLD CLONING Oracle ebs-R12.1.1 Signal node Signal User.
STEP:-1
#.PREPARE THE SOURCE SYSTEM DATABASE TIER FOR CLONING:-

[oracle@prasad ~]$ cd /oracle/idea/db/tech_st/11.1.0/appsutil/scripts/idea_prasad

[oracle@prasad idea_prasad]$ ll
total 60
-rwx------ 1 oracle dba  1525 Nov 24 11:56 adautocfg.sh
-rwx------ 1 oracle dba  5079 Nov 24 11:56 adchknls.pl
-rwx------ 1 oracle dba  2772 Nov 24 11:56 addbctl.sh
-rwx------ 1 oracle dba  4110 Nov 24 11:56 addlnctl.sh
-rwx------ 1 oracle dba  7112 Nov 24 11:56 adexecsql.pl
-rwx------ 1 oracle dba  3405 Nov 24 11:56 adlsnodes.sh
-rwx------ 1 oracle dba 15247 Nov 24 11:56 adpreclone.pl
-rw------- 1 oracle dba   805 Nov 24 11:56 adstopdb.sql
-rw------- 1 oracle dba  1207 Nov 24 11:56 adstrtdb.sql

[oracle@prasad idea_prasad]$ perl adpreclone.pl dbTier
Enter the APPS User Password:apps
 59% completed      

Completed Stage...
Fri Nov 25 10:26:17 2011

STEPS:-2
#.PREPARE THE SOURCE SYSTEM APPLICATION TIER FOR CLONING:-

[oracle@prasad /]$ cd /oracle/idea/apps/apps_st/appl/
[oracle@prasad appl]$ . APPSidea_prasad.env
[oracle@prasad appl]$ cd $ADMIN_SCRIPTS_HOME

[oracle@prasad scripts]$ perl adpreclone.pl appsTier

 /     80% completed      
Completed Stage...
Fri Nov 25 11:23:39 2011

STEPS:-3
#.DOWN APPLICATION TIER AND DATABASE TIER:-

[oracle@prasad idea_prasad]$ cd /oracle/idea/apps/apps_st/appl/
[oracle@prasad appl]$ . APPSidea_prasad.env
cd [oracle@prasad appl]$ cd $ADMIN_SCRIPTS_HOME
[oracle@prasad scripts]$ ./adstpall.sh apps/apps

[oracle@prasad scripts]$ cd /oracle/idea/db/tech_st/11.1.0/appsutil/scripts/idea_prasad/
[oracle@prasad idea_prasad]$ ./addlnctl.sh stop idea

[oracle@prasad idea_prasad]$ ./addbctl.sh stop immediate

STEPS:-4
#.COPY Base dir Source to target System:-

[oracle@prasad R12_clone]$ cd /oracle/
[oracle@prasad oracle]$ ll
drwxr-xr-x 5 oracle dba 4096 Nov 24 10:54 idea
[oracle@prasad oracle]$ du -sh
78G     .

[oracle@prasad oracle]$ cp -r idea/ /R12_clone/
time:-11:54am-1:43pm

STEPS:-5
#.CONFIGURE THE TARGET SYSTEM DATABASE NODE:-

[oracle@prasad ~]$ cd /R12_clone/idea/db/tech_st/11.1.0/appsutil/clone/bin/

[oracle@prasad bin]$ ls
adcfgclone.pl  adchkutl.sh  adclonectx.pl  adclone.pl

[oracle@prasad bin]$ perl adcfgclone.pl dbTier

Enter the APPS password :apps
Target System Hostname (virtual or normal) [prasad] :
Target Instance is RAC (y/n) [n] : n
Target System Database SID : idea
Target System Base Directory : /R12_clone/idea
Target System utl_file_dir Directory List : /tmp
Number of DATA_TOP's on the Target System [1] :
Target System DATA_TOP Directory 1 [/oracle/idea/db/apps_st/data] : /R12_clone/idea/db/apps_st/data
Target System RDBMS ORACLE_HOME Directory [/R12_clone/idea/db/tech_st/11.1.0] :
Do you want to preserve the Display [null] (y/n) ? : n
Target System Display [prasad:0.0] :
Target System Port Pool [0-99] : 11
15% completed      

Completed Apply...
Fri Nov 25 14:16:38 2011

[oracle@prasad bin]$ cd /R12_clone/idea/db/tech_st/11.1.0/
[oracle@prasad 11.1.0]$ . idea_prasad.env
[oracle@prasad 11.1.0]$ sqlplus
Enter user-name: sys as sysdba
Enter password:sys
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size                  1318172 bytes
Variable Size             427819748 bytes
Database Buffers          629145600 bytes
Redo Buffers               13049856 bytes
Database mounted.
Database opened.
SQL> !
[oracle@prasad 11.1.0]$

STEPS:-6
#.CONFIGURE THE TARGET SYSTEM APPLICATION NODE:-

[oracle@prasad ~]$ cd /R12_clone/idea/apps/apps_st/comn/clone/bin

[oracle@prasad bin]$ perl adcfgclone.pl appsTier

Enter the APPS password : apps
Target System Hostname (virtual or normal) [prasad] :
Target System Database SID : idea
Target System Database Server Node [prasad] :
Target System Base Directory : /R12_clone/idea
Target System Tools ORACLE_HOME Directory [/R12_clone/idea/apps/tech_st/10.1.2] :
Target System Web ORACLE_HOME Directory [/R12_clone/idea/apps/tech_st/10.1.3] :
Target System APPL_TOP Directory [/R12_clone/idea/apps/apps_st/appl] :
Target System COMMON_TOP Directory [/R12_clone/idea/apps/apps_st/comn] :
Target System Instance Home Directory [/R12_clone/idea/inst] :
Target System Root Service [enabled] :
Target System Web Entry Point Services [enabled] :
Target System Web Application Services [enabled] :
Target System Batch Processing Services [enabled] :
Target System Other Services [disabled] :
Do you want to preserve the Display [prasad:0.0] (y/n) ? : y
RC-00217: Warning: Configuration home directory (s_config_home) evaluates to /R12_clone/idea/inst/apps/idea_prasad. A directory with this name already exists and is not empty.
Do you want to continue (y/n) ?  : y
Target System Port Pool [0-99] : 11
Checking the port pool 11
done: Port Pool 11 is free
Report file located at /R12_clone/idea/inst/apps/idea_prasad/temp/portpool.lst
Complete port information available at /R12_clone/idea/inst/apps/idea_prasad/temp/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /tmp
3. /R12_clone/idea/db/tech_st/11.1.0/appsutil/outbound/idea_prasad
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :

STEPS:-7
#.CHECK APPLICATION LOGIN PAGE WORKS:-

OPEN mozilla
URL:-http://prasad.oracle.com:8011/
HOME PAGE OPEN

USER:-sysadmin
password:-sysadmin

>>>>>>>>END CLONE STEPS>>>>>>>>>>>>>>>>>>>>>>>>


Oracle SES install on Linux OS...









                                                                                       

Oracle R12.1.1 Create Secure Enterprise Search (SES)



INSTALL_SES_ON_LINUX_S.4....

Installing Oracle E-Business Suite Secure Enterprise Search, Release 12 [ID 462377.1]

·      Oracle Secure Enterprise Search Release 11g (11.1.2 and 11.1.2.2)


Step:-1

[root@prasad ~]# cat /proc/version


Linux version 2.6.18-164.el5 (mockbuild@x86-002.build.bos.redhat.com) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-46)) #1 SMP Tue Aug 18 15:51:54 EDT 2009


Step:-2

Memory Requirements The memory requirements are determined by the physical

memory consumed by the database and by services such as the WebLogic server. The

memory requirements for installing Oracle SES 11g Release 1 (11.1.2.2) are as follows:

? At least 2 GB of physical RAM. To determine the physical RAM size, enter the

following command:


[root@prasad ~]# grep MemTotal /proc/meminfo


MemTotal:      2036792 kB



If the size of the physical RAM is less than the required size, then you must install

more memory before continuing.


Step:-3

Available RAM Swap Space Required

Between 2 GB and 8 GB   >>>Equal to the size of RAM

Between 8 GB and 14 GB >>>0.75 times the size of RAM

More than 14 GB              >>>10 GB


Step:-4

To determine whether the system architecture can run the software, enter the

following command:



[root@prasad ~]# grep "model name" /proc/cpuinfo


model name      : Pentium(R) Dual-Core  CPU      E5300  @ 2.60GHz


model name      : Pentium(R) Dual-Core  CPU      E5300  @ 2.60GHz



Step:-5


To determine the size of the configured swap space, enter the following command:


[root@prasad ~]# grep SwapTotal /proc/meminfo


SwapTotal:     4192956 kB


Step:-6

 [root@prasad ~]# free



                    total       used             free     shared    buffers     cached


Mem:        2036792    1970536      66256          0      19344    1687636



-/+ buffers/cache:     263556       1773236



Swap:      4192956        112         4192844



Step:-7

Hardware Requirements The system must meet the following minimum hardware

requirements:

On Linux x86:

Oracle SES requires a minimum of 6.6 GB of disk space to install. This includes 4.9 GB

for the software and approximately 1.7 GB for the initial Oracle SES index. Additional

Oracle SES requirements are based on the amount of data that you need to search.

For example, to index 100,000 documents:

? 4 GB disk space

? 2 GB RAM

To index 1,000,000 documents:

? 20 GB disk space

 6 GB RAM

On Linux x86-64:

 Oracle SES requires a minimum of 7.6 GB of disk space to install. This includes 6.0 GB

for the software and approximately 1.6 GB to create the initial Oracle SES index.

Additional Oracle SES requirements are based on the amount of data that you need to

search.

For example, to index 100,000 documents:

?  4 GB disk space

?  2 GB RAM

To index 1,000,000 documents:

?  20 GB disk space

?  6 GB RAM



Step:-8

 It shows a kernel version and errata level on the system:-


[root@prasad ~]# uname -r


2.6.18-164.el5




Step:-9


 Create user,Group and assign group

[root@prasad ~]# /usr/sbin/useradd -g dba oracle


 This command creates the oracle  user and specifies oinstall  as the

primary group. You can also include the -G  option to specify secondary

groups as follows:


[root@prasad ~]#  more /etc/oraInst.loc


inventory_loc=/10g/app/oracle/oraInventory


inst_group=dba


[root@prasad ~]# id -a oracle


uid=500(oracle) gid=501(dba) groups=501(dba)



[root@prasad ~]# /usr/sbin/groupadd oinstall


 If the oracle  user exists, but its primary group is not oinstall , then enter

the following command:-


[root@prasad ~]# /usr/sbin/usermod -g oinstall oracle


If you wish, you can include the -G  option to specify secondary groups:


[root@prasad ~]# /usr/sbin/usermod -g oinstall -G dba[,oper] oracle




[root@prasad ~]# /usr/sbin/useradd -g oinstall -G dba[,oper] oracle


Configure the password of the oracle  user as follows:


[root@prasad ~]#  passwd oracle


Step:-10


The following or later version of packages for Oracle Enterprise Linux 5.0 and Red

Hat Enterprise Linux 5.0 should be installed:

binutils-2.17.50.0.6

compat-libstdc++-33-3.2.3

compat-libstdc++-33-3.2.3 (32 bit)

elfutils-libelf-0.125

elfutils-libelf-devel-0.125

gcc-4.1.1

gcc-c++-4.1.1

glibc-2.5-12

glibc-2.5-12 (32 bit)

glibc-common-2.5

glibc-devel-2.5

glibc-devel-2.5-12 (32 bit)

libaio-0.3.106

libaio-0.3.106 (32 bit)

libaio-devel-0.3.106

libgcc-4.1.1

libgcc-4.1.1 (32 bit)

libstdc++-4.1.1

libstdc++-4.1.1 (32 bit)

libstdc++-devel 4.1.1

make-3.81

numactl-devel-0.9.8.x86_64

sysstat-7.0.0



[root@prasad ~]#  rpm -q package_name


Step:-11

[root@prasad ~]# vi /etc/sysctl.conf



fs.aio-max-nr = 1048576

fs.file-max = 65536

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576


[root@prasad ~]# /sbin/sysctl -p

 


***************************************************


[root@prasad ~]# vi /proc/sys/kernel/sem


semmsl >250

semmns >32000

semopm >100

semmni >128


[root@prasad ~]# vi /proc/sys/kernel/shmall


shmall 2097152

[root@prasad ~]# vi /proc/sys/kernel/shmmni

4096

[root@prasad ~]# vi /proc/sys/fs/file-max

131072

[root@prasad ~]# vi /proc/sys/net/ipv4/ip_local_port_range

1024    65000

[root@prasad ~]# vi /proc/sys/net/core/rmem_default

262144

[root@prasad ~]# /proc/sys/net/core/rmem_max

4194304

Parameter Command

semmsl, semmns,

semopm, and semmni              /sbin/sysctl -a | grep sem


This command displays the value of the semaphore parameters in

the order listed.

shmall, shmmax, and

shmmni                         /sbin/sysctl -a | grep shm

file-max                       /sbin/sysctl -a | grep file-max

ip_local_port_range     /sbin/sysctl -a | grep ip_local_port_range

rmem_default             /sbin/sysctl -a | grep rmem_default

rmem_max                  /sbin/sysctl -a | grep rmem_max

wmem_default            /sbin/sysctl -a | grep wmem_default

wmem_max             /sbin/sysctl -a | grep wmem_max

aio-max-nr                 /sbin/sysctl -a | grep aio-max-nr



Step:-12

Setting Shell Limits for the oracle User:-


 To increase the shell limits:-

1.Add the following lines in the /etc/security/limits.conf file:

2.


[root@prasad ~]# vi /etc/security/limits.conf


oracle     soft      nproc       2047

oracle     hard     nproc      16384

oracle     soft        nofile      1024

oracle     hard      nofile        65536


Step:-13

2. Add the following line to the /etc/pam.d/login file, if it does not already exist:

[root@prasad ~]# vi /etc/pam.d/login


session     required     pam_limits.so


Step:-14

Depending on the oracle  user's default shell, make the following changes to the

default shell startup file:

For the Bourne, Bash, or Korn shell, add the following lines in the

/etc/profile  file (or the /etc/profile.local  file on SUSE systems):

[root@prasad ~]# vi /etc/profile


if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi



For the C shell, add the following lines in the /etc/csh.login  file (or the

/etc/csh.login.local  file on SUSE systems):


Step:-15

[root@prasad ~]# vi /etc/csh.login



if ( $USER == "oracle" ) then

limit maxproc 16384

limit descriptors 65536

endif




Step:-16   Create dir:-


[root@prasad ~]# mkdir ses


Step:-17 Assign user and permission:-


[root@prasad ~]# chown -R oracle:dba ses

[root@prasad ~]# chmod -R 777 ses


Step:-18


[root@prasad ~]# init 6


Step:-19    Go to SES_setup_location:-


[oracle@prasad setup]$ cd SES/


[oracle@prasad SES]$ ll


-rwxrwxrwx 1 oracle dba 1472974438 Feb  1 18:01 ses_11_1_2_2_0_linux32_1of2.zip


-rwxrwxrwx 1 oracle dba  820405088 Feb  1 16:54 ses_11_1_2_2_0_linux32_2of2.zip


Step:-20 Unzip file


[oracle@prasad SES]$ ses_11_1_2_2_0_linux32_1of2.zip

[oracle@prasad SES]$ ses_11_1_2_2_0_linux32_2of2.zip


create a new dir. Same location (ses_11_1_2_2_0_linux32)


Step:-21

[oracle@prasad SES]$ cd ses_11_1_2_2_0_linux32


[oracle@prasad ses_11_1_2_2_0_linux32]$ pwd


/setup/SES/ses_11_1_2_2_0_linux32


[oracle@prasad ses_11_1_2_2_0_linux32]$ ll

total 36

drwxrwxrwx  9 oracle dba 4096 Apr 20  2011 doc


drwxrwxrwx  5 oracle dba 4096 Apr 29  2011 install


drwxrwxrwx  2 oracle dba 4096 Apr 29  2011 Patches


drwxrwxrwx  2 oracle dba 4096 Apr 29  2011 response


-rwxrwxrwx  1 oracle dba 6091 Apr 29  2011 runInstaller


drwxrwxrwx 13 oracle dba 4096 Apr 29  2011 stage


-rwxrwxrwx  1 oracle dba 4534 Apr 19  2011 welcome.html



[oracle@prasad ses_11_1_2_2_0_linux32]$ ./runInstaller


open window>>>>>>>>>




***********************END Install SES*************************************


Starting and Stopping Oracle Secure Enterprise Search

The command for starting and stopping the search engine in Oracle SES is

searchctl. The executable is located in the $ORACLE_HOME/bin directory:


$ORACLE_HOME/bin/searchctl

The command syntax is as follows:-

Command                           Description

searchctl start                       Start the Oracle SES middle tier


searchctl startall                   Start the Oracle SES middle tier and the database


searchctl stop                        Shut down the Oracle SES middle tier


searchctl stopall                     Shut down the Oracle SES middle tier and the database


searchctl restart                    Restart the Oracle SES middle tier


searchctl restartall                 Restart the Oracle SES middle tier and the database


On Linux and UNIX platforms, you must supply the Oracle SES administrative:-

password when running searchctl  commands. If you have shut down both the

database and the middle tier with the searchctl stopall  command, then to

successfully start them both, run searchctl startall . If the Middle Tier Port is

less than 1024, then the following commands must be run by the root user:


[oracle@prasad bin]$ ./searchctl stop


Enter admin_passwd (administrative password):  

oracle123


[oracle@prasad ]$ cd /ses/oracle/seshome/bin

[oracle@prasad bin]$ ./searchctl startall

password :- oracle123

[oracle@prasad bin]$ searchctl start/stop

[oracle@prasad bin]$ searchctl startall

[oracle@prasad bin]$ searchctl stopall

[oracle@prasad bin]$ searchctl restartall


http://prasad.oracle.com:7777/search/admin/


user:-eqsys

pass:-ses12oracle


http://prasad.oracle.com:7777/search/query/



http://prasad.oracle.com:7777/console/login/LoginForm.jsp


user:- weblogic

pass:-oracle123




Performing Setup Tasks:-


1.Create a Search Administrator.


2.Enabling Searches on Oracle E-Business Suite

#.Setting language preferences

#.Setting profile options

#.Assigning FND search Crawler responsibility to an FND user.

#.Performing personalization setup.


3.Performing Setup tasks for Oracle SES Integration.

#.Installing Oracle E-Business Suite Secure Enterprise Search.

#.Configuring search parameters for Oracle SES.

#.Performing setup tasks in Oracle SES.


*************************************

Step:-22

1.Create a Search Administrator:-

#.Creating a User (such as sesadmin/welcome).

         System Administrator>security:User>Define>open users fom..

 User name:-sesadmin

 password:-sesadmin


#.Assigning the following responsibilities to the user:-

a> Application search Administrator responsibility.(FND_SEARCH_ADMIN)

Application Search Administrator

Create responsibility:- System Administrator>security:Responsibility>Define

b> FND Search Crawler responsibility.(FND_SEARCH_CRAWLER)


Step:23

2.Enabling Searches on Oracle E-Business Suite

#.Setting language preferences:-

Home page>Preferences>Display preferences>American English..


Step:-24

#.Setting profile options:-

Profile option name                           default value  Set_value


a> FND : Search Enabling Flag                       N          YES


b> FND : Search Engine URL                          N/Ahttp://prasad.oracle.com:7777/ http://<hostname>:<portnumber>


c> FND : Search Session Timeout Value for Quary     1200       1800


d> FND : Search Session Timeout value for Quary     1200       1800


e> FND : Search Crawl Batch Size                    1000       3000


Step:-25

Application Search Administrator > Configuration Tab:Query Proxy region>

user:-eqsys

pass:-oracle123

************************

User name:-SERVICE

password:-SERVICE

Time out:-1800

          Update


Step:-26

#.Performing personalization setup:-

Note:-Performing personalization setup to display the Enterprise Search region on top of the Oracle E-Business Suite Home Page.


a> login as sysadmin/sysadmin

b> Select the Functional Administrator responsibility from the Navigator menu.


c> Slect the personalization tab and the application Catalog subtab to open the Appliaction Catalog page.


d> In the search region enter>

   /oracle/apps/fnd/search/webuiin the document path field as the search criteria and Click GO.All document names that match the search criteria should be display in the search result table..


e> Click the personalize page icon for the /oracle/apps/fnd/search/webui/AppsSearchRG document name listed in the result table to open the choose Personalization Context page.


f> Enter 'Application Home Page' (OAHOMEPAGE) in the Set function field and click Apply

   to open the personalization Region page for your document.


g> In the personalization structure region,Select the personalization icon for the Row      Layout field to open the personalize Row layout Page.


h> Set the rendered property to 'true' at the 'function' Applications Home Page' level.


i> Navigate back to the Home Page after applying the personalization change.


j> Review if the Enterprise Search region is getting rendered on the Oracle E-Business Suite Home Page.


k> Perform a search by entering search criteria and click GO to verify if the search result is displayed in the search result page...


Step:-7

#.Configuring search Proxy parameters: Accessing Search Admin Page:-


a> login on to oracle E-Business Suit as search Administrator username

(such as sesadmin/sesadmin)


b> Select the Application Search Administrator responsibility > Application Search Administrator link from the navigator.


Schedules Tab:-use this tab to view crawling status and manage crawling schedules.


Configuration Tab:-Use this tab to configure search proxy parameters to enable the integration between Oracle EBS and SES.


note:-You can also access Oracle SES Administrative page directly through this tab.In the additional tasks section on the lower right corner of this tab.click the SES Admin login link to get to Oracle SES login page.


c> Searchable Objects:-Use this tab to deploy searchable objects from Oracle EBS to the SES instance that you defined in the SES End point URL field in the Configuration tab...


 step:-8

#.Performing setup tasks in Oracle SES:-

Accessing Oracle Secure Enterprise Search Administrative page:-

Use either of the following two ways to access Oracle SES administrative page:-

#. Log on to the Oracle SES administrative user interface through:-


  http://prasad.oracle.com:7777/search/admin

u:-eqsys

p:-oracle123


#. Log on to the Oracle SES administrative page from the Oracle E-Business Suit Secure Enterprise Search Administrative page.

    Configuration tab > ses Admin login > get Oracle SES login page.


Step:-9

#.Configure the following Global setup task in Oracle SES:-

Identity Management Setup:-

Global Settings tab > identity management Setup link (click in this link)

And enter the following information to activate an available plug-in in order to enable secure search.


#.Select 'oracle.search.plugin.security.ebs.EBSidentityPluginMgr' from the available identity plug-in region and click ACTIVate.


#.In the activate identity plug-in page.enter the following parameter values to define the selected identity plug-in settings for all authentication and validation activities in ORACLE ses:

a> HTTP endpoint for authentication:Enter an end point URL for Oracle E-Businees Release 12 authentication,such as

   http://prasad.oracle.com/7777/webservices/AppSearch/SecurityService.

b> User ID :- Enter the search administrator's user name that you created earlier.


c> Password : Enter the search Administrator's login password.

d> Click FInish to return to the Global Settings page.


step:-10

Federation trusted Entity Setup:-

    #.Global Settings tab >Federation trusted Entity link.(click on this link)

     Open >Federation trusted Entity page

    #.user name:-sesadmin/welcome

    #.Select the Use Entity plug-in for authentication check box to authentication through the active identity plug-in.

    #.Click ADD.


Step:-11

Quary Configuration Setup:-

     #.Global Settings tab >Quary Configuration link.

     In the query-time Uthorization configuration region,enetr the following parameter values to specify the query configuration for the query-time authorization engine: Time out threshold (milliseconds):500000


#.In the secure search Configuration region,enter the following information in the Security Filter Configuration section to specify security filetr related parameter values:

Authorization Timeout (milliseconds):200000

Authorization Timeout (milliseconds):500000


Step:-12

[oracle@prasad config]$ cd  /ses/oracle/seshome/search/webapp/config

[oracle@prasad config]$ vi search.properties

# configure time in milliseconds to wait for security filter refresh task to finish during query processing

sec_filter_refresh_wait_time=2000


Step:-13


Restart instance:-

A> Oracle SES

B> Oracle E-Business Suite instances.


 Accessing Oracle Search Modeler:-

The Search modeler login page should have followinh URL:-

http://prasad.oracle.com:7777/modeler/faces/ModelerHome.jsp

Only user with'UMX|APPSEARCH_DEVELOPER' user role will have the search modeler login privilege.



Step:-14

Creating Searchable Objects:-



 Note: Make sure that the following configuration should also be performed in Oracle SES server:

1    Locate the search.properties file in $ORACLE_HOME/search/webapp/config directory.

2    Set the security filter refresh task wait time value: sec_filter_refresh_wait_time=20000.

3     This is the time in milliseconds to wait for security filter refresh task to finish during

4    query processing.

5    Use the following steps to set the parameters in Oracle SES to avoid issues related to security

6    plug-in timeout:

7    Logon to the Oracle SES administrative user interface using

8    http://prasad.oracle.com:777/search/admin

9    Select the Global Settings tab from the Secure Enterprise Search page.

10Select the Query Configuration link from the Search section.

11In the Query-time Authorization Configuration region, enter the following parameter

12values to specify the query configuration for the query-time authorization engine:

·     Timeout Threshold (milliseconds): 500000

13 In the Secure Search Configuration region, enter the following information in the Security Filter

14 Configuration section to specify security filter related parameter values:

·      Authentication Timeout (milliseconds): 200000

15 Authorization Timeout (milliseconds): 500000 Create a search administrator with the following responsibilities:

·      Application Search Administrator responsibility (FND_SEARCH_ADMIN)

·      FND Search Crawler responsibility (FND_SEARCH_CRAWLER)

16Log on to Oracle E-Business Suite with the search administrator user name and password.sesadmin/sesadmin

17 Select the Application Search Administrator responsibility and choose Application Search Administration from the navigation menu.

18 In the Application Search Administrator page, select the Configuration tab.

19 Specify the following information in the SES End Point region:

·      SES End Point URL: Enter an URL address with the format,http://prasad.oracle.com:777/ in this field. This value can be defined in the 'FND: Search Engine URL' profile option.

·      SES Version: Enter an appropriate Oracle SES version that your system will be integrated with. It should have minimum two characters, and the first two characters should be digits, such as 10.1.8.4, 11.1.2, or 11g. Values entered here will be stored in the 'FND: Search SES Version' profile option.

20 In the Admin Proxy region, enter the following fields:

·      User Name: eqsys /oracle123

·      Password: use the same password for eqsys username when you installed the SES

·      Time Out: 1200 secs

21 In the Query Proxy region, enter the following fields:

·      User Name: an application username with the FND Search Crawler responsibility

·      Password: use the password for the above username

·      Time Out: 1200 secs

22 Once you change the information in the Query Proxy region, the Oracle SES instance needs to be restarted.

23 Set the FND: Search Enabling Flag (FND_SEARCH_ENABLED) profile option to "Y" at the site level.

24 Logon to the Oracle SES administrative user interface using>>sesadmin/ses12oraclehttp://prasad.oracle.com:7777/search/admin/

25 Select the Global Settings tab from the Secure Enterprise Search page to configure the following settings.

·      Select the 'Identity Management Setup' link from the System section to set up connections between Oracle SES and an identity management system to validate and authenticate users for secured searches.

·      Selectoracle.search.plugin.security.identity.ebs.EBSIdentityPluginMgr from the Available Identity Plug-in region and click Activate.

·      In the Activate Identity Plug-in page, enter the following parameter values to define the selected Identity Plug-in settings for all authentication and validation activity in Oracle SES:

·      HTTP endpoint for authentication: Enter an end point URL for Oracle E-Business Release 12 authentication, such ashttp://dev1211.iwarelogic.com:8020/webservices/AppSearch/SecurityService

·      User ID: Enter the search administrator's user name that you created earlier in Step 1. sesadmin

·      Password: Enter the search administrator's login password.

·      ses12oracle

·      Click Finish to return to the Global Settings page.

·      Select the 'Federation Trusted Entities' link from the Search section to add federation entities.

·      In the Federation Trusted Entities page, enter the following information:

·      Entity Name: Enter the search administrator's user name that you created earlier in Step 1. sesadmin

·      Entity Password: Enter the search administrator's login password.ses12oracle

·      Select the Use Identity Plug-in for authentication check box to authenticate through the active identity plug-in.

·      Click Add to return to the Global Settings page.

·      Select the 'Crawler Configuration' link from the Sources section to ensure the crawler logging setting is appropriate.

·      In the Crawler Logging region, ensure the crawler log file directory path including log file name defined in the Crawler Log File Directory field is less than the supported length of 100 characters for Oracle SES 11.1.2 or SES 11.1.2.2 integration.

·      Click Apply.

26

27Restart both Oracle SES and Oracle E-Business Suite instances.

To ensure that the Enterprise Search region appears on top of the Oracle E-Business Suite Home page, perform the following personalization steps:

1     Log in to Oracle E-Business Suite with the system administrator's user name and password.(sysadmin/sysadmin)

2     Select the Functional Administrator responsibility from the Navigator menu.

3     Select the Personalization tab and the Application Catalog subtab to open the Application Catalog page.

4     In the Search region, enter '/oracle/apps/fnd/search/webui' in the Document Path field as the search criteria and click Go. All document names that match the search criteria should be displayed in the search result table.

5     Click the Personalize Page icon for the '/oracle/apps/fnd/search/webui/AppsSearchRG' document name listed in the result table to open the Choose Personalization Context page.

[oracle@dev1211 12.0.0]$ pwd


/data/R12/oracle/VIS/apps/apps_st/appl/fnd/12.0.0/


1     Enter 'Applications Home Page' (OAHOMEPAGE) in the Set Function field and click Apply to open the Personalization Region page for your document.

2     In the Personalization Structure region, select thePersonalize icon for the Row Layout field to open the Personalize Row Layout page.

3     Set the rendered property to 'true' at the 'Function: Applications Home Page' level.

4     Navigate back to the Home page after applying the personalization change.

5     Review if the Enterprise Search region is getting rendered on the Oracle E-Business Suite Home page.

6     Perform a search by entering search criteria and click Go to verify if the search result is displayed in the search result page.


Oracle Secure Enterprise Search with Oracle E-Business Suite 11i & R12 releases

What are we announcing?

We are pleased to announce the availability of Oracle E-Business Suite Secure Enterprise Search Solutions for Oracle E-Business Suite R11.5.10 customers. Following products are now available for customers to download via My Oracle Support (formerly known as OracleMetaLink).

Oracle Secure Enterprise Search (SES) is integrated with Oracle E-Business Suite applications Releases R11.5.10, R12.0.4 onwards and R12.1.1. Please see the following matrix for patch numbers.

E-Business Suite ReleasePatch number11.5.10.CU2822563112.0.4738964312.1.18441410

 Abstract APPSEARCH CUMMULATIVE

PATCH   Update 8441410 Product Application Object Library

Release R12 Platform Generic Platform Built

Instructions

 Instructions For Applying This Patch Preparation Tasks

The tasks in this section can be completed without taking any Applications services or users offline.There are no tasks to be performed in this section.Pre-install Tasks

You must shut down all Application tier services before performing the tasks in this section.There are no tasks to be performed in this section.Apply The PatchApply patch

This patch contains the following unified driver file to be applied with

AutoPatch:

    u8441410.drv (This is the unified driver)Post-install Tasks

You must complete the tasks in this section before starting up Application tier services.There are no tasks to be performed in this section.Finishing Tasks

You may complete the tasks in this section at any time after the update, without taking any services or users offline.There are no tasks to be performed in this section.Additional InformationThere are no tasks to be performed in this section.  Description

This patch provides E-Business Suite Release 12.1.1 (onwards) interoperability

with Oracle Secure Enterprise Search minimum version of 10.1.8.4 and Search

Modeler minimum version of 1.2.


After applying this patch, E-Business Suite customers will be able to

integrate with Oracle Secure Enterprise Search and Oracle Search Modeler.



Available Documentation

http://blogs.oracle.com/stevenChan/entry/secure_enterprise_search_11_1


Installing Oracle E-Business Suite Secure Enterprise Search, Release 12 [ID 462377.1]

Oracle E-Business Suite Secure Enterprise Search documentation is available as part of the Online Documentation Library on the Oracle Technology Network:

·      Oracle E-Business Suite User's Guide

·      Oracle E-Business Suite System Administrator's Guide - Maintenance (or Oracle Applications System Administrator's Guide - Maintenance depending on your Oracle E-Business Suite release)

For more information on setup steps and administrative tasks, see Administering Oracle E-Business Suite Secure Enterprise Search, Oracle E-Business Suite System Administrator's Guide - Maintenance.

Additionally, see the following Knowledge Documents on My Oracle Support (formerly OracleMetaLink) about Oracle E-Business Suite Secure Enterprise Search:

·      726239.1: Oracle E-Business Suite Secure Enterprise Search Troubleshooting Guidelines, Release 12

·      744820.1: Oracle E-Business Suite Secure Enterprise Search Best Practices, Release 12

·      781366.1: Search Modeler 1.1 for Oracle E-Business Suite Readme

·      1077540.1: Oracle E-Business Suite Secure Enterprise Search, Release Notes for Release 12.1.3

·      953483.1: Oracle E-Business Suite Secure Enterprise Search, Release Notes for Release 12.1.2

·      566097.1: Oracle E-Business Suite Secure Enterprise Search, Release Notes for Release 12.1.1

·      740499.1: Oracle E-Business Suite Secure Enterprise Search, Release Notes for Release 12.0.6