Oracle Fusion Applications architecture

So, its time for Fusion Applications....

Oracle Fusion Applications follows a modular, standards-based architecture and making it highly adaptable. This standards-based technology enables you to respond effectively to change with flexible, modular, user-driven business software that is powered by best-in-class business capabilities built on open standards. Its technology framework includes the following products:

Oracle WebCenter - design time and runtime tools for building enterprise portals, transactional websites, and social networking sites.

Oracle Business Intelligence 11g -  analyze, present, report, and deliver organizational data.

Oracle Universal Content Management - document management, Web content management, digital asset management; and records retention functionality to build and complement your business applications.

Oracle Service-Oriented Architecture (SOA) Suite  - designing, deploying, and managing SOA composite applications

Oracle WebLogic Server - scalable, enterprise-ready application server based on Java Enterprise Edition (Java EE).

Oracle JDeveloper  - modeling, developing, debugging, optimizing, and deploying Java applications and web services.

Oracle Enterprise Manager  - applications management, integrated application to disk management, integrated systems management, and support experience.

Oracle Identity Management -  user identities and to secure access to enterprise resources and assets.

Using a standards-based architecture drives down cost for integration and enables you to reuse systems and technologies. Standards-based architecture also enables the flexibility of the applications. You can fit the applications to your business by configuring not only the user interface, but also the business objects, the business processes, the business logic, and business intelligence.

This picture illustrates the architecture of Oracle Fusion Applications.

Oracle Fusion Applications uses a unified data model, which is a superset of E-Business Suite, PeopleSoft, JD Edwards, and Siebel entities and attributes and you can extend this data model while maintaining consistent semantics.

So its time to start the installation and configuration. Wait for Oracle Fusion Applications installation details in next post

Cheers!!!

Glimpses of E-Business Suite 12.2: WebLogic Server and Online Patching

Finally 12.2 is on the way. Read more from Steven Chan blog
There are lots of updates coming in this release, but from a technology stack perspective, EBS 12.2 will be notable for two things:

1. Replacing Oracle Containers for Java (OC4J) 10g with WebLogic Server 11g
2. Online Patching support via 11gR2 Edition-Based Redefinition

Cheers!!!

ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments

Windows 2008 Enterprise
Oralce 11.2.0.2
After upgrade from 11.1.0.7 to 11.2.0.2 release, as part of R12 dbtier post-installation procedure, required to run adstats.sql and getting the following error

ERROR at line 1:
  ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments:
  [1350], [1], [23], [], [], [], [], [], [], [], [], []
  ORA-06512: at "SYS.DBMS_STATS", line 24098
  ORA-06512: at "SYS.DBMS_STATS", line 24629
  ORA-06512: at line 3
  ORA-06512: at line 33

Finally found the cause of the error, environment variable ORA_NLS10 not set even though successfully completed the  $ORACLE_HOME/nls/data/old/cr9idata.pl executed to create $ORACLE_HOME/nls/data/9idata from upgrade notes

set ORA_NLS10=%ORACLE_HOME%\nls\data\9idata

Retest the issue by running adstats.sql again .

adstats.sql should run successfully now.


Cheers!!!

Blank Page Accessing R12 - 'Missing class: _RF' in OACore application.log

On 12.0, trying to connect to the home page, which shows a blank page.

Further more, the application.log file of the OACore OC4J shows the following error stack:

javax.servlet.ServletException: oracle.classloader.util.AnnotatedClassNotFoundException:

Missing class: _RF

Dependent class: oracle.jsp.runtimev2.JspPageInfo
Loader: oc4j:10.1.3
Code-Source: /oracle/apps/tech_st/10.1.3/j2ee/home/lib/ojsp.jar
Configuration: code-source in META-INF/boot.xml in /oracle/apps/tech_st/10.1.3/j2ee/home/oc4j.jar

This load was initiated at oacore.web.html.jsp8892557:0.0.0 using the loadClass() method.

The missing class is not available from any code-source or loader in the system.
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:387) 
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478) 
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) 
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) 
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26) 
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) 
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318) 
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627) 
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376) 
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870) 
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451) 
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:299) 
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:187) 
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) 
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:230) 
at oracle.oc4j.network.ServerSocketAcceptHandler.access$800(ServerSocketAcceptHandler.java:33) 
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:831) 
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) 
at java.lang.Thread.run(Thread.java:595)

To solve this issue, there are two ways
1. Set the JSP compilation to Automatic
2. Recompile the JSP manually

How to set the JSP compilation to Automatic
Use the vi editor to edit the $CONTEXT_NAME.xml context file used by AutoConfig and change the value for "s_jsp_main_mode" from "justrun" to "recompile" (without the double quotes)

Backup the context file before editing it.

Run Autoconfig to propagate the changes to the configuration files.

Verify that now the
$INST_TOP/ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml has

init-param
[param-name]main_mode[/param-name]
[param-value]recompile[/param-value]
/init-param

Restart the Middle Tier services and access the applications to load JSP's which will cause them to be recompiled on the run.

After successfully accessing the applications, use the vi editor to edit the $CONTEXT_NAME.xml context file used by AutoConfig and revert the value for "s_jsp_main_mode" to "justrun" (without the double quotes) in order not to hamper the performance of your system.

Run AutoConfig to propagate the changes.

How to recompile the JSP manually

You can always use the this option to compile JSP's manually at any time.
Connect application tier using applmgr user and source the environment by running the script:

/oracle/apps/apps_st/appl/APPSSID_host.env

Run the commands
UNIX 
cd $FND_TOP/patch/115/bin
perl ojspCompile.pl --compile --flush -p 2

Windows
cd %FND_TOP%\patch\115\bin
- perl -x ojspCompile.pl –compile –flush

Restart the Middle Tier services.


Cheers!!!

Step by step process 11i to R12.1.1

Hi everybody, recently I have made complete iteration from fresh PROD 11i instance to R12.1.1 with database 11.2.0.2

I have used VMware for this iteration, the following step involved to achieve this upgrade from 11i to R12.1.1

OS – OEL 4.6
Memory 3GB
Instance 11i CU2
Database 9.2.0.6

My VMware installation has been running on P5 processor with 4GB memory under Windows 7 (64 bits) machine.
Before starting this iteration, I have enabled multi-org. So please follow multi-org enabled procedure prior to this step. 

The following steps performed successfully to complete this hectic upgrade from 11i instance to R12.1.1

•      Upgrade 9.2.0.6 to 10.2.0.4

–     Patches applied before 10g upgrade are 5478710, 4676589, 4653225

–     Changed some of the OS kernel parameters

–     Created new oracle home directory

–     Installed 10gR1 (software only)

–     Installed 10gR1 companion CD

–     Installed 10g patch set 3 (10.2.0.4)

•      Configuration section for 10g

–     Created nls/data/9idata

–     Run the script cr9idata.pl

–     Copied environment file from 9i home to 10g home and made changes to reflect the directory structure of 10g home

–     Copied TNS_ADMIN directory from 9i to 10 home and made changes according to new home

–     Copies admin directory from 9i to 10g home and make necessary changes

–     Shutdown 9i database and listener

–     Startup 10g listener

–     Upgraded  9i to 10g using dbua from 10g home

•      Shutdown database and listener

•      Create temporary tablespace

•      Apply RDBMS Patches

•      Fix Korean Lexers

•      Run Adgrants.sql

•      Grant create procedure privilege on CTXSYS

•      Implement and run Autoconfig

•      Gather statistics for SYS schema

•      Recreate grants and synonym for apps

•      Restart application server process

•      Preparing for the Upgrade R12.1.1

–     Apply AD.I.6

–     Apply TUMS utility

–     Run AD preparation scripts

Backup database and applications

•      Startup 11i Instance

•      Check for Invalid Objects etc...

•      Create R12 application user

•      Create R12 Base folder

•      OS  Kernel setting etc

•      (Refer Metalink: 761564.1  - Oracle E-Business Suite Installation and Upgrade Notes R12.1.1 for Linux x86)

•      Installation of R12.1.1 applications

•      Enable maintenance mode in R12

•      Apply AD 12.1.1 upgrade driver (7461070)

•      Source the R12 Applications environment file

•      Run the Patch Application Assistant

•      Run the adgrants.sql

•      Apply patch

•      Re-Create grants and Synonyms

•      Compile APPS schema

•      Modify tablespace

•      Run the American English upgrade patch driver 6678700

•      Review patch history and timing

•      Install R12.1.1 again for configuration purpose

•       Startup / shutdown applications and database

•       Try with autoconfig in both tiers

•       Restart services

•       Upgrade 10.2.0.4 to 11.2.0.2

•      Patches applied before  11gR2 upgrade are 9062910, 8919489, 9868229, 10024524

•      Autoconfig latest version with 9852070 and 9738085

•      OS kernel parameters for 11gR2

•      Created new oracle home directory

•      Installed 11gR2 (software only)

•      Installed 11g Examples CD

•       Configuration section for 11gR2

•      Created nls/data/9idata

•      Run the script cr9idata.pl

•      Copied environment file from 10g home to 11g home and made changes to reflect the directory structure of 11g home

•      Copied TNS_ADMIN directory from 10g to 11g home and made changes according to new home

•      Copies admin directory from 10g to 11g home and make necessary changes

•      Apply 11.2.0.2 RDBMS Patches – 4247037 and 10149223

•      Shutdown 10g database and listener

•      Startup 11g listener

•      Run  DBUA

•      Perform post-install instructions

•      Run adgrants.sql

•      Grant create procedure privilege on CTXSYS

•      Set CTXSYS parameter

•      Validate Workflow ruleset

•      Implement and run AutoConfig in the new Oracle home on the database server node.

•      Gather statistics for SYS schema

•      Re-create grants and synonyms

•      Restart Applications server processes

•      Synchronize Workflow views

Very detailed step-by-step notes with screen shot also prepared along with this iteration, if anybody looking for this iteration material or VMware copy don’t forget to drop me mail.

Cheers!!!

How to check if the Workflow Mailer is Running?

There are situations whether the Workflow Standalone Mailer processes are up & running without logging to the Application. Just follow the steps below

1. opmnctl status

2. Check the component container
ps -ef | grep OC4J_SECURITY

3. Is Java Mailer running ?
ps -ef | grep Service_Component_Container

or

SQL> select SC.COMPONENT_TYPE, SC.COMPONENT_NAME,
FND_SVC_COMPONENT.Get_Component_Status(SC.COMPONENT_NAME) COMPONENT_STATUS
from FND_SVC_COMPONENTS SC
order by 1, 2;


Cheers!!!

Guidance or Training for Oracle Apps, OBIEE 11g, .NET and Java

Wishing you a Happy New Year 2011.
As a new year offers to my readers, me and my friend would like to announce free training for first 5 students in Oracle Apps, OBIEE 11g, .NET and Java technology as part of their project or assignment to university courses.

Hurry....


Cheers!!!

How to reset root password in OEL 5.5

Recently one of my colleague forgotten his Linux OEL 5.5 box root password, so he have been successfully re-login his Linux with password reset option available under single user mode.

The steps involved in this procedure as follows

Restart Linux Machine

You are presented with a prompt that looks similar to the following:
 

If you use the default boot loader, GRUB, you can enter single user mode. To do so, at the boot loader menu, use the arrow keys to highlight the installation you want to edit and type [a] to enter into append mode.

Press the Spacebar once to add a blank space, and then add the word single to tell GRUB to boot into single-user Linux mode. The result should look like the following:

Grub append> ro root=LABEL=/  rhgb quiet / single

Press [Enter] and GRUB will boot single-user Linux mode. After it finishes loading, you will be presented with a shell prompt similar to the following:

sh-3.2#

You can now change the root password by typing

passwd root

You will be asked to re-type the password for verification. Once you are finished, the password will be changed.

Now you can restart your machine by typing init 6, this command will restart immediately

Cheers!!!

FNDCPASS Fails With "ORA-01017" Error When Changing Password with 11G Database

After upgrading to 12.0 and database from 10.2.0.2 to 11.1.0.6 getting 'ORA-01017' error when tried to change the application password using FNDCPASS utility.

The reason for this issue is that, database SEC_CASE_SENSITIVE_LOGON parameter defaults to TRUE in 11G.  When this occurs the password sensitivity conversion does not occur. Passwords that are input as lower case are automatically updated as upper case.  As a workaround set the parameter to FALSE in the init.ora, run autoconfig on application tiers and bounce the database.

Please refer Note 567116.1 Init.ora Parameter "SEC_CASE_SENSITIVE_LOGON"


Cheers!!!

R12 - How to enable Apache, OC4J and OPMN logging

Whenever raise SR with Oracle support for R12 application logging related issue, they will ask you to produce the logging details by enabling the Apache, OC4J and OPMN components and its services. Compared to 11i, Oracle Applications R12 introduces new easy way in order to enable logging for any of the components that are being used within it. The details about how to enable logging of these component you can also follow as explained in this post.

Oracle Configuration Home for Apache, OC4J & OPMN is
$ORA_CONFIG_HOME/10.1.3

Apache server is still being used and its configuration path is as following:
$ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf

but OC4J services, by default Oracle Applications R12 creates 3 OC4J instances:
1. OACore: runs OA Framework-based applications
2. Forms: runs Forms-base applications
3. OAFM (Oracle Apps Fusion Middleware): runs web services, mapviewer, ascontrol

Configuration files path for the above 3 OC4J instances is:
$ORA_CONFIG_HOME/10.1.3/j2ee/[oacore, forms, oafm]/config

Configuration file used to adjust log file path for the above 3 OC4J instances is:
$ORA_CONFIG_HOME/10.1.3/j2ee/[oacore, forms, oafm]/application-deployments/[oacore, forms, oafm]/orion-application.xml

Log files types:
Oracle Applications / E-Business Suite R12 can be configured to generate one of two types of logs files as following:

1. Plain text (default):
         - No log rotation available
         - Log files need to be manually removed
2. Oracle Diagnostics Logging (ODL) XML:
         - Logs rotation based on filesize, directory size
3. R12 logs by default are configured to generate plain text

Log files locations:
All log files are written in one home ( $LOG_HOME ) which is by default the (logs) directory under ($INST_TOP ).

Please note that after enbaling the logging for any of the following services you have to bounce the services in order the changes to take effect.

Steps to enable Apache logging:
Apache Logging ( Plain Text )

1) Edit the file $ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf/httpd.conf and set
LogLevel warn (s_apache_loglevel in context file)
2) Bounce the apache
3) Try to access the home URL or reproduce the issue.
4) Collect the following logfiles from $LOG_HOME/ora/10.1.3/Apache
  access_log.
  error_log.

Values that can be set to LogLevel variable in httpd.conf file
LogLevel = emerg,alert,crit,error,warn,notice,info,debug.

Apache Logging (ODL Logging)
1) Set the following parameters in file $ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf/httpd.conf
OraLogMode [oracle|odl|apache]
OraLogSeverity [message type]:[message level]

Message type: INTERNAL_ERROR, ERROR, WARNING, NOTIFICATION & TRACE
Message level: 1-32 (1 most severe, 32 least)
2) Bounce the apache
3) Try to access the home URL or reproduce the issue.
4) Collect the logfiles from $LOG_HOME/ora/10.1.3/Apache/oracle

Steps to enable OC4J logging:

Log file path is specified in the file
$ORA_CONFIG_HOME/10.1.3/j2ee/[oacore, forms, oafm]/application-deployments/[oacore, forms, oafm]/orion-application.xml

1. Open the file to set the following log level $ORA_CONFIG_HOME/10.1.3/j2ee/[oacore, forms, oafm]/config/j2ee-logging.xml
2. Come to the location located as
logger name=’oracle’ level=’NOTIFICATION:1‘ …..
3. Set the desired logging using following values
message type:message level
Message type: INTERNAL_ERROR, ERROR, WARNING, NOTIFICATION & TRACE
Message level: 1-32 (1 most severe, 32 least)
4. Locate the log file path from the file
$ORA_CONFIG_HOME/10.1.3/j2ee/[oacore, forms, oafm]/application-deployments/[oacore,forms,oafm]/orion-application.xml
(Will be identified with tag : log file path=… /log)
5. Bounce the OC4J instance and reproduce the issue
6. Collect the log files from the following locations .

Plain text
$LOG_HOME/ora/10.1.3/j2ee/[oacore, forms, oafm]/[oacore,forms,oafm]_[default_group_1]/application.log

ODL Log
$LOG_HOME/ora/10.1.3/j2ee/[oacore, forms, oafm]/[oacore,forms,oafm]_[default_group_1]/log.xml

Steps to enable OPMN logging:
There are 3 log files generated:
          - (opmn.log): contains commands, exit status
          - (opmn.dbg): contains debug log messages
          - (opmn.out): contains stdout & stderr messages

1) Open the file $ORA_CONFIG_HOME/10.1.3/opmn/conf/opmn.xml to set the logging parameter
2) Logging is enabled per component (internal, ons or pm)
3) Levels that can be set are (component codes) as following:
   none, fatal, error, warn, notify          (written to .log)
   debug1, debug2, debug3, debug4    (written to .dbg)
Ex :
  opmnctl set target=log comp=warn
  opmnctl set target=debug comp=debug1
4) Bounce opmn services and reproduce the issue
5) Collect the opmn log files generated in $LOG_HOME/ora/10.1.3/opmn
   opmn.log , opmn.dbg and opmn.out

NOTE : Logfiles can be enabled for rotation using parameter s_opmn_log_rotation_size, s_opmn_log_rotation_time in opmn.xml

Components (Services) Status & Logs:
1. You can check the status of the services/components by passing 'status' parameter to any AD script in $ADMIN_SCRIPTS_HOME.

adapcctl.sh status

2. The various logs written while starting and stopping the services are created in ($LOG_HOME/appl/admin/log/), the logs files are:

TNS Listener Start/Stop log                          - adalnctl.txt
Fulfillment Server Start/Stop log                    - jtffmctl.txt
Oracle HTTP Server start/stop log                 - adapcctl.txt
Concurrent Managers and ICM start/stop log - adcmctl.txt
Forms OC4J start/stop log                           - adformsctl.txt
OACore OC4J start/stop log                         - adoacorectl.txtq
OAFM OC4J start/stop log                           - adoafmctl.txt
OPMN start/stop log                                    - adopmnctl.txt

(adstpall.log) and (adstrtal.log) will record the messages while starting or stopping all services.
See also
how to enable and logging Apache, OC4J and OPMN
How to enable and logging Apache and Jserv in 11i

Cheers!!!

How to find the SID information for a running request

Always good to know the long running request SID information of apps for analysis and troubleshoot purpose. The following query will help to identify that, pass long running 'request id' as parameter

SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process c,
v$session d
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid
AND a.request_id = &Request_ID
AND a.phase_code = 'R';


Cheers!!!

How to Relink Oracle Database Software

Its better to know the relinking of oracle software manually when there is a situation like

• An OS upgrade has occurred.
• A change has been made to the OS system libraries.  This can occur during the application of an OS patch.
• A new install failed during the relinking phase.
• Individual Oracle executables core dump during initial startup.
• An individual Oracle patch has been applied.

So, relinking Oracle manually is suggested way under the above circumstances.

Those who want to (or have been advised to) manually relink should follow the procedure below.

Step 1 - Log into the UNIX system as the Oracle software owner
Typically this is the user 'oracle'.

STEP 2 - Verify that your $ORACLE_HOME is set correctly:
echo $ORACLE_HOME

Step 3 - Verify and/or Configure the UNIX Environment for Proper Relinking
Set LD_LIBRARY_PATH to include $ORACLE_HOME/lib

Step 4 - For all Oracle Versions and UNIX Platforms:
Verify that you performed Step 2 correctly:

env|pg  ....make sure that you see the correct absolute path for
$ORACLE_HOME in the variable definitions.

Step 5 - For all Oracle Versions and UNIX Platforms:
Verify umask is set correctly:
umask

This must return 022.  If it does not, set umask to 022.
umask 022
umask

Step 6 - Run the OS Commands to Relink Oracle:

Before relinking Oracle, shut down both the database and the listener.
The following commands will output a lot of text to your session window.  To capture this output for upload to support, redirect the output to a file.

For all UNIX platforms:

Oracle 7.3.x 
For executables:  oracle, exp, imp, sqlldr, tkprof

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk install

For executables:  svrmgrl, svrmgrm

cd $ORACLE_HOME/svrmgr/lib
make -f ins_svrmgr.mk linstall minstall (linstall is for svrmgrl, minstall is for svrmgrm)

For executables:  sqlplus

cd $ORACLE_HOME/sqlplus/lib
make -f ins_sqlplus.mk install

For executables:  dbsnmp, oemevent, oratclsh

cd $ORACLE_HOME/network/lib
make -f ins_agent.mk install

For executables:  names, namesctl

cd $ORACLE_HOME/network/lib
make -f ins_names.mk install

For executables:  tnslsnr, lsnrctl, tnsping, csmnl, trceval, trcroute

cd $ORACLE_HOME/network/lib
make -f ins_network.mk install

Oracle 8.0.x 
For executables:  oracle, exp, imp, sqlldr, tkprof, mig, dbv, orapwd, rman, svrmgrl, ogms, ogmsctl

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk install

For executables:  sqlplus
cd $ORACLE_HOME/sqlplus/lib
make -f ins_sqlplus.mk install

For executables:  dbsnmp, oemevent, oratclsh, libosm.so

cd $ORACLE_HOME/network/lib
make -f ins_oemagent.mk install

For executables:  tnslsnr, lsnrctl, namesctl, names, osslogin, trcasst, trcroute

cd $ORACLE_HOME/network/lib
make -f ins_network.mk install

Oracle 8.1.X, 9.X.X, 10.X.X or 11.X.X
*** NEW IN 8i AND ABOVE ***
A 'relink' script is provided in the $ORACLE_HOME/bin directory.
cd $ORACLE_HOME/bin
relink    
...this will display all of the command's options.
usage: relink
accepted values for parameter: all, oracle, network, client,  client_sharedlib, interMedia, precomp, utilities, oemagent, ldap

relink all  

11.2.X special instructions

In 11.2 relink script will only accept "all" as argument
 -or-
Since the 'relink' command merely calls the traditional 'make' commands, you still have the option of running the 'make' commands independently:

For executables:  oracle, exp, imp, sqlldr, tkprof, mig, dbv, orapwd, rman, svrmgrl, ogms, ogmsctl
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk install

NOTE: After relinking the oracle executable, make sure that the  permissions on the executable are 6751 (-rwsr-s--x). If they are not, run the following command as the Oracle software owner:
cd $ORACLE_HOME/bin
chmod 6751 oracle

For executables:  sqlplus
cd $ORACLE_HOME/sqlplus/lib
make -f ins_sqlplus.mk install

For executables:  isqlplus   (Oracle9i and higher versions)

cd $ORACLE_HOME/sqlplus/lib
make -f ins_sqlplus.mk install_isqlplus

For executables:  dbsnmp, oemevent, oratclsh

cd $ORACLE_HOME/network/lib
make -f ins_oemagent.mk install

NOTE: After relinking the dbsnmp executable, it is necessary to run the following commands as root (so that the ownership/permissions on the executable are correct):

# cd $ORACLE_HOME/bin
# chown root dbsnmp
# chmod 6750 dbsnmp

For executables:  names, namesctl

cd $ORACLE_HOME/network/lib
make -f ins_names.mk install

For executables:  osslogin, trcasst, trcroute, onrsd, tnsping

cd $ORACLE_HOME/network/lib
make -f ins_net_client.mk install

For executables:  tnslsnr, lsnrctl

cd $ORACLE_HOME/network/lib
make -f ins_net_server.mk install

For executables related to ldap (for example Oracle Internet Directory):

cd $ORACLE_HOME/ldap/lib
make -f ins_ldap.mk install

How to Tell if Relinking Was Successful:

If relinking was successful, the make command will eventually return to the OS prompt without an error. There will NOT be a 'Relinking Successful' type message.

If You Receive an Error Message During Relinking:
Confirm that the message you received is an actual fatal error and not a  warning. Relinking errors usually terminate the relinking process and contain verbage similar to the following:
'Fatal error', 'Ld: fatal', 'Exit Code 1'
While warnings will look similar to: 'ld: warning: option -YP appears more than once, first setting taken' and can most often be ignored.

If you receive an error that terminates the relinking process, your first step should be to extract the relevant information about the error from the make output:

This can be broken down into three basic steps:
1. Identify the OS utility that is returning the error.
    'ld', 'make', 'cc', 'mv', 'cp', 'ar' are common sources.
2. Identify the type of error:
    'Permission Denied', 'Undefined Symbol', 'File Not Found' are common types.
3. Identify the files or symbols involved.


Cheers!!!

Startup/Shutdown process of OBIEE 11g on Linux

As I have promised earlier post, I am writing the startup steps of OBIEE 11g on linux box. Before that make sure that FMW(Fusion Middle Ware) Repository database and the listener are up and running. If database status is running, we can start. Or else start the database and  listener now.

First step is to start the Weblogic server. As you may have noticed that the directory structures are totally different, so it will take sometime to get used with the new scripts and directories.

Startup scripts are located under $FMW_HOME/user_projects/domains/bifoundation_domain/bin

Setting the environment by running these two script
$ . setOBIDomainEnv.sh
$ . setDomainEnv.sh

Now you can startup the WLS:

Use the script startWeblogic.sh as shown below to start the WLS

. startWebLogic.sh -Dweblogic.managment.username=weblogic -Dweblogic.management.password=weblogic1 &

weblogic and weblogic1 are the username and password I have given during the OBIEE 11g installation. Make sure you use “&” at the end of the command so that the script runs in the background

2. Once WLS running status, you can Login to WLS Console:

Default port to login to the console is 7001 unless different ones are specified during the installation

Now goto http://[BIserver]:7001/em to access the enterprise manager to startup the rest of the services

Select from the menu Weblogic Server –> Control –> Startup to start the service

3. NodeManager – Node manager is a java utility that allows us to perform operations such as startup and shutdown for  Managed Server. So in order for us to remotely startup the bi_server we need the node manager utility up and running

Now to startup node manager, get back to a telnet session and go to $WLS_HOME/server/bin directory

Set environment

Run the script setWLSEnv.sh

$ . setWLSEnv.sh

Starting Nodemanager

$ . startNodeManager.sh &

Next is startup opmn services

cd $FMW_HOME/instances/instance1/bin
$ . opmnctl startall

Now Lets' try analytics url


Cheers!!!