Friday, December 5, 2014

Oracle Database Installations --- Details!!

++ Basic INFO - Oracle Database Installations ++

1. Before installing make sure, you are set all required PATH and Environment parameters

2. Go to $ vi /etc/hosts and set hostname 

3. Go to $ vi ~ /.bash_profile and set ORACLE_HOME environment values as below ...
ORACLE_HOSTNAME= iam-dev.com; export ORACLE_HOSTNAME
ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME
ORACLE_BASE=/home/app/database; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

To take this effect: run $ . ~ /.bash_profile command for 'oracle' and 'root' users.
My case, i have logged in both root as well as oracle and modified the ~ /.bash_profile file.

4. Go to $ vi /etc/profile

At the end of the file add;

export JAVA_HOME=/usr/java/jdk1.7.0_60
export PATH=$PATH:/usr/java/jdk1.7.0_60/bin
export ORACLE_HOME=/home/app/database/product/11.2.0/dbhome_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

5. Unzip the installers 

6. Sample screen shot shows the database details.


Thanks
VK

Saturday, August 9, 2014

psa command run for OPSS Schema upgrade!!



#### PSA Run ####

When you validate your configureSecurityStore you may get below info in your out prompt!!


INFO: Your Policy store schema is not upgraded to the latest version!

Please run the PSA (Patch Set Assistant) to upgrade the current schema version 11.1.1.7.0 to the latest version 11.1.1.7.2.

On UNIX:

Move from your present working directory to the MW_HOME/oracle_common/bin directory by running the following command on the command line:


cd /oracle_common/bin 
For e.g /home/Middleware/oracle_common/bin

    Run the following command:

    ./psa

[oracle@oiam bin]$ ./psa
- Ask for available products upgrades

- Select Oracle Access Manager (When you select OAM in turn it selects OPSS and IAU schema)

- You prompt to DB connetion (host:port/service, sys as sysdba and schema user name as DEV_IAU)

- OPSS details upgraded are displayed

- Can validated through the


MW_HOME/oracle_common/upgrade/logs/psa/psatimestamp.log


Thanks
VK









Saturday, August 2, 2014

OAM 11gr2ps2 Install steps - Quick Start

1. Install JDK/JRE

 $ vi ~/.bash_profile Set JAVA_HOME as follows using syntax export JAVA_HOME=. If your path is set to /usr/java/jdk1.5.0_07/bin/java, set it as follows: export JAVA_HOME=/usr/java/jdk1.5.0_07/bin/java Set PATH as follows: export PATH=$PATH:/usr/java/jdk1.5.0_07/bin Then run $ . ~/.bash_profile === Once you done above then your JAVA_HOME should looks like below === [oracle@oiam jdk1.7.0_60]$ echo $JAVA_HOME /usr/java/jdk1.7.0_60/bin/java [oracle@oiam jdk1.7.0_60]$ echo $PATH /usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin:/sbin:/usr/sbin:/usr/java/jdk1.7.0_60/bin:/usr/java/jdk1.7.0_60/bin:/home/oracle/bin:/sbin:/usr/sbin:/usr/java/jdk1.7.0_60/bin:/home/oracle/bin:/sbin:/usr/sbin:/usr/java/jdk1.7.0_60/bin [oracle@oiam jdk1.7.0_60]$ java -version java version "1.7.0_25" Java(TM) SE Runtime Environment (build 1.7.0_25-b15) Java HotSpot(TM) 64-Bit Server VM (build 23.25-b01, mixed mode) [oracle@oiam jdk1.7.0_60]$ ### Installing DB ### 1. Start your DB installation --- Come up doubt or Error please post here!! 2. Then Create and Configured Oracle_Home should looks like -- > /database/product/11g/db_1/ Global id/SID ---> orcl Password for SYS/SYSTEM --> remember your password ### WLS Install ### WLSHome should set as /home/Middleware 

### Start OAM Install ### 

You might have downloaded below files!! 
ofm_iam_generic_11.1.2.2.0_disk1_1of2.zip 
ofm_iam_generic_11.1.2.2.0_disk1_2of2.zip
$unzip ofm_iam_generic_11.1.2.2.0_disk1_1of2.zip 
$unzip ofm_iam_generic_11.1.2.2.0_disk1_2of2.zip 
You could see 3 Disk then go to Disk1 $ ./runInstaller It will ask for JDK/JRE location --- for e.g /usr/java/jdk1.7.0_60 
You end up with like ... nstall Software Only: Location: Middleware Home Location: /home/Middleware Oracle Home Location: /home/Middleware/Oracle_IDM1 Application Server Type: WebLogic Server Disk Space: Oracle Home Size: 2367 MB Available: 99828 MB Applications: Oracle Identity Manager Server Oracle Identity Manager Design Console Oracle Identity Manager Remote Manager Oracle Access Manager Oracle Identity Navigator Oracle Adaptive Access Manager Oracle Access Management Mobile and Social Oracle Privileged Account Manager Oracle Entitlement Server 

### Configure weblogic domain ### 
Usually, you configure a domain to include additional WebLogic Server instances called Managed Servers (our case oam_server1). You deploy Web applications, EJBs, Web services, and other resources onto the Managed Servers and use the Administration Server for configuration and management purposes only. 
/home/Middleware/wlserver_10.3/common/bin $ ./config.sh In generate domain we have multiple fusion middleware products. Please select Oracle Access Management - 11.1.2.0.0[Oracle_IDM1] OAM domain name --- oam_domain OAM Domain Location --- /home/Middleware/user_projects/domains Configure JDBC component Schema You should see there will two component schemas for e.g OAM Infrastructure and OPSS Schema. While configuring, you need to give DB details for e.g DB service name and port. 

SQL Test = select 1 from schema_version_registry where owner=(select user from dual) and mr_type='OAM' Then create it. OHS and Webgate configurations will be posting soon .... Thank you for patience!!

Tuesday, July 15, 2014

Thursday, June 19, 2014

Loadbalancer-OAM

The below error while doing configuring OAM with load balancer "Bad Oracle Access Manager Request Unable to process the request due to unexpected error."