How to connect to RUN File System and Patch File System in R12.2   1 comment

This post also helps us to find to to which File System we got connected when we executed env from fs1 file system

[appltest@idbalearning ~]$ . /d01oracle/R122/EBSapps.env run
E-Business Suite Environment Information
 ----------------------------------------
 RUN File System : /d01/oracle/R122/fs1/EBSapps/appl
 PATCH File System : /d01/oracle/R122/fs2/EBSapps/appl
 Non-Editioned File System : /d01/oracle/R122/fs_ne
 DB Host: idbalearning.ora.com Service/SID: TEST
Sourcing the RUN File System ...
[appltest@idbalearning ~]$ sqlplus apps/apps
SQL*Plus: Release 10.1.0.5.0 - Production on Tue Oct 22 11:28:31 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select ad_zd.get_edition_type from dual;
GET_EDITION_TYPE
--------------------------------------------------------------------------------
RUN

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

[appltest@idbalearning ~]$ . /d01/oracle/R122/EBSapps.env patch
E-Business Suite Environment Information
 ----------------------------------------
 RUN File System : /d01/oracle/R122/fs1/EBSapps/appl
 PATCH File System : /d01/oracle/R122/fs2/EBSapps/appl
 Non-Editioned File System : /d01/oracle/R122/fs_ne
 DB Host: idbalearning.ora.com Service/SID: TEST
Sourcing the PATCH File System ...
[appltest@idbalearning1 ~]$ sqlplus apps/apps
SQL*Plus: Release 10.1.0.5.0 - Production on Tue Oct 22 11:26:36 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-20099: E-Business Suite Patch Edition does not exist.
ORA-06512: at line 23

Why it is failing to connect? Guess What!

We cannot connect to database when patch edition is not prepared

The application-tier Patch Edition environment is configured to connect to the database patch edition by default. If a database patch edition is not active, then attempting to connect to the database from the application-tier patch edition environment will fail.

Hope this Helps!!!!!!…….

Advertisements

Posted October 23, 2013 by balaoracledba.com in R12.2

One response to “How to connect to RUN File System and Patch File System in R12.2

Subscribe to comments with RSS.

  1. That works, thank you a ton!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: