Create Database Using DBCA In Oracle 11G

Create Database Using DBCA In Oracle 11G
This is the simplest way to create database in oracle database. Follow below given steps to create database.


First login using oracle system user using GUI Console and then execute dbca command



Now Select Create Database



Select Type Of Database You want to create



Now give Database Name SID name will be same as database name.



Select appropriate option



Create Listener if you get this Error or Warning



Give Password you want



This is just password policy warning can configured as per your need



Now Select Database File Location



Check file location using File Location Variables



Now specify flash recovery area



Check if you want sample schema



Now give Memory Details etc



Click Next



Now select Finish



Ok



Now Installation will start





Now Select EXIT



Now Database is created . You can login to database and verify



Now Database is created properly

Original post - link

Create Database Manually In Oracle 11G On Linux

Create Database Manually In Oracle 11G On Linux

Here we will explore how to create database manually in Oracle 11G. Although there is a utility available called as DBCA using which you can create database with ease but i will recommend you to create it manually doing so we will know where we have kept all the configuration files etc.

Below are some highlights of steps involved in creating database manually.

1. create pfile , password file for new database
2. Create necessary directories
3. create instance and start database in nomount mode
4. use create database to create new database
5. Run necessary scripts file to create data dictonary table
6. Testing newly created database and registering to listener

First Login as ORACLE OS USER.



Now goto $ORACLE_HOME/dbs location and copy the content of init.ora into file name you want to create





Now open initzahid.ora and make the necessary changes as per your need.



Now as per changes you have made. make sure you have created necessary folders given in the path. if not then create.



Now goto path and check if the necessary folders has been created.



Now open /etc/oratab file and make entry of database name and $ORACLE_HOME location.





Now set the environment path for zahid database. you can simply do it by executing oraenv command.



Now create a password file for sys user.



Once password file is created you can login to database and check.



Now you can start listener services if you want else it can be configure later also.



Now login to database and start the database using pfile you have created.



Now you can create spfile from pfile if you want. Major different using spfile over pfile is that you can make online changes in configuration file how ever in pfile you have to restart database for any global changes.



Now check if the spfile has been created or not.



Now all the configuration part has been completed Now you can execute create database command.I have created a script to create database you can execute this command on sql prompt also.

Now login to oracle and execute zahid.sql file to create database.





Now database has been created

Now import various catalog file to database









Once these catalogs are imported you can check if the database is mounted properly and it is opened in read write mode or not



Now you can once restart database services and test



Now come out of database and check if all the processes are running properly or not.



Since all the processes are running properly Database has been created successfully.

Original post -Link

OEM: The database is down. Please specify the host credentials to access database restart and diagnostics tools.

OEM: The database is down. Please specify the host credentials to access database restart and diagnostics tools

We recently faced this issue on "Oracle Enterprise manager" on one of our testing environments

Oracle Enterprise manager is showing following message as in above image:
The database is down. Please specify the host credentials to access database restart and diagnostics tools.

I debugged it with following steps

1) Check Database is open or Not

C:\Windows\system32>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 6 02:35:33 2015
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select status from v$instance;
STATUS
------------
OPEN

2) Check listener is running properly

C:\Windows\system32>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.4.0 - Production on 06-FEB-2015 02:36:16
Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mydbhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.4.0 - Production
Start Date                05-FEB-2015 14:11:28
Uptime                    0 days 12 hr. 24 min. 47 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   E:\myorcl\Database\myorclDB\NETWORK\ADMIN\listener.ora
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mydbhost)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status READY, has 1 handler(s) for this service...
Service "myorcl" has 1 instance(s).
  Instance "myorcl", status READY, has 1 handler(s) for this service...
Service "myorclXDB" has 1 instance(s).
  Instance "myorcl", status READY, has 1 handler(s) for this service...
The command completed successfully

3) check status of emctl

C:\Windows\system32>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
https://mydbhost:5500/em/console/aboutApplication

Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory 
E:\myorcl\Database\myorclDB/mydbhost/sysman/log

4) check emoms.log logs
E:\myorcl\Database\myorclDB\mydbhost_myorcl\sysman\log\emoms.log

java.sql.SQLException: ORA-28000: the account is locked

5) Check Account Status of SYSTEM, SYSMAN and DBSNMP users

C:\Windows\system32>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 6 02:37:57 2015
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select username, account_status from dba_users where username in ('SYSTEM','SYSMAN','DBSNMP');

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------
DBSNMP                         OPEN
SYSTEM                         OPEN
SYSMAN                         LOCKED(TIMED)

By above steps I was sure that Database was functioning normally, the problem was with SYSMAN user being locked. Oracle use SYSMAN user as a default super-user account to administrator Oracle Enterprise manager and stores the Oracle Management Repository in SYSMAN schema. SYSMAN password is stored in encrypted format in files which are used by OEM, We need to unlock SYSMAN user and change password of SYSMAN.

I use following Oracle documentation to change the password of SYSMAN
https://docs.oracle.com/cd/B19306_01/em.102/b40002/repository.htm#i1029558

Here are the steps I follow to resolve the issue

1) Stop Enterprise Manager Database Console

C:\Windows\system32>emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
https://mydbhost:5500/em/console/aboutApp
lication
The OracleDBConsolemyorcl service is stopping..........
The OracleDBConsolemyorcl service was stopped successfully.

2) Connect to SYS user as SYSDBA

C:\Windows\system32>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 6 02:37:57 2015
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

3) Unlock the SYSMAN account and change password

SQL> alter user sysman account unlock;
User altered.

SQL> alter user SYSMAN identified by "NEW_SYSMAN_PASSWORD";
User altered.

4) locate and open the emoms.properties configuration file, in our case it was at
E:\myorcl\Database\myorclDB\mydbhost_myorcl\sysman\config\emoms.properties

5) change following entries value in the "emoms.properties" file:

    orcle.sysman.eml.mntr.emdRepPwd=NEW_SYSMAN_PASSWORD (in plain text)
    orcle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE (true to false)

6) In some cases you may need to edit "targets.xml" file too, which is located at
E:\myorcl\Database\myorclDB\mydbhost_myorcl\sysman\emd\targets.xml

7) change following entries value in the "targets.xml" file:

        <Property NAME="UserName" VALUE="SYSMAN" ENCRYPTED="FALSE"/>
        <Property NAME="password" VALUE="NEW_SYSMAN_PASSWORD" ENCRYPTED="FALSE"/>

8) Start Enterprise Manager Database Console

C:\Windows\system32>emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
https://mydbhost:5500/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...The OracleDBConsolemyorcl service is starting..................
The OracleDBConsolemyorcl service was started successfully.

All Done, and Oracle Enterprise Manager was not running properly :)

I really hope you all have enjoyed and learnt/revisited something from this demonstration on the OEM issue and how to change SYSMAN password. Don't forget to put your feedback as comments, they are really valuable.

How to clear server cache

How to clear server cache

Whenever you bounce the apache server, you need to clear the server side cache, so that those cached pages will not be used again.(these are code cache not data). The cache files are stored under $OA_HTML/_pages/_oa__html folder in the web/apps node.

1. Stop the apache listener - see below for command
2. Clear Cache

You do this by changing to directory $OA_HTML/_pages/_oa__html (for 11.5.5 - 11.5.9) or $COMMON_TOP/_pages/_oa__html (for 11.5.10) and then issue:

rm -rf *

Take a backup before removing.

3. Start the apache listener - see below for command

Start and Stop the Apache http listener
The 11i Rapid install provides a start/stop script for the Apache server.
This script is located in COMMON_TOP/admin/scripts and is called adapcctl.sh.

To start the Apache http listener processes, log on as the user that installed Oracle Applications (single node) or the user that installed the Oracle Applications web tier (multi-node). Change directories to $COMMON_TOP/admin/scripts and type the following:

adapcctl.sh start (to start the Apache http listener processes)
adapcctl.sh stop (to stop the Apache http listener processes)

Copy table from one database to another

Copy table from one database to another

Login as SYS

SQL> copy from scott/tiger@orcl to exam2/exam2@orcl create new_emp using select * from emp where 1=2;

Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)
Table NEW_EMP created.

   0 rows selected from scott@orcl.
   0 rows inserted into NEW_EMP.
   0 rows committed into NEW_EMP at exam2@orcl.

SQL>

Steps for getting The FND Debug Log For Concurrent request

Steps for getting The FND Debug Log For Concurrent request

1) From a System Administrator responsibility
Navigation path: Profile -> System

a) Set the following profile option at SITE level:
FND: Diagnostics -> Yes

b) Set the following profile options at USER level:
FND: Debug Log Module -> %
FND: Debug Log Enabled -> Yes
FND: Debug Log Level -> Statement

2) Run the concurrent request.

3) Upload the log and output files which can be found in the following UNIX directories:

cd $<product>_TOP/log

cd $<product>_TOP/out Both files can be found using the request_id.

4) Upload the spool file of the following script in an EXCEL spreadsheet with column headings for readability.
--- --- ---
SELECT log.module, log.message_text
FROM FND_LOG_MESSAGES LOG,
FND_LOG_TRANSACTION_CONTEXT CON
WHERE CON.TRANSACTION_ID = '&con_request_id'
AND CON.TRANSACTION_TYPE = 'REQUEST'
AND CON.TRANSACTION_CONTEXT_ID = LOG.TRANSACTION_CONTEXT_ID
ORDER BY LOG.LOG_SEQUENCE;
--- --- ---

How to get out of the Linux Filesystem repair prompt after repairing the filesystem?

How to get out of the Linux Filesystem repair prompt after repairing the filesystem?

"shows me repair file system in red color"

This is the key: the filesystem is corrupted, probably due to an unclean shutdown. It needs to be repaired. Try entering the root password, which should give you a '#' prompt.
 
Type:
fsck -A -y
That will take a while and print out something about what it's fixing.
 
Once that has completed, type "exit".
You may need to restart the system again.

Linux: How to monitor the nproc limit

Linux: How to monitor the nproc limit

You probably know about 'nproc' limits in Linux which are set in /etc/limits.conf and checked with 'ulimit -u'. But do you know how to handle the monitoring and be alerted when you're close the fixed limit?

Nproc and ps
Nproc is defined at OS level to limit the number of processes per user. Oracle 11.2.0.4 documentation recommends the following:

oracle soft nproc 2047
oracle hard nproc 16384
 
But that is often too low, especially when you have the Enterprise Manager agent or other java programs running.

Do you want to check that you are far from the limit? then you can use 'ps'. But beware, 'ps' by default does not show all processes.
 
In Linux, when doing multithreading, each thread is implemented as a light-weight process (LWP). And you must use the '-L' to see all of them.

Let's take an example. I have a system where 'ps -u oracle' returns 243 lines. But including LWPs shows a lot more processes which is near the limit:

$ ps h -Led -o user | sort | uniq -c | sort -n
      1 dbus
      1 ntp
      1 rpc
      1 rpcuser
      2 avahi
      2 haldaemon
      2 postfix
    166 grid
    400 root
   1370 oracle
 
So the 'oracle' user has 1370 processes. That's high. And this is the actual number where the nproc limit applies.

'ps -Lf' can show the detail. And even without '-L' we can display the NLWP which is the number of threads per process:

ps -o nlwp,pid,lwp,args -u oracle | sort -n
NLWP   PID   LWP COMMAND
   1  8444  8444 oracleOPRODP3 (LOCAL=NO)
   1  9397  9397 oracleOPRODP3 (LOCAL=NO)
   1  9542  9542 oracleOPRODP3 (LOCAL=NO)
   1  9803  9803 /u00/app/oracle/product/agent12c/core/12.1.0.3.0/perl/bin/perl /u00/app/oracle/product/agent12c/core/12.1.0.3.0/bin/emwd.pl agent /u00/app/oracle/product/agent12c/agent_inst/sysman/log/emagent.nohup
  19 11966 11966 /u00/app/11.2.0/grid/bin/oraagent.bin
1114  9963  9963 /u00/app/oracle/product/agent12c/core/12.1.0.3.0/jdk/bin/java ... emagentSDK.jar oracle.sysman.gcagent.tmmain.TMMain
 
The Oracle 12c EM agent has started 1114 threads and the grid infrastructure 'oraagent.bin' has 19 threads. In addition to that I've a lot of other monothreaded processes. This is how we reach 1370 which is the exact value to compare to the nproc limit.

So what are the good values to set? About the high number of threads for EM agent 12c, there are a few bugs. And I suspect that 1000 threads is too much, especially when checking them with 'jstack' I see that they are "CRSeOns" threads that should not be used in 11.2.0.2 and higher. But that's another problem which I'm currently investigating. When you reach the nproc limit, the user will not be able to create new processes. clone() calls will return EAGAIN and that is reported by Oracle as:

ORA-27300: OS system dependent operation:fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
And that is clearly bad when it concerns an +ASM instance or archiver processes.

The goal of the nproc limit is only to prevent 'fork bombs' where a process forks forever and exhausts all resources. So there is no problem to increase this limit. However if you set it high for some users ('oracle' and 'grid' usually), it can be a good idea to monitor the number of processes with the ps h -L above. Because having too many processes is suspect and increasing the limit just hides a process leak and defer the failure.

In 'ps h -L -o' The argument 'h' is there to remove the header line, and '-L' to show all processes including LWP. Then you can count with 'wc -l'.

The proof
In order to be sure that 'ps h -L' gives the exact number, I have tested it. In case you want to check this on your system, here is how to do it. And please report any difference.

First, set your limit to 1024 processes. This is a limit for my user, and the limit is set for my shell and all its child processes:

[oracle@VM211 ocm]$ ulimit -u 1024
Now you can check it:

[oracle@VM211 ocm]$ ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 15919
max locked memory       (kbytes, -l) 64
max memory size         (kbytes, -m) unlimited
open files                      (-n) 1024
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 10240
cpu time               (seconds, -t) unlimited
max user processes (-u) 1024
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited

[root@VM211 ocm]# ps h -Lu oracle | wc -l
1023
 
Recommended values for Oracle
Currently this is what is set on Oracle linux 6 for 11gR2 by the preinstall package (in /etc/security/limits.conf):

oracle   soft   nproc    16384
oracle   hard   nproc    16384

For 12c, these are set in /etc/security/limits.d/oracle-rdbms-server-12cR1-preinstall.conf which overrides /etc/security/limits.conf:

oracle soft nproc 16384
oracle hard nproc 16384
And just for your information, here is what is set in the ODA X4-2:

oracle soft nproc 131072

So what do you want to set? You probably don't want it too low and experience 'resource temporarily unavailable'. But what you don't want either is 100000 processes on your server. So my recommendation is to set it high but monitor it when the number of processes reaches something that is not sensible. Then you prevent having the system down in case of process leak, but you can detect it and ask for a patch.

Special thanks to Mr. Franck Pachot for such easy illustration.
Regards
Shahzad

Concurrent Manager status: "System Hold, Fix Manager"

Concurrent Manager status: "System Hold, Fix Manager"

Solution:

1) Shutdown the Apps Tier cleanly make sure there are no sessions: ps -ef | grep FNDLIBR
 
2) go to cd $FND_TOP/bin
run the below commands:
$ adrelink.sh force=y link_debug=y “fnd FNDLIBR”
$ adrelink.sh force=y link_debug=y “fnd FNDFS”
$ adrelink.sh force=y link_debug=y “fnd FNDCRM”
$ adrelink.sh force=y link_debug=y “fnd FNDSM”

Check relink logs to make sure the relinks completes sucessfully.

Ex: adrelink is exiting with status 0
End of adrelink session Date/time is  Mon Apr 23 10:50:24 PST 2013 **********************************************************
Line-wrapping log file for readability … Done line-wrapping log file.
Original copy is  /../…/../adrelink.lsv New copy is /../../../../../adrelink.log3)

3. After running the relinks run the cmclean.sql to flush out the status of the CM’s.
Don't forget to commit.

SQL> sqlplus apps/

SQL> @cmclean.sql
DOC>
———————————————————————– Updates complete. Type commit now to commit these updates, or rollback to cancel. ———————————————————————–
SQL> commit;
Commit complete.
 
4) Now Restart the Apps tier:

Notes:
Manager Status Shows System Hold, Fix Manager before resetting counters [ID 1507580.1] Concurrent Processing – CMCLEAN.SQL – Non Destructive Script to Clean Concurrent Manager Tables [ID 134007.1]

ORAchk Health Checks For The Oracle Stack (ORACHK 2.2.4 and above)

ORAchk Health Checks For The Oracle Stack (ORACHK 2.2.4 and above)
Posted: 18/03/2014 | Author: Levi Pereira | Filed under: 10g R1, 10g R2, 11g R1, 11g R2, 12c R1, ASM - Automatic Storage Management, Clusterware / Grid Infrastructure, Database, My Oracle Support (Metalink), Oracle |Leave a comment

Oracle Database 12c (12.0.1.*) and 11g (11.2.0.4) comes with new feature called RACcheck.
Although the RACcheck already exists before these releases. (In 2011 I posted about benefits of RACcheck)

Brief of RACcheck.
.....

RACcheck - The Oracle RAC Configuration Audit Tool
RACcheck is designed to audit vital configuration settings for the Oracle Database, single instance databases, as well as Oracle Real Application Clusters (Oracle RAC) databases. It also includes checks for Oracle Clusterware, Oracle Automatic Storage Management (Oracle ASM) and Oracle Grid Infrastructure.

RACcheck provides best practices recommedations considering the whole stack, including Maximum Availability Architecture (MAA) configurations and is therefore the ideal tool for regular health checks as well as pre- and post-upgrade best practices assessments.
.....

Now Oracle replace/renamed Oracle RACcheck to ORAchk.

ORAchk- Health Checks for the Oracle Stack

ORAchk replaces the popular RACcheck to support a wider range of products. ORAchk version 2.2.4 is now available for download and includes the following key features:

RACcheck renamed to ORAchk

ORAchk daemon auto-start mode after node reboot (init integration)

Merge multiple ORAchk collection reports

Upload of installed patches to database

Collection Manager for ORAchk, RACcheck and Exachk (Document 1602329.1)

ORAchk signature file in /tmp on all nodes to verify last ORAchk run

New checks and bug fixes, including

30 Oracle Ebusiness AP module data integrity checks

12 new Database checks

8 new Solaris system checks

Supported Platforms

Linux x86-64* (Enterprise Linux, RedHat and SuSE 9, SuSE 10 & SuSE 11)

Oracle Solaris SPARC (Solaris 10 and 11)

Oracle Solaris x86-64 (Solaris 10 and 11)

AIX **

HPUX**

* 32-bit platforms not supported, no planned support for Linux Itanium
**Requires BASH Shell 3.2 or higher to be installed

Supported Oracle Releases

10gR2

11gR1

11gR2

12cR1

When to Run ORAchk

After initial Oracle RAC deployment

Before planned system maintenance

After planned system maintenance

At least once every three months

Install/Configure

It is recommended to run the tool as the database software owner (e.g. oracle). The user may run the tool as the Grid Infrastructure software owner (e.g. grid) and it will collect the same data but database credentials must manually be supplied to perform the database related audit checks. Typically when run as oracle the customer will have OS authentication set up for the oracle database software owner and the database login credentials will not be needed.

Download ORAchk

Stage Location:
It is recommended that the kit be staged and operated from a local filesystem on a single database server in order to provide the best performance possible.

$ mkdir -p /u01/app/oracle/orachk

[oracle@node11g01 install]$ cd /u01/app/oracle/orachk

[oracle@node11g01 orachk]$ unzip orachk.zip
Archive: orachk.zip
inflating: raccheck
inflating: rules.dat
inflating: collections.dat
inflating: readme.txt
inflating: orachk
creating: .cgrep/
inflating: .cgrep/ogghc_12101.sql
inflating: .cgrep/lcgrep4
inflating: .cgrep/checkDiskFGMapping.sh
inflating: .cgrep/ogghc_11204.sql
inflating: .cgrep/lcgreps9
inflating: .cgrep/ogghc_11203.sql
inflating: .cgrep/scgrepx86
inflating: .cgrep/acgrep
inflating: .cgrep/oracle-upstarttmpl.conf
inflating: .cgrep/check_reblance_free_space.sql
inflating: .cgrep/CollectionManager_App.sql
inflating: .cgrep/exalogic_zfs_checks.aksh
inflating: .cgrep/hiacgrep
inflating: .cgrep/init.tmpl
inflating: .cgrep/lcgreps10
inflating: .cgrep/preupgrd.sql
inflating: .cgrep/diff_collections.pl
inflating: .cgrep/merge_collections.pl
inflating: .cgrep/ggdiscovery.sh
creating: .cgrep/profiles/
inflating: .cgrep/profiles/DA94919CD0DE0913E04312C0E50A7996.prf
inflating: .cgrep/profiles/D49C0FBF8FBF4B1AE0431EC0E50A0F24.prf
extracting: .cgrep/profiles/F13E11974A282AB3E04312C0E50ABCBF.prf
inflating: .cgrep/profiles/EF6C016813C51366E04313C0E50AE11F.prf
inflating: .cgrep/profiles/D8367AD6754763FEE04312C0E50A6FCB.prf
inflating: .cgrep/profiles/DF65D6117CB41054E04312C0E50A69D1.prf
inflating: .cgrep/profiles/EA5EE324E7E05128E04313C0E50A4B2A.prf
inflating: .cgrep/profiles/E1BF012E8F210839E04313C0E50A7B68.prf
inflating: .cgrep/profiles/D462A6F7E9C340FDE0431EC0E50ABE12.prf
inflating: .cgrep/profiles/D49AD88F8EE75CD8E0431EC0E50A0BC3.prf
inflating: .cgrep/profiles/E2E972DDE1E14493E04312C0E50A1AB1.prf
inflating: .cgrep/profiles/F32F44CE0BCD662FE04312C0E50AB058.prf
inflating: .cgrep/profiles/E8DF76E07DD82E0DE04313C0E50AA55D.prf
inflating: .cgrep/profiles/D49B218473787400E0431EC0E50A0BB9.prf
inflating: .cgrep/profiles/D49C0AB26A6D45A8E0431EC0E50ADE06.prf
inflating: .cgrep/profiles/DFE9C207A8F2428CE04313C0E50A6B0A.prf
inflating: .cgrep/profiles/D49C4F9F48735396E0431EC0E50A9A0B.prf
inflating: .cgrep/profiles/D49BDC2EC9E624AEE0431EC0E50A3E12.prf
inflating: .cgrep/profiles/DF65D0F7FB6F1014E04312C0E50A7808.prf
inflating: .cgrep/scnhealthcheck.sql
inflating: .cgrep/pxhcdr.sql
inflating: .cgrep/lcgrep5
inflating: .cgrep/scgrep
inflating: .cgrep/raw_data_browser.pl
inflating: .cgrep/profiles.dat
inflating: .cgrep/rack_comparison.py
inflating: .cgrep/versions.dat
inflating: .cgrep/create_version.pl
inflating: .cgrep/lcgreps11
inflating: .cgrep/utluppkg.sql
inflating: .cgrep/utlusts.sql
inflating: .cgrep/reset_crshome.pl
inflating: .cgrep/asrexacheck
inflating: .cgrep/lcgrep6
inflating: .cgrep/utlu112i.sql
inflating: UserGuide.txt
Running ORAchk Interactively 

[oracle@node11g01 orachk]$ ./orachk

CRS stack is running and CRS_HOME is not set. Do you want to set CRS_HOME to /u01/app/11.2.0/grid?[y/n][y]

Checking ssh user equivalency settings on all nodes in cluster

Node node11g02 is configured for ssh user equivalency for oracle user

Searching for running databases . . . . .

. .
List of running databases registered in OCR
1. dborcl
2. None of above

Select databases from list for checking best practices. For multiple databases, select 1 for All or comma separated number like 1,2 etc [1-2][1].1
. .

Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
-------------------------------------------------------------------------------------------------------
Oracle Stack Status
-------------------------------------------------------------------------------------------------------
Host Name CRS Installed ASM HOME RDBMS Installed CRS UP ASM UP RDBMS UP DB Instance Name
-------------------------------------------------------------------------------------------------------
node11g01 Yes Yes Yes Yes Yes Yes dborcl_1
node11g02 Yes Yes Yes Yes Yes Yes dborcl_2
-------------------------------------------------------------------------------------------------------

Copying plug-ins

. . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . .

17 of the included audit checks require root privileged data collection . If sudo is not configured or the root password is not available, audit checks which require root privileged data collection can be skipped.

1. Enter 1 if you will enter root password for each host when prompted

2. Enter 2 if you have sudo configured for oracle user to execute root_orachk.sh script

3. Enter 3 to skip the root privileged collections

4. Enter 4 to exit and work with the SA to configure sudo or to arrange for root access and run the tool later.

Please indicate your selection from one of the above options for root access[1-4][1]:- 2

*** Checking Best Practice Recommendations (PASS/WARNING/FAIL) ***

Collections and audit checks log file is
/u01/app/oracle/orachk/orachk_node11g01_dborcl_031814_170552/log/orachk.log
.
.
.
.
---------------------------------------------------------------------------------
CLUSTERWIDE CHECKS
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

Detailed report (html) - /u01/app/oracle/orachk/orachk_node11g01_dborcl_031814_170552/orachk_node11g01_dborcl_031814_170552.html

UPLOAD(if required) - /u01/app/oracle/orachk/orachk_node11g01_dborcl_031814_170552.zip

Below the report generated in this test.
Oracle RAC Assessment Report

orachk usage options 

[oracle@node11g01 orachk]$ ./orachk -h
Usage : ./orachk [-abvhpfmsuSo:c:t:]
-a All (Perform best practice check and recommended patch check)
-b Best Practice check only. No recommended patch check
-h Show usage
-v Show version
-p Patch check only
-m exclude checks for Maximum Availability Architecture (MAA) scorecards(see user guide for more details)
-u Run orachk to check pre-upgrade or post-upgrade best practices for 11.2.0.3,11.2.0.4.0 and 12.1.0.1
-o pre or -o post is mandatory with -u option like ./orachk -u -o pre
-f Run Offline.Checks will be performed on data already collected from the system
-o Argument to an option. if -o is followed by v,V,Verbose,VERBOSE or Verbose, it will print checks which passs on the screen
if -o option is not specified,it will print only failures on screen. for eg: orachk -a -o v

-clusternodes
Pass comma separated node names to run orachk only on subset of nodes.
-dbnames
Pass comma separated database names to run orachk only on subset of databases
-localonly
Run orachk only on local node.
-debug
Run orachk in debug mode. Debug log will be generated.
eg:- ./orachk -debug
-nopass
Skip PASS'ed check to print in orachk report and upload to database.

-noscore
Do not print healthscore in HTML report.

-diff [-outfile ]
Diff two orachk reports. Pass directory name or zip file or html report file as &

-exadiff
Compare two different Exalogic rack and see if both are from the same release.Pass directory name or zip file as & (applicable for Exalogic only)

-c Used only under the guidance of Oracle support or development to override default components

-
initsetup : Setup auto restart. Auto restart functionality automatically brings up orachk daemon when node starts
initrmsetup : Remove auto restart functionality
initcheck : Check if auto restart functionality is setup or not
initpresetup : Sets root user equivalency for COMPUTE, STORAGE and IBSWITCHES.(root equivalency for COMPUTE nodes is mandatory for setting up auto restart functionality)

-d
start : Start the orachk daemon
start_debug : Start the orachk daemon in debug mode
stop : Stop the orachk daemon
status : Check if the orachk daemon is running
info : Print information about running orachk daemon
stop_client : Stop the orachk daemon client
nextautorun : print the next auto run time
-daemon
run orachk only if daemon is running
-nodaemon
Dont use daemon to run orachk
-set
configure orachk daemon parameter like "param1=value1;param2=value2... "

Supported parameters are:-

AUTORUN_INTERVAL :- Automatic rerun interval in daemon mode.Set it zero to disable automatic rerun which is zero.

AUTORUN_SCHEDULE * * * * :- Automatic run at specific time in daemon mode.
- - - -
▒ ▒ ▒ ▒
▒ ▒ ▒ +----- day of week (0 - 6) (0 to 6 are Sunday to Saturday)
▒ ▒ +---------- month (1 - 12)
▒ +--------------- day of month (1 - 31)
+-------------------- hour (0 - 23)

example: orachk -set "AUTORUN_SCHEDULE=8,20 * * 2,5" will schedule runs on tuesday and friday at 8 and 20 hour.

AUTORUN_FLAGS : orachk flags to use for auto runs.

example: orachk -set "AUTORUN_INTERVAL=12h;AUTORUN_FLAGS=-profile sysadmin" to run sysadmin profile every 12 hours

orachk -set "AUTORUN_INTERVAL=2d;AUTORUN_FLAGS=-profile dba" to run dba profile once every 2 days.

NOTIFICATION_EMAIL : Comma separated list of email addresses used for notifications by daemon if mail server is configured.

PASSWORD_CHECK_INTERVAL : Interval to verify passwords in daemon mode

COLLECTION_RETENTION : Purge orachk collection directories and zip files older than specified days.

-unset
unset the parameter
example: orachk -unset "AUTORUN_SCHEDULE"

-get
Print the value of parameter

-excludeprofile
Pass specific profile.
List of supported profiles is same as for -profile.

-merge
Pass comma separated collection names(directory or zip files) to merge collections and prepare single report.
eg:- ./orachk -merge orachk_hostname1_db1_120213_163405.zip,orachk_hostname2_db2_120213_164826.zip

-vmguest
Pass comma separated filenames containing exalogic guest VM list(applicable for Exalogic only)

-hybrid [-phy]
phy :Pass comma separated physical compute nodes(applicable for Exalogic only)
eg:- ./orachk -hybrid -phy phy_node1,phy_node2

-profile Pass specific profile.
List of supported profiles:

asm asm Checks
clusterware Oracle clusterware checks
compute_node Compute Node checks (Exalogic only)
control_VM Checks only for Control VM(ec1-vm, ovmm, db, pc1, pc2). No cross node checks
dba dba Checks
ebs Oracle E-Business Suite checks
el_extensive Extensive EL checks
el_lite Exalogic-Lite Checks(Exalogic Only)
el_rackcompare Data Collection for Exalogic Rack Comparison Tool(Exalogic Only)
goldengate Oracle GoldenGate checks
maa Maximum Availability Architecture Checks
obiee obiee Checks(Exalytics Only)
storage Oracle Storage Server Checks
switch Infiniband switch checks
sysadmin sysadmin checks
timesten timesten Checks(Exalytics Only)
virtual_infra OVS, Control VM, NTP-related and stale VNICs check (Exalogic Only)
zfs ZFS storage appliances checks (Exalogic Only)

-cells
Pass comma separated storage server names to run orachk only on selected storage servers.

-ibswitches
Pass comma separated infiniband switch names to run orachk only on selected infiniband switches.

-zfsnodes
Pass comma separated ZFS storage appliance names to run orachk only on selected storage appliances.

ORAchk Other Useful Options Not Covered Here

Using ORAchk Silently

ORAchk can be optionally run in “silent” or “non-interactive” mode in order to enable scheduling and automation
Is required only if customer does not want to use orachk daemon functionality.

Using ORAchk Daemon Mode Operation

This functionality permit non-interactive (batch or silent mode) execution on a regular interval.

When running ORAchk in daemon mode, the most recent and next most recent (if any) collection reports are automatically compared. If the mail address is configured a summary will be emailed along with attachments for the reports and the comparison report.

Report Comparisons with ORAchk

ORAchk has the ability to perform report comparisons between 2 ORAchk reports.
This allows for trending of Success Factor and Best Practice changes over time, after planned maintenance, etc within a user friendly HTML report.

ORAchk in Upgrade Readiness Mode

ORAchk can be used to obtain an automated 11.2.0.3 (or above) Upgrade Readiness Assessment.
The goal of the ORAchk Upgrade Readiness Assessment is to make the process of upgrade planning for Oracle RAC and Oracle Clusterware target versions 11.2.0.3 and above as smooth as possible by automating many of the
manual pre and post checks detailed in various upgrade related documents.

Refer MoS Notes for more details:
ORAchk - Oracle Configuration Audit Tool (Doc ID 1268927.2)

ORAchk Users Guide
For details instructions on how to run ORAchk including troubleshooting steps, available options, etc.

Master Note For Oracle Database Server Installation (Doc ID 1156586.1)

Master Note For Oracle Database Server Installation (Doc ID 1156586.1)

-------------------------------------------------------------------------------------------

Applies to:
Oracle Server - Enterprise Edition - Version: 8.1.7.0 to 11.2.0.2.0 - Release: 8.1.7 to 11.2
Information in this document applies to any platform.

Purpose
This Master Note is intended to provide an index and references to the most frequently used My Oracle Support Notes with respect to Oracle Database Installation.This Master Note is subdivided into categories to allow for easy access and reference to notes that are applicable to your area of interest, within INSTALLATION.This includes the following categories:

* Certification

* Installation Guides

* OS Requirements

* Scripts

* Silent Install

* Diagnostic Tools

* Known Issues

* General Information

* Using My Oracle Support Effectively

* Generic Link



Scope and Application
This note guides you through the process of Oracle Database Installation.

This note applies to the following versions of these products:

Oracle Server - Enterprise Edition - Version: 8.1.7.1 to 8.1.7.x
Oracle Server - Enterprise Edition - Version: 9.0.1.1 to 9.0.1.x
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 9.2.0.x
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.x
Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.1.0.x
Oracle Server - Enterprise Edition - Version: 11.2.0.1 to 11.2.0.x



Master Note For Oracle Database Server Installation
Certification
For the latest Database Certification always refer to My Oracle Support (MOS) Certify section.

At the same time the documentation listed below help you in understanding the Oracle Database Certification:

Note.415166.1 Oracle Database Client Certification Notes 10g Release 2 (10.2.0.3) for Microsoft Windows Vista
Note.161818.1 Oracle Database (RDBMS) Releases Support Status Summary
Note.207303.1 Client / Server / Interoperability Support Between Different Oracle Versions
Note.77627.1 Oracle Database Server product support Matrix for Windows 2000
Note.266043.1 Support of Linux and Oracle Products on Linux
Note.464754.1 Certified Software on Oracle VM
Note.753601.1 SUPPORT FOR ORACLE DATABASE ON WPARS UNDER AIX 6.1

Installation Guides
Oracle Database documentation, 11g Release 2 (11.2).
Installation manuals and platform-specific books are included in this link.

Oracle Database documentation, 11g Release 1 (11.1).
Installation manuals and platform-specific books are included in this link.

Oracle Database documentation, 10g Release 2 (10.2).
Installation manuals and platform-specific books are included in this link.

Oracle Database documentation, 10g Release 1 (10.1).
Installation manuals and platform-specific books are included in this link.

Oracle9i documentation, Release 2 (9.2).
Oracle9i documentation, Release 1 (9.0.1).
Installation manuals and platform-specific books are included in this search, for 9.2 only.

OS Requirements
Most of the installation and relinking issues appear if you don't satisfy the minimum requirements for the installation. Therefore if you are raising any SR for installation issue it is better to ensure that you have all these requirements mentioned in the below articles before raising the SR.

The documentation listed below help you in understanding the OS Requirements for Oracle Database Installation:
Generic
Note.169706.1 Oracle Database on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
Note.268025.1 Server Installation - Unix Knowledge Browser Product Page
Note.750540.1 What are the requirements for an Oracle Home Name in the Inventory?
Note.389678.1 Are Compilers Necessary for Oracle RDBMS Installation?

Linux
Note.376183.1 Defining a "default RPMs" installation of the RHEL OS
Note.851598.1 Master Note of Linux OS Requirements for Database Server
Note.761261.1 Recommended metalink articles for Oracle Database 10gR2 installation on zLinux (s390x)
Note.415182.1 DB Install Requirements Quick Reference - zSeries based Linux
Note.341507.1 Oracle Database Server on Linux on IBM POWER

AIX
Note.889464.1 Is Oracle 10g And 11g Database Compatible With AIX Version 6.1
Note.859856.1 Oracle 10g R2 database server software for AIX 6.1
Note.417451.1 How To Determine Whether an APAR has been Fixed in AIX Version/Maintenance Level
Note.201019.1 AIX Quick Start Guide - 9.2.0 RDBMS Installation
Note.182037.1 AIX Quick Start Guide - 9.0.1 RDBMS Installation
Note.109843.1 AIX Quick Start Guide - 8.1.X RDBMS Installation
Note.109842.1 AIX Quick Start Guide - 8.0.X RDBMS Installation

Solaris
Note.201021.1 SOLARIS Quick Start Guide - 9.2.0 RDBMS Installation
Note.148673.1 SOLARIS Quick Start Guide - 9.0.x RDBMS Installation
Note.108413.1 SOLARIS Quick Start Guide - 8.0.X RDBMS Installation
Note.108306.1 SOLARIS Quick Start Guide - 8.1.X RDBMS Installation
Note.743042.1 Requirements for Installing Oracle 11gR1 RDBMS on Solaris 10 SPARC 64-bit
Note 971464.1 FAQ - 11gR2 requires Solaris 10 update 6 or greater

HP-UX
Note.201023.1 HP-UX Quick Start Guide - 9.2.0 RDBMS Installation
Note.154360.1 HP-UX Quick Start Guide - 9.0.x RDBMS Installation
Note.108387.1 HP-UX Quick Start Guide - 8.1.X RDBMS Installation
Note.108381.1 HP-UX Quick Start Guide - 8.0.X RDBMS Installation

Scripts
Note.296665.1 Pre-Install checks for 10gR1 RDBMS (10.1.x) - Linux AMD64/EM64T Platforms
Note.283749.1 Pre-Install checks for 10gR1 RDBMS (10.1.x) - Linux Itanium 64 (IA64) Platforms
Note.283748.1 Pre-Install checks for 10gR1 RDBMS (10.1.x) - Linux x86 Platforms
Note.189256.1 UNIX Script to Verify Installation Requirements for Oracle 8.0.5 to 9.2 versions of RDBMS

Silent Install
Note.136660.1 Working Response files for a silent install of Oracle Server on MS-Windows- Part 1 of 3
Note.136661.1 Database Configuration Response file for performing silent install - Part 2 of 3
Note 136662.1 Network Configuration Reponse file for performing silent install - Part 3 of 3
Note 388451.1 How to create a Response File for Silent Installation?
Note 885643.1 How to install 11gR2 Database/Client Software in Silent mode without using response file
Note 808275.1 How to install Oracle Database Patchset software in Silent mode without using response file
Note 782919.1 How to install Oracle Database Server software silently with customized listener configuration
Note 782918.1 How to install/deinstall Oracle Database Server software silently without response file
Note 435680.1 Response File Installation of Database Server 10.2 (Suppressed or Silent mode)
Note 434803.1 Silent Installation for Oracle Server 10.1
Note 434315.1 How Can You Install Oracle Without Using The Oracle Universal Installer( runInstaller) GUI and Xserver especially When Doing A Remote Installation ?
Note 405124.1 How to Prevent a Silent Install from Prompting for User Input to Run the 'root.sh' Script
Note 228916.1 How to Troubleshoot a Silent Installation

Diagnostic Tools
Note.181459.1 How To Troubleshoot an Oracle Database Software Installation on UNIX
Note.780551.1 How To Diagnose Linking Errors During Base Install of Oracle RDBMS
Note.757964.1 Oracle Universal Installer ( OUI ) Error Messages and Solution Reference List

Known Issues
Note.833732.1 How To quick Deal with Relink, make, Failed on Linux ? Errors bin/sh /usr/bin/cc cannot execute binary file. or undefined reference to `dl_iterate_phdr@GLIBC_x.x.y'.
Note.848700.1 11gR1 on Solaris failing at relink phase with errors like "ld fatal relocation error" and then "ld fatal library -lclntsh not found"

Note.820135.1 What Does -ignoreSysPrereqs Ignore When Invoking runInstaller?
Note.867562.1 11gR1 OUI Error "fatal libCrun.so.1 open failed No such file or directory"
Note.852241.1 Installation of 11G fails on relink with INFO ld fatal library -lumem not found
Note.849336.1 Unable to launch OUI
Note.832074.1 AIX 6.1 "Dependent module /usr/lib/libXpm.a(shr_64.o) could not be loaded" Error Attempting To Execute 11.1.0 runInstaller

Note.1083353.1 11gR2 Pre-requirement APAR's check fail for AIX 6.1
Note.879102.1 Stand Alone 11.1.0.6 Silent Installation on AIX 5.3 Fails On Prerequisite Check For rsct.basic.rte(0.0) and rsct.compat.clients.rte(0.0)
NOTE:966929.1 - 11gR2 INSTALL ERRORS on Solaris 10
NOTE:989727.1 - 11GR2 INSTALL ON SOLARIS FAILS MANY PREREQUISITE CHECKS

General Information
Note.168607.1 Oracle Server Installation FAQ
Note.787705.1 How to identify correct Oracle Database software to install on Linux platform
Note.317257.1 Running Oracle Database in Solaris 10 Containers - Best Practices
Note.131321.1 How to Relink Oracle Database Software on UNIX
Note.738771.1 How to Log Good Service Request for Relink issues?
Note.458893.1 Oracle Universal Installer (OUI) FAQ
Note.736819.1 How to Log Good Service Request for Oracle Universal Installer (OUI) issues?
Note.429074.1 Can You Run Different Releases Of The Oracle Database On The Same Computer At The Same Time?

Using My Oracle Support Effectively
Note 374370.1 New Customers Start Here
Note 747242.5 My Oracle Support Configuration Management FAQ
Note 868955.1 My Oracle Support Health Checks Catalog
Note 166650.1 Working Effectively With Global Customer Support
Note 199389.1 Escalating Service Requests with Oracle Support Services

Generic Links
Note 854428.1 Patch Set Updates for Oracle Products
Note 1061295.1 Patch Set Updates - One-off Patch Conflict Resolution
Note 268895.1 Oracle Database Server Patchset Information, Versions: 8.1. 7 to 11.2.0
Note 161549.1 Oracle Database Server and Networking Patches for Microsoft Platforms
Note 161818.1 Oracle Database (RDBMS) Releases Support Status Summary
Information on Critical Patch Updates (CPU's)
About Oracle
Oracle Corporation, an enterprise software company, engages in the development, manufacture, distribution, servicing, and marketing of database, middleware, and application software worldwide.
The company was founded in 1977 and is headquartered in Redwood City, California.

Find files in Unix

Find files in Unix

> FIND FILES THAT WERE MODIFIED/ACCESSED WITHIN A SPECIFIED TIME
            $   find  /<your path>  -mtime   1  -type   f
This command would return files modified  in the last 24 hours .
You can use -mtime option to return a list of files that were last modified N*24 hours ago. For example to find a file in last month (30 days) you would need to use -mtime +30 options.

-mtime +30   means you are looking for a file modified 30 days ago.
-mtime -30    means less than 30 days.
-mtime 30      If you skip + or – it means exactly 30 days
      -type f      searches only for files and not directories
 
To list the files in the directory tree that were modified within the past five minutes, type
$  find /<your path>  -mmin -5
 
To return a list of files that were accessed in the last 24 hours you would need to use the–atime option.
$  find  /<your path>   -atime   1  -type   f  

> FINDING FILES WITH A SPECIFIC EXTENTION WITHIN A DIRECTORY
         $  find   /<your path>   -name  “*.cfg”
The command –name matches the file names with the specified pattern
 

> FINDING FILES BASED ON THE FILE-PERMISSIONS
Files with execute permission for group :
$ find /<your path>  -perm g=x   -type f
Files with execute permission for others:
$ find /<your path>  -perm  o=x   -type f
Where ‘g’ denotes groups and ‘o’ denotes others. x denotes execute permission.

To Check number of CPU’s in the Server

To Check number of CPU’s in the Server

Linux

cat /proc/cpuinfo | grep “processor”|wc –l
HP-UX
ioscan -C processor | grep processor | wc –l
SUN Solaris
psrinfo -v|grep “Status of processor”|wc –l
AIX
lsdev -C|grep Process|wc –l
To identify High Disk I/o using Unix command
/usr/bin/ps -eo pid,user,pcpu,args | grep -v %CPU |  sort -nbk 3 | tail -25

To report the current CPU Activity

sar -u 1 5

sar utility can be used to provide various information about the server resources.

In the above example the parameters used and the details are as mentioned below
-u option is for CPU related information
1 is the frequency of execution of the command in seconds
5 is the number of times the command should be executed.
So the command displays the CPU information every 1 second for 5 times.

It reports the CPU related usage by the user(%usr), system(%sys), the CPU Wait for I/O(%wio) and the Idle Percentage(%idle).

Sample Output

14:08:17    %usr    %sys    %wio   %idle   physc
14:08:18      25        0          0           75       4.00
14:08:19      25        0          0           74       4.00
14:08:20      25        0          0           75       4.00
14:08:21      25        0          0           75       4.00
14:08:22      25        0          0           75       4.03
Average       25        0          0           75       4.01

WFDS Data Collection Script (Doc ID 742062.1)

WFDS Data Collection Script (Doc ID 742062.1)
 
PURPOSE:
This script was created to collect the required information to determine the cause of missing responsibilities associated to one specific user.
INSTRUCTIONS:

sqlplus apps/<password>

SQL> @atg_supp_fnd_usr_resp.sql

Parameter:
User_Name in uppercases

Output file
wf_<UserName>_wfds.html


Note : Need to download atg_supp_fnd_usr_resp.sql from MOS ID 742062.1
++++++++++++++
Oracle Workflow Release 12 Diagnostics (Doc ID 469822.1)

How To Successfully Change The Guest Password In E-Business Suite 11.5.10 and R12 [ID 443353.1]

How To Successfully Change The Guest Password In E-Business Suite 11.5.10 and R12 [ID 443353.1]

Modified 15-FEB-2010 Type HOWTO Status MODERATED
In this Document
Goal
Solution
References

Platforms: 1-914CU;

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
Applies to:

Oracle Application Object Library - Version: 11.5.2 to 12.0.2
Information in this document applies to any platform.
***Checked for relevance on 15-Feb-2010***
Goal

You are attempting to change the E-Business Suite GUEST user password. There are various methods listed on Metalink but you are unsure of which way to go.

This document describes the current 'supported' and 'recommended' method to change the GUEST user password across all areas of the application.

The following method should be used, unless specifically instructed otherwise by Oracle Support

Solution

To change the GUEST password follow the instructions below:

1. As the "applmgr" Unix user make sure the appropriate environment files are sourced

2. Use the AutoConfig editor to change the context value for the guest password, described in Note 165195.1 "Using AutoConfig to Manage System Configurations with Oracle Applications 11i"

AutoConfig variable name is "s_guest_pass"
3. Run AutoConfig

4. Verify the new guest password as follows:

select fnd_web_sec.validate_login('GUEST','') from dual;

this script should return 'Y'

5. Change the guest password used for diagnostics as described in Note 235307.1 "eBusiness Support Diagnostics FAQ and Troubleshooting Guide" and summarized below:

a. Login to applications as SYSADMIN user and choose "CRM HTML Administration" responsibility. (If you don't see this responsibility, it may be end dated for SYSADMIN user.)

b. Then follow this path and correct the GUEST password.

Settings : System : Properties
Self Service User
Settings
System
Properties > Advanced
Choose JTF from the "View" LOV.
Look for guest_password and correct it

6. Stop / Start Apache