Archive for October 2013

11i/R12 Apache Common Issues with Solutions   4 comments

I dont know where I got this document. But I am thankful to the person who collected all these issues in one single Document.

Credits to that Person

Apache Common Issues

General Information to Troubleshoot Apache Issues.

1)If you mistype any directive in Apache (httpd.conf or any conf file), Apache will not start & it will not write even in error_log. In these case it will report any error message to file
$COMMON_TOP/admin/log/$CONTEXT_NAME/adapcctl.txt

So first check in the above file

2)Found *.pid file in Apache_Top/Apache/logs/ even after bounce of an Apache web server (When Apache starts it creates .pid file in logs directory and when you shutdown apache it cleans this .pid file). So if this file is already there then Apache will not start.
Fix: Simply move this file

3)Could not bind port (Port already in Use) or Sometimes apache and concurrent Manager will interchange their port no.’s while starting results error and both of them will not up
Fix: To overcome this up the services in this manner
1)Listener
2)Apache web server
3)Concurrent manager
4)adstrtal.sh

4)Error 500 – Internal server error
Fix: 1) Clear Cache (Application Server Cache)and start the services

5)If there are no error messages in error_log or error_log_pls
then there might be issues in starting Jserv component of web server (which caters Java requests by mod_jserv)

6)If you don’t know port number of your web server you can check it in file $IAS_ORACLE_HOME/Apache/Apache/conf/httpd.conf with directive Listen & Port

7)Once you are able to access http://hostname.domainname:port and if you are getting any error message that means your web server (Core Apache) is working but there are various components called as modules and there may be issues with those modules which we will check these modules . few modules of our interest are
-mod_jserv
-mod_pls
-mod_oprocmgr
-mod_ossl (If you have ssl enabled on web server)
-mod_osso (If single sign on server is enabled on web server)

8)Once in a while adapcctl.sh start will not work then ultimate you have to go and invoke apachectl script file in Apache top/apache/bin to start Apache webserver.

09)Error : Your session is no longer valid while trying to loging to applications.
The issue is resolved by changing the profile option session_cookie_domain to null from domain.com

10)HTTP-403 forbidden message after entering the username and password in the “Apps Logon Links” page. [Not authorised to view this page]
Check for Apps password in $APACHE_TOP/modplsql/cfg/wdbsvr.app ,Comment out custom_auth entry in $APACHE_TOP/modplsql/cfg/wdbsvr.app and bounce apache.

11)Error message: You have insufficient privileges for the current operation.
Verify and update SESSION_COOKIE_DOMAIN in ICX_parameters if it is wrong.

Example :

update icx_parameters set SESSION_COOKIE_DOMAIN=’NEW_VALUE’ where SESSION_COOKIE_DOMAIN=’OLD_VALUE’

12)AppsLocalLogin?.jsp page error outs….

  • Edit the $IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.properties
  • Set wrapper.bin.parameters=-DLONG_RUNNING_JVM=false
  • add the line wrapper.bin.parameters=-DCACHEMODE=LOCAL
  • Restarted Apache for these changes to take effect and retested the issue

13) Login to the applications URL fails with
500 Internal server Error
java.lang.NoClassDefFoundError at
oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:126) at
oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:170) at com.evermind[Oracle
Containers for J2EE 10g (10.1.3.0.0)
].server.http.HttpApplication.loadServlet(HttpApplication.java:2231) at com.evermind[Oracle
Containers for J2EE 10g (10.1.3.0.0)
].server.http.HttpApplication.findServlet(HttpApplication.java:4617) at com.evermind[Oracle
Containers for J2EE 10g (10.1.3.0.0)
].server.http.HttpApplication.findServlet(HttpApplication.java:4541) at com.evermind[Oracle
Containers for J2EE 10g (10.1.3.0.0)

Performed the below steps, but it did not resolved the issue
1) Bounced Apache server, cleared cache and validated ports
2) Bounced all Middle tier services and killed defunct processes
3) Bounced Unix Server

Solution
=======
Java object Caching Configuration parameter was Enabled in oc4j.properties
$INST_TOP/ora/10.1.3/j2ee/oacore/config
Disabled LONG_RUNNING_JVM=false from True
Bounced Apache server and could login to the applications URL without issues

                           ISSUES AND SOLUTIONS

ISSUE 1:

Description

When Apache script adapcctl.sh is issued.It shows that Apache is started.On checking the status Apache is stopped

Cause

The error log file in the folder
cd $APACHE_TOP/Apache/logs

Showed

fopen: No such file or directory httpd: could not log pid to file /var/opt/_/Apache/logs/httpd_pls.pid

SOLUTION 1

Created the missing directories /_/Apache/logs under /var/opt folder
Bounced Apache
**********************************************************************
ISSUE 2:

Description
oacore was not comming up in the configurator node.
opmnctl status

ias-component process-type pid status

OC4J oacore N/A Down
OC4J oacore N/A Down
OC4J oacore N/A Down
OC4J oacore N/A Down

Cause

Check the oacore error log.

Example:

Below Log file gives root cause. //mtlog/_/logs/ora/10.1.3/opmn/oacore_default_group_2/oacorestd.err

14:11:56 Error initializing server: //inst/apps/_/ora/10.1.3/j2ee/oacore/config/server.xml,
Fatal error at line 70 offset 1 in file://inst/apps/_/ora/10.1.3/j2ee/oacore/config/server.xml: .:
XML-20100: (Fatal Error) Expected ‘EOF’.
SOLUTION 2

Edit the /sid/inst/apps/SID_hostname/ora/10.1.3/j2ee/oacore/configserver.xml file and remove the extra line in the file. Restart and check oacore will be starting. This sudden change in server.xml seems to be because of a bug.
Bug – 6702510
************************************************************************
ISSUE 3

AppsLocalLogin?.jsp page was displaying errors

Cause

Extract from the Jserv log file =========================== [27/02/2008 16:57:14:447 CST] weboamLocal/oracle.apps.fnd.oam. servlet.ui.OAMServlet:
Sucessfully initialize oaosu.OAMServlet [27/02/2008 16:57:14:447 CST] Servlet Zone rootauohstrzt11 initia lization complete [27/02/2008 16:57:15:101 CST]
Creating noun for: oracle.jsp.JspServlet [27/02/2008 16:57:15:102 CST] Creating noun for: AppsLocalLogin?.jsp
[27/02/2008 16:57:15:120 CST] oracle.jsp.JspServlet: init [27/02/2008 16:57:28:066 CST] Creating noun for: oracle.jsp.JspServlet
[27/02/2008 16:57:28:067 CST] Creating noun for: AppsLocalLogin?.jsp [27/02/2008 16:57:28:078 CST] oracle.jsp.JspServlet: init
[27/02/2008 16:57:29:753 CST] JspServlet?: unable to dispatch to requested page: Exception:java.lang.NoClassDefFoundError

SOLUTION 3:

Edited the $IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.properties
a) Set wrapper.bin.parameters=-DLONG_RUNNING_JVM=false
b) Add the line wrapper.bin.parameters=-DCACHEMODE=LOCAL
c) Restarted Apache for these changes to take effect and retested the issue
********************************************************************
ISSUE 4

New Message when starting Apache using adapcctl.sh start

Cause

It takes 7/10 minutes to clear this cache directory if present
apache Web Server Listener is not running.

Starting Apache Web Server Listener (dedicated HTTP) …

Removing gantt cache directory
/ppomwi/applmgr/r12/apps/apps_st/comn/webapps/oacore/html/cabo/images/cache
Successfully removed the gantt cache directory:/tcge1i/applmgr/common/html/cabo/images/cache/gantt

Apache Web Server Listener (PLSQL) is not running.

Starting Apache Web Server Listener (dedicated PLSQL) …

SOLUTION 4

$COMMON_TOP/webapps/oacore/html/cabo/images/cache

Wait for atleast 7 to 10 minutes and this cache directory will be cleared and Apache will be started successfully
***********************************************************************
ISSUE 5

Apache server is up and running.
But adapcctl.sh status shows
adapcctl.sh version 115.54
Apache Web Server Listener is not running. Apache Web Server Listener (PLSQL) is not running.

adapcctl.sh: exiting with status 1

Cause

Incorrect Lock file path given in httpd.conf
LockFile? $APACHE_TOP/Apache/log/PPOMWI_httpd.lock
and Incorrect path given in adapcctl.sh script.

SOLUTION 5:
Modified the path of lock file in $APACHE_TOP/Apache/conf/httpd.conf file.
LockFile? /var/opt/SID_/httpd.lock
and Modified the path of adapcctl.sh file by commenting the wrong path
************************************************************************
ISSUE 6

After selecting the E-Business home page got internal server error Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.

Cause
Found that all the properties files as below
jserv.properties jserv_restrict.properties zone.properties zone_restrict.properties
were pointing to a dbc file name _.dbc
which was not physically present at the path
/sid/applmgr/11510/fnd/11.5.0/secure/_
$ cd //applmgr/11510/fnd/11.5.0/secure/_
$ ls .dbc

SOLUTION 6:

copied the file PROD.dbc
which was physically present at path
//applmgr/11510/fnd/11.5.0/secure/_
to the dbc file name which was being pointed by all the properties files
This resolved the issue.
**********************************************************************
ISSUE 7
Instance is very slow / inaccessible with a warning on login page:
Warning

Low-level logging is currently enabled. Your application will not perform as well while Low-level logging is on.

Cause
Logging was enabled through profile values:
FND: Debug Log Enabled — Yes
FND: Debug Log Level — Statement
FND: Debug Log Module — %
SLA: Enable Diagnostics — Yes
FND Validation Level — Error

SOLUTION 7
1. Change these values to:
FND: Debug Log Enabled — No
FND: Debug Log Level — ( Blank )
FND: Debug Log Module — ( Blank )
SLA: Enable Diagnostics — No
FND Validation Level — None

2. Bounce Apache on all the MTs and clear Apache cache.
*********************************************************************
ISSUE 8

Login to the applications URL fails with
500 Internal Server Error java.lang.NoClassDefFoundError at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect?.java:126) at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect?.java:170) at com.evermind[Oracle Containers for J2EE? 10g (10.1.3.0.0) ].server.http.HttpApplication.loadServlet(HttpApplication?.java:2231) at com.evermind

Performed the below steps, but it did not resolved the issue
1) Bounced Apache server, cleared cache and validated ports
2) Bounced all Middle tier services and killed defunct processes
3) Bounced Unix Server

Cause
No Cause Entered

SOLUTION 8

Java object Caching Configuration parameter was Enabled in oc4j.properties $INST_TOP/ora/10.1.3/j2ee/oacore/config
Disabled LONG_RUNNING_JVM=false from True

Bounced Apache server and could login to the applications URL without issues

Java Caching is a mechanism used to improve performance by storing data in the Middle Tier JVM memory, instead of retrieving the data from the database every time it is requested.
***********************************************************************
ISSUE 9
When trying to access the URL (Either Big IP or the node level), it hangs for a long time and getting redirected to a different URL and gives a blank page. For example, When try to access the ipayments URL which is hosted on node2, it hangs for a long time and its getting redirected towards the Sales URL which is hosted on node3, and displays a blank page.

Cause
All the host reference and the URL directives are pointing towards node3 and sales URL respectively, in the below files. Hence every attempt tries to launch the sales URL and get fails as the apache configuration files and parameters are pointing towards the correct one.
jserv.conf forms.properties zone.properties jserv.properties

SOLUTION 9

Stop Apache. Edit the files jserv.conf, forms.properties, zone.properties, jserv.properties, jserv.conf to replace the host reference and the URL directives to the correct one (In our case, its node3 . Clear the cache and restart the Apache.

ISSUE 10
Apache login issues occurs in multi MT environment. Unable to login to oracle applications.

Cause
Issue due to distributed cache.

SOLUTION 10
Set is_distributed to false in javacache.xml Bounce Apache.

ISSUE 11
Apache server is down. Apache logfile did not provide useful information.
Started the Apache server, but the Apache Web listener did not started.
1) Verified no log files (Apache,Jserv) crossed 2GB limit. error_log, access.log, mod_jserv
2) Veified that the port is listening (netstat -an |grep ) Apache port(httpd.conf), pls listener(httpd_pls.conf)
3) Verified that the Apache and Jserv configuration files are not changed recently httpd.conf & Jserv.conf
4) Shutdown all the Middle tier services and check for ipcs (semaphores) did not resolve the outage.
$ ipcs on application middle tier as Application user ap

Cause
No Cause Entered

SOLUTION 11

Rebooted the server and started the services. All services came back normal.
************************************************************************
ISSUE 12
Unable to login to the home page URL. Login fails with the error:
Error Page You have encountered an unexpected error. Please contact the system administrator for assistance.

Click here for exception details

Checks:

Upon clicking the link, can observe the error:
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: SQL_PL SQL_ERROR. Tokens: ROUTINE = createSession(int)(userId=6,sessionMode=’null’,’2D8 FCCC57459B66EE040558CDBC6118E44964630721347149122084914143412?’); REASON = java.s ql.SQLException: ORA-01422: exact fetch returns more than requested number of ro ws ORA-06512: at “APPS.FND_SESSION_MANAGEMENT”, line 295 ORA-06512: at “APPS.FND_SESSION_MANAGEMENT”, line 455 ORA-06512: at line 1 ; ERRNO = 1422;

Cause
FND_NODES table was updated with the same server_id for all Nodes.

SOLUTION 12

Update the table FND_NODES with correct server_ids for all nodes as in $FND_TOP/secure/sid_host/sid.dbf
Bounced apache on all apache nodes.

and Run select node_name, server_id from fnd_nodes;
to confirm the values.

Below is the example for the solution:

Found three hosts using same server_id:

SQL> select node_name, server_id from fnd_nodes; NODE_NAME SERVER_ID
AUOHSACPS06 2D8FCCC57459B66EE040558CDBC6118E44964630721347149122084914143412
AUOHSACPS03 2D8FCCC57459B66EE040558CDBC6118E44964630721347149122084914143412
AUOHSACPS02 2D8FCCC57459B66EE040558CDBC6118E44964630721347149122084914143412

reset server_id with original server_id from each hosts .dbc file @ $FND_TOP/secure:

SQL> select node_name, server_id from fnd_nodes; NODE_NAME SERVER_ID
AUOHSACPS06 2D8FF21843830F82E040558CDBC6195C27690802237516122831445560236127
AUOHSACPS03 2D90005D5A13C774E040558CDBC61D9436546148971863330582284123371818
AUOHSACPS02 2D8FCCC57459B66EE040558CDBC6118E44964630721347149122084914143412
************************************************************************
ISSUE 13

Users getting ‘404 page not found errors’ when tyring to access the URL

(OR)

Getting Exception in thread “main” java.lang.ClassFormatError: Truncated class file

(OR)

adstrtal.sh or adstpall.sh is throwing below error message

You are running adstrtal.sh version 115.16

Exception in thread “main” java.lang.ClassFormatError: oracle/apps/ad/context/AppsContext (Truncated class file) at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader?.java:539) at java.security.SecureClassLoader.defineClass(SecureClassLoader?.java:123) at java.net.URLClassLoader.defineClass(URLClassLoader?.java:251) at java.net.URLClassLoader.access$100(URLClassLoader?.java:55) at java.net.URLClassLoader$1.run(URLClassLoader?.java:194) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader?.java:187) at java.lang.ClassLoader.loadClass(ClassLoader?.java:289) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274) at java.lang.ClassLoader.loadClass(ClassLoader?.java:235) at java.lang.ClassLoader.loadClassInternal(ClassLoader?.java:302) at oracle.apps.ad.autoconfig.ServiceControl.(ServiceControl?.java:319) at oracle.apps.ad.autoconfig.ServiceControl.main(ServiceControl?.java:662) Check logfile //applmgr/common/admin/log/_/08061104.log for details

Exiting with status 1

(OR)

[06/08/2007 11:03:12:181] (ERROR) an error returned handling request via protocol “ajpv12” [06/08/2007 11:03:12:181] (EMERGENCY) ajp12: can not connect to host 140.85.188.36:20021 [06/08/2007 11:03:13:184] (EMERGENCY) ajp12: can not connect to host 140.85.188.36:20021 [06/08/2007 11:03:15:038] (EMERGENCY) ajp12: auth did not receive challenge size [06/08/2007 11:03:15:038] (EMERGENCY) ajp12: auth fail

Cause

Extract from the JVM log file: //product/iAS/Apache/Jserv/logs/jvm/OACoreGroup.0.stderr
Exception in thread “main” java.lang.ClassFormatError: Truncated class file at org.apache.jserv.JServServletManager.load_init(JServServletManager?.java:765) at org.apache.jserv.JServServletManager.loadServlet(JServServletManager?.java:659) at org.apache.jserv.JServServletManager.loadStartupServlets(JServServletManager?.java:789) at org.apache.jserv.JServServletManager.init(JServServletManager?.java:447) at org.apache.jserv.JServ.start(JServ.java:625)

Verified that there are no log files that exceed 2GB limit (OS limit).
Clearing the Apache and Jserv cache did not resolve the issue. Unmount / mount product specific file system did not resolve

SOLUTION 13:

Try each of these solutions until the problem is resolved, in order to have the least impact on the system.
1. If you can determine the specific class file from the log files, use the ‘touch’ command.

e.g. touch classfile

If necessary, restart Apache and clear server cache.

2. Shut down all MT services, exit the Apps owner and ask the System Admin to unmount and remount the /sid/applmgr file system (mount point above $JAVA_TOP). Ask the System Admin to kill any processes that may be holding the file system open. Then log in to the Apps owner and restart MT services.

3. Shutdown all the MT services and ask System Admin to reboot the server if the actions above don’t resolve the outage.
************************************************************************
ISSUE 14:

Got login error – Internal Server Error after bounced all services on . find following message from Jserv log file:

$ tail -8 mod_jserv.log
[07/05/2007 18:41:06:915] (ERROR) ajp12: Servlet Error: java.lang.NoClassDefFoundError: null
[07/05/2007 18:41:06:916] (ERROR) an error returned handling request via protocol “ajpv12”
[07/05/2007 18:41:06:916] (ERROR) balance: 11906 internal servlet error in server auohsnops03.oracleoutsourcing.com:20720
[07/05/2007 18:41:06:916] (ERROR) an error returned handling request via protocol “balance”
[07/05/2007 20:07:52:732] (ERROR) ajp12: Servlet Error: java.lang.NoClassDefFoundError: null
No runaway, no lock on port 20720.

SOLUTION 14:
Shutdown all services on MT. Removed all log file (standard error…) from Jserv/jvm. Started All services with successful login.
************************************************************************
ISSUE 15
Customer reported Not able to login with “Internal Server Error” on .
We could not start some of services during bounced All Services with following error message: adapcctl.sh version 115.47
Cannot complete applications logon. You may have entered an invalid applications password, or there may have been a database connect error.

Apache Web Server Listener is not running (dedicated HTTP) …
Cannot complete applications logon. You may have entered an invalid applications password, or there may have been a database connect error.
Cannot complete applications logon. You may have entered an invalid applications password, or there may have been a database connect error.

Apache Web Server Listener is already stopped.
Cannot complete applications logon. You may have entered an invalid applications password, or there may have been a database connect error.
adapcctl.sh: exiting with status 2

Unable to login the application URL, facing the error while login:

Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, ap@domain.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

Cause:

SQL> select END_DATE from fnd_user where user_name=’GUEST’;

END_DATE
———
05-OCT-10

SOLUTION 15

We found out the apps and applsys were not in sync.
Just manual change the apps password from sqlplus.
Restarted all services and login successfully.

or

Update the FND_USER table with END_DATE=null and bounced apache
SQL> update fnd_user set END_DATE=null where user_name=’GUEST’;

1 row updated.

SQL> commit;

Commit complete.

SQL> select END_DATE from fnd_user where user_name=’GUEST’;

END_DATE
———–
************************************************************************

 

 

 
ISSUE 16

Unable to login to oracle applications:
error message: You have insufficient privileges for the current operation.

Checks

Unable to login to oracle applications:
error message: You have insufficient privileges for the current operation.

SOLUTION 16

Verify and update SESSION_COOKIE_DOMAIN in ICX_parameters if it is wrong.

Example :

update icx_parameters set SESSION_COOKIE_DOMAIN=’NEW_VALUE’ where SESSION_COOKIE_DOMAIN=’OLD_VALUE’;
************************************************************************
ISSUE 17

Apache home page is not coming up even after bounced
Found in jvm log asking for java version

SOLUTION 17

//product/iAS/Apache/Apache/bin/java.sh: /usr/java/jdk1.3.1_15/bin/java: not found

Check the version in /usr/java and update that version in java.sh file and Bounced Apache.
************************************************************************
ISSUE 18

Unable to access applications

cause
All applications are up and running.
“Solaris Error: 12: Not enough space” errors are encounterd in database listener logfile.

SOLUTION 18:

Check if the OS is SUN Solaris.
Check if /tmp filesystem is 100% full.
Check Swap space utilization.
Check the application process that is hagging resources. (Check if any sql sessions are hagging resources)
Clear the process in issue after getting required approval.

NOTE:
The above is applicable only for environments on Solaris OS.
************************************************************************
ISSUE 19

Not able to login to APPS. JSP Error:
Unable to create an user session or ORA-01403 : no data found has been detected in FND.SIGNON.AUDIT_USER

Checks

Check number of rows in dual table.
Select * from dual;
DUAL table should always contain only one row.
The table named DUAL is a small table in the data dictionary that Oracle and user-written programs can reference to guarantee a known result.
This table has one column called DUMMY and one row containing the value X.

SOLUTION 19

DUAL table should always contain only one row and one column.
Insert a row with value X into dual table if the dual table contains 0 rows. If the dual table contains more than one row then delete the rows by keeping one row.

The rows in dual table not equal to zero.
************************************************************************
ISSUE 20

Signature for “https URL redirecting to http URL”
Issue:
https URL redirecting to http URL and the page cannot be displayed error occurs.

SOLUTION 20

Check the httpd.conf and url_fw.conf, in url_fw.conf the Rewrite rule was
RewriteRule ^/$/OA_HTML/AppsLocalLogin.jsp.
Changed into
RewriteRule https://: /OA_HTML/AppsLocalLogin.jsp.

 

Advertisements

Posted October 30, 2013 by balaoracledba.com in Issues, OracleAppsR12

Concurrent program Registration with Oracle Application.   Leave a comment

Creating a Sample program and Registering with Oracle Application.

Step-1

1

STEP-2

Create Table in XXERP schema

2

create table xxerp_emp as select * from scott.emp;

STEP-3

Create sql file in XXERP_TOP under  sql folder

3

4

Step-4

Register The EXECUTABLE with Oracle Application

Navigation

Concurrent—>Program—>Executable

5

Step-5

Create Program for Executable

6

Step-6

Add the program to Request Group.

7

Logout from sysadmin and login with the Responsibility who own the above created Request Group and run the program

8

9

The error is  due to the absence of synonym for xxerp_emp table in apps schema (schema which got created when we create custom schema during custom application registration)

[oracle@rao3 ~]$ sqlplus apps/apps

SQL*Plus: Release 11.1.0.7.0 – Production on Wed Apr 17 10:12:16 2013

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

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> create public synonym xxerp_emp for xxerp.xxerp_emp;

Synonym created.

TRY RUNNING THE CONCURRENT PROGRAM AGAIN………………….

Posted October 30, 2013 by balaoracledba.com in OracleAppsR12

Custom Top/Application Creation R12   8 comments

SCHEMA NAME : XXERP
TOP NAME : XXERP_TOP
Application : XXERP Custom Application
Data Group : Standard
Request Group : XXERP Request Group
Menu : XXERP_CUSTOM_MENU
Responsibility : XXERP Custom

 

Step-1
Create a Tablespace in the backened Database for custom schema.
create tablespace XXERP datafile ‘/d01/oracle/PROD/db/apps_st/data/XXERP01.dbf’
size 50M;
Step-2
Create Schema
create user XXERP identified by XXERP default tablespace XXERP temporary tablespace temp quota unlimited on XXERP;

Step-3

Grants Connect and Resource to schema

grant connect, resource to XXERP;
Step-4
Make the directory structure for your custom application files.
cd $APPL_TOP
mkdir XXERP
mkdir -p XXERP/12.0.0
mkdir -p XXERP/12.0.0/admin
mkdir -p XXERP/12.0.0/admin/sql
mkdir -p XXERP/12.0.0/admin/odf
mkdir -p XXERP/12.0.0/sql
mkdir -p XXERP/12.0.0/bin
mkdir -p XXERP/12.0.0/reports
mkdir -p XXERP/12.0.0/reports/US
mkdir -p XXERP/12.0.0/forms
mkdir -p XXERP/12.0.0/forms/US
mkdir -p XXERP/12.0.0/lib
mkdir -p XXERP/12.0.0/out
mkdir -p XXERP/12.0.0/log

Step-5
Create Custom Environment file in APPL_TOP directory

 

1

 

Step-6
Edit customPROD_idba22.env file

2

 

3

 

export XXERP_TOP=/d01/oracle/PROD/apps/apps_st/appl/XXERP/12.0.0

 

Step-7

4

 

5

 

go to last line and add
XXERP_TOP=/d01/oracle/PROD/apps/apps_st/appl/XXERP/12.0.0

6

 

Step-8
Register your Oracle Schema.
Login to Applications with System Administrator responsibility
Navigate to Application–>Register
Application = XXERP Custom Application
Short Name = XXERP
Basepath = XXERP_TOP
Description = XXERP Custom Application

7

 

Step-9
Register Oracle User
Naviate to Security–>Oracle–>Register
Database User Name = XXERP
Password = XXERP
Privilege = Enabled
Install Group = 0
Description = XXERP Custom Application User

8

 

Step-10
Add Application to a Data Group
Navigate to Security–>Oracle–>DataGroup

9

 

Step-11
Create custom request group
This will act as a placeholder for any custom reports we wish to make available for the
Custom Responsibility (which is defined at a later stage)
Navigate to Security–>responsibility–>Request
Group = XXERP Request Group
Application = XXERP Custom
Code = XXERP
Description = XXERP Custom Requests
We will not define any requests to add to the group at this stage, but you can add some now if required.

 

10

 

Step-12
Create custom menu
This will act as a placeholder for any menu items we wish to make available for the
Custom Responsibility (which is defined at a later stage). We will create two menus, one
for Core Applications and one for Self Service.
Navigate to Application–>Menu
Menu = XXERP_CUSTOM_MENU
User Menu Name = XXERP Custom Application
Menu Type =
Description = XXERP Custom Application Menu
Seq = 100
Prompt = View Requests
Submenu =
Function = View All Concurrent Requests
Description = View Requests
Seq = 110
Prompt = Run Requests
Submenu =
Function = Requests: Submit
Description = Submit Requests

11

Step-13
Create new responsibility. Navigate to Security–>Responsibility–>Define
Responsibility Name = XXERP Custom
Application = XXERP Custom
Responsibility Key = XXERPCUSTOM
Description = XXERP Custom Responsibility
Available From = Oracle Applications
Data Group Name = XXERPGroup
Data Group Application = XXERP Custom
Menu = XXERP Custom Application
Request Group Name = XXERP Request Group

12

Step-14
Add responsibility to user
Navigate to Security–>User–>Define
Add XXERP Custom responsibility to users as required.

13

Step-15
As we have edited default.env we need to bounce the opmn.

cd $ADMIN_SCRIPTS_HOME
sh adopmnctl.sh stopall

Rest the Application ENvironment and start OPMN
sh adopmnctl.sh startall

 

14

 

 

Posted October 30, 2013 by balaoracledba.com in OracleAppsR12

Forms Servlet mode to Socket mode Release 12 Apps   Leave a comment

Forms Servlet mode to Socket mode conversion on Release 12 Apps

 

How to convert Forms server to Socket mode from Servlet mode in Oracle Apps R12

Run the following command to enable Forms Socket Mode on Forms/web nodes (Place correct context file name and port value)

$FND_TOP/bin/txkrun.pl -script=ChangeFormsMode -contextfile=$CONTEXT_FILE -mode=socket -port=9030 -runautoconfig=No

Where port = forms port and contextfile=your environment contextfile

To Start/Stop/check Status of forms servers use following scripts

cd $ADMIN_SCRIPTS_HOME
./adformsrvctl.sh status/stop/start

How to find forms mode of connection in R12

[applmgr@r12 ~]$ grep frmConnectMode $CONTEXT_FILE

<forms_connect oa_var=”s_frmConnectMode”>servlet</forms_connect>

Let’s convert Servlet to Socket.

Step1: Shutdown the application Tier Services.

[applmgr@r12 scripts]$ sh adstpall.sh apps/apps

[applmgr@r12 scripts]$ $FND_TOP/bin/txkrun.pl -script=ChangeFormsMode -contextfile=$CONTEXT_FILE -mode=socket -port=9030 -runautoconfig=No

*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

*** Log File = /d01/oracle/PROD/inst/apps/PROD_r12/logs/appl/rgf/TXK/txkChangeFormsMode_Wed_May_15_10_56_04_2013.log

Program : /d01/oracle/PROD/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChangeFormsMode.pl started @ Wed May 15 10:56:04 2013

*** Log File = /d01/oracle/PROD/inst/apps/PROD_r12/logs/appl/rgf/TXK/txkChangeFormsMode_Wed_May_15_10_56_04_2013.log

Arguments passed: -contextfile=/d01/oracle/PROD/inst/apps/PROD_r12/appl/admin/PROD_r12.xml -mode=socket -port=9030 -runautoconfig=No

———–

Values used

———–

Context File   : /d01/oracle/PROD/inst/apps/PROD_r12/appl/admin/PROD_r12.xml

Mode           : socket

Port           : 9030

Run AutoConfig : No

Execute SYSTEM command : netstat –a

[applmgr@r12 scripts]$ $FND_TOP/bin/txkrun.pl -script=ChangeFormsMode -contextfile=$CONTEXT_FILE -mode=socket -port=9030 -runautoconfig=No

*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

*** Log File = /d01/oracle/PROD/inst/apps/PROD_r12/logs/appl/rgf/TXK/txkChangeFormsMode_Wed_May_15_10_56_04_2013.log

Program : /d01/oracle/PROD/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChangeFormsMode.pl started @ Wed May 15 10:56:04 2013

*** Log File = /d01/oracle/PROD/inst/apps/PROD_r12/logs/appl/rgf/TXK/txkChangeFormsMode_Wed_May_15_10_56_04_2013.log

Arguments passed: -contextfile=/d01/oracle/PROD/inst/apps/PROD_r12/appl/admin/PROD_r12.xml -mode=socket -port=9030 -runautoconfig=No

———–

Values used

———–

Context File   : /d01/oracle/PROD/inst/apps/PROD_r12/appl/admin/PROD_r12.xml

Mode           : socket

Port           : 9030

Run AutoConfig : No

Execute SYSTEM command : netstat –a

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

Backing up context file….

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

Context file backed up at: /d01/oracle/PROD/inst/apps/PROD_r12/logs/appl/rgf/TXK/Wed_May_15_10_56_04_2013/PROD_r12.xml

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

Changing to Socket Mode…….

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

Updating context Variable s_forms_servlet_serverurl….

Updated context Variable s_forms_servlet_serverurl to

Updating context Variable s_frmConnectMode….

Updated context Variable s_frmConnectMode to socket

Updating context Variable s_formsstatus….

Updated context Variable s_formsstatus to disabled

Updating context Variable s_formsserver_status….

Updated context Variable s_formsserver_status to enabled

Updating context Variable s_other_service_group_status….

Updated context Variable s_other_service_group_status to enabled

Updating context Variable s_formsport….

Updated context Variable s_formsport to 9030

Updating context Variable s_formslauncher_path….

Updated context Variable s_formslauncher_path to OA_HTML/frmservlet

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

You should run Autoconfig to update the runtime configurations to new Forms Mode.

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

 

Log file to change the Forms Mode :

/d01/oracle/PROD/inst/apps/PROD_r12/logs/appl/rgf/TXK/txkChangeFormsMode_Wed_May_15_10_56_04_2013.log

Program : /d01/oracle/PROD/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChangeFormsMode.pl completed @ Wed May 15 10:56:39 2013

End of /d01/oracle/PROD/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChangeFormsMode.pl : No Errors encountered

[applmgr@r12 scripts]$ sh adopmnctl.sh startall

You are running adopmnctl.sh version 120.6

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /d01/oracle/PROD/inst/apps/PROD_r12/logs/appl/admin/log/adopmnctl.txt for more information …

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

Backing up context file….

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

Context file backed up at: /d01/oracle/PROD/inst/apps/PROD_r12/logs/appl/rgf/TXK/Wed_May_15_10_56_04_2013/PROD_r12.xml

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

Changing to Socket Mode…….

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

Updating context Variable s_forms_servlet_serverurl….

Updated context Variable s_forms_servlet_serverurl to

Updating context Variable s_frmConnectMode….

Updated context Variable s_frmConnectMode to socket

Updating context Variable s_formsstatus….

Updated context Variable s_formsstatus to disabled

Updating context Variable s_formsserver_status….

Updated context Variable s_formsserver_status to enabled

Updating context Variable s_other_service_group_status….

Updated context Variable s_other_service_group_status to enabled

Updating context Variable s_formsport….

Updated context Variable s_formsport to 9030

Updating context Variable s_formslauncher_path….

Updated context Variable s_formslauncher_path to OA_HTML/frmservlet

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

You should run Autoconfig to update the runtime configurations to new Forms Mode.

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

 

Log file to change the Forms Mode :

/d01/oracle/PROD/inst/apps/PROD_r12/logs/appl/rgf/TXK/txkChangeFormsMode_Wed_May_15_10_56_04_2013.log

 

Program : /d01/oracle/PROD/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChangeFormsMode.pl completed @ Wed May 15 10:56:39 2013

 

End of /d01/oracle/PROD/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChangeFormsMode.pl : No Errors encountered

[applmgr@r12 scripts]$ sh adopmnctl.sh startall

 

You are running adopmnctl.sh version 120.6

 

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /d01/oracle/PROD/inst/apps/PROD_r12/logs/appl/admin/log/adopmnctl.txt for more information …

[applmgr@r12 scripts]$ sh adautocfg.sh

Enter the APPS user password:

 

The log file for this session is located at: /d01/oracle/PROD/inst/apps/PROD_r12/admin/log/05151113/adconfig.log

 

AutoConfig is configuring the Applications environment…

AutoConfig will consider the custom templates if present.

Using CONFIG_HOME location     : /d01/oracle/PROD/inst/apps/PROD_r12

Classpath                   : /d01/oracle/PROD/apps/apps_st/comn/java/lib/appsborg2.zip:/d01/oracle/PROD/apps/apps_st/comn/java/classes

Using Context file          : /d01/oracle/PROD/inst/apps/PROD_r12/appl/admin/PROD_r12.xml

 

Context Value Management will now update the Context file

Updating Context file…COMPLETED

Attempting upload of Context file and templates to database…COMPLETED

Configuring templates from all of the product tops…

Configuring AD_TOP……..COMPLETED

Configuring FND_TOP…….COMPLETED

Configuring ICX_TOP…….COMPLETED

Configuring MSC_TOP…….COMPLETED

Configuring IEO_TOP…….COMPLETED

Configuring BIS_TOP…….COMPLETED

Configuring AMS_TOP…….COMPLETED

Configuring CCT_TOP…….COMPLETED

Configuring WSH_TOP…….COMPLETED

Configuring CLN_TOP…….COMPLETED

Configuring OKE_TOP…….COMPLETED

Configuring OKL_TOP…….COMPLETED

Configuring OKS_TOP…….COMPLETED

Configuring CSF_TOP…….COMPLETED

Configuring IGS_TOP…….COMPLETED

Configuring IBY_TOP…….COMPLETED

Configuring JTF_TOP…….COMPLETED

Configuring MWA_TOP…….COMPLETED

Configuring CN_TOP……..COMPLETED

Configuring CSI_TOP…….COMPLETED

Configuring WIP_TOP…….COMPLETED

Configuring CSE_TOP…….COMPLETED

Configuring EAM_TOP…….COMPLETED

Configuring FTE_TOP…….COMPLETED

Configuring ONT_TOP…….COMPLETED

Configuring AR_TOP……..COMPLETED

Configuring AHL_TOP…….COMPLETED

Configuring OZF_TOP…….COMPLETED

Configuring IES_TOP…….COMPLETED

Configuring CSD_TOP…….COMPLETED

Configuring IGC_TOP…….COMPLETED

AutoConfig completed successfully.

 

 

 

 

[applmgr@r12 scripts]$ sh adopmnctl.sh startall

 

You are running adopmnctl.sh version 120.6

adopmnctl.sh: exiting with status 0

 

adopmnctl.sh: check the logfile /d01/oracle/PROD/inst/apps/PROD_r12/logs/appl/admin/log/adopmnctl.txt for more information …

 

[applmgr@r12 scripts]$ sh adformsrvctl.sh status

 

You are running adformsrvctl.sh  version 120.15.12010000.2

 

Checking status of FORMS Server (Socket Mode) …

 

Forms Server (Socket) is not running

adformsrvctl.sh: exiting with status 0

 

adformsrvctl.sh: check the logfile /d01/oracle/PROD/inst/apps/PROD_r12/logs/ora/10.1.2/forms/socket.log for more information …

 

[applmgr@r12 scripts]$ sh adformsrvctl.sh start

 

You are running adformsrvctl.sh  version 120.15.12010000.2

 

Starting FORMS Server in Socket Mode…

adformsrvctl.sh: exiting with status 0

 

adformsrvctl.sh: check the logfile /d01/oracle/PROD/inst/apps/PROD_r12/logs/ora/10.1.2/forms/socket.log for more information …

 

[applmgr@r12 scripts]$ sh adopmnctl.sh status

 

You are running adopmnctl.sh version 120.6

 

Checking status of OPMN managed processes…

 

Processes in Instance: PROD_r12.r12.ora.com

———————————+——————–+———+———

ias-component                    | process-type       |     pid | status

———————————+——————–+———+———

OC4JGroup:default_group          | OC4J:oafm          |   17341 | Alive

OC4JGroup:default_group          | OC4J:oacore        |   17340 | Alive

HTTP_Server                      | HTTP_Server        |   17339 | Alive

 

adopmnctl.sh: exiting with status 0

 

adopmnctl.sh: check the logfile /d01/oracle/PROD/inst/apps/PROD_r12/logs/appl/admin/log/adopmnctl.txt for more information …

 

[applmgr@r12 scripts]$

1

 

2

 

 

What is Forms Servlet Mode?

The Forms Listener Servlet is a Java servlet that delivers the ability to run Oracle Forms applications over HTTP and HTTPS connections. It manages the creation of a Forms Server Runtime process for each client, as well as network communications between the client and its associated Forms Server Runtime process.

The desktop client sends HTTP requests and receives HTTP responses from the web server. The HTTP Listener on the web server acts as the network endpoint for the client, keeping other servers and ports from being exposed at the firewall.

3

What is Forms Socket Mode?

Initial releases of the Oracle Forms Server product used a simple method for connecting the client to the server. The connection from the desktop client to the Forms Listener process was accomplished using a direct socket connection. The direct socket connection mode was suitable for companies providing thin client access to Forms applications within their corporate local area networks. For the direct socket connection mode, the client had to be able to see the server and had to have permission to establish a direct network connection.

Although the direct socket connection mode is perfectly suited for deployments within a company’s internal network, it’s not the best choice for application deployment via unsecured network paths via the Internet. A company connected to the Internet typically employs a strict policy defining the types of network connections that can be made by Internet clients to secure corporate networks. Permitting a direct socket connection from an external client exposes the company to potential risk because the true identity of the client can be hard to determine.

Servlet Mode Advantages

  1. HTTP and HTTPS traffic is easily recognizable by routers, while socket mode communications is generally considered suspect and treated on an exception basis.
  2. Existing networking hardware can be used to support basic functions such as load-balancing and packet encryption for network transit.
  3. More resilient to network and firewall reconfigurations.
  4. More robust: servlet connections can be re-established if network connections drop unexpectedly for Forms, Framework, and JSP-based pages.
  5. Is the only supported method for generic Oracle Forms customers, and therefore is more thoroughly tested by the Forms and E-Business Suite product groups.
  6. Performance traffic can be monitored via tools like Oracle Real User Experience Insight (RUEI).
  7. Socket mode is not supported on Windows-based server platforms.

Socket Mode Advantages

  1. Uses up to 40% less bandwidth than Forms servlet mode. This may be perceived by Wide Area Network (WAN) users as causing slower responsiveness, depending upon network latency.
  2. Uses fewer application-tier JVM resources than servlet mode, due to fewer TCP turns and lack of overhead associated with HTTP POST handling.

Switching Apps Deployments between Modes

Due to its numerous advantages, Forms servlet mode is the preferred and recommended deployment model for Forms on the web.

There may be circumstances where you need to switch between the default Forms modes. You might wish to switch your Oracle E-Business Suite Release 12 environment to socket mode to improve performance or reduce network load. You might wish to switch your Apps 11i environment to servlet mode as part of your rollout to external web-based end-users outside of your organization.

 

 

 

Posted October 29, 2013 by balaoracledba.com in OracleAppsR12

Oracle Session Related Queries   Leave a comment

Session Related Queries

1. Show all connected users
set lines 100 pages 999
col ID format a15
select username
, sid ‘,’ serial# “ID”
, status
, last_call_et “Last Activity”
from v$session
where username is not null
order by status desc
, last_call_et desc

2. Time since last user activity
set lines 100 pages 999
select username, floor(last_call_et / 60) “Minutes”, statusfrom v$sessionwhere username is not nullorder by last_call_et

3. Sessions sorted by logon time
set lines 100 pages 999
col ID format a15col osuser format a15
col login_time format a14
select username, osuser, sid ‘,’ serial# “ID”, status, to_char(logon_time, ‘hh24:mi dd/mm/yy’) login_time, last_call_etfrom v$sessionwhere username is not nullorder by login_time

4. Show user info including os pid
col “SID/SERIAL” format a10
col username format a15col
osuser format a15col
program format a40
select s.sid ‘,’ s.serial# “SID/SERIAL”, s.username, s.osuser, p.spid “OS PID”, s.programfrom v$session s, v$process pWhere s.paddr = p.addrorder by to_number(p.spid)

5. Show a users current sql
Select sql_textfrom v$sqlareawhere (address, hash_value) in(select sql_address, sql_hash_value from v$session where username like ‘&username’)

6. Session status associated with the specified os process id
select s.username, s.sid, s.serial#, p.spid, last_call_et, statusfrom V$SESSION s, V$PROCESS pwhere s.PADDR = p.ADDRand p.spid=’&pid’

7. All active sql
set feedback offset
serveroutput on size 9999
column username format a20
column sql_text format a55 word_wrapped
begin
for x in
(select username'(‘sid’,’serial#’) ospid = ‘ process ‘ program = ‘ program username,
to_char(LOGON_TIME,’ Day HH24:MI’) logon_time,
to_char(sysdate,’ Day HH24:MI’) current_time,
sql_address,
sql_hash_value from v$session
where status = ‘ACTIVE’ and rawtohex(sql_address) <> ’00’
and username is not null ) loop
for y in
(select sql_text from v$sqlarea where address = x.sql_address ) loop
if ( y.sql_text not like ‘%listener.get_cmd%’ and
y.sql_text not like ‘%RAWTOHEX(SQL_ADDRESS)%’ )
then dbms_output.put_line( ‘——————–‘ );
dbms_output.put_line( x.username );
dbms_output.put_line( x.logon_time ‘ ‘ x.current_time ‘ SQL#=’ x.sql_hash_value); dbms_output.put_line( substr( y.sql_text, 1, 250 ) );
end if;
end loop;
end loop;
end;
/
8. Display any long operations
set lines 100 pages 999
col username format a15
col message format a40
col remaining format 9999
select username, to_char(start_time, ‘hh24:mi:ss dd/mm/yy’) started, time_remaining remaining, messagefrom v$session_longops
where time_remaining = 0
order by time_remaining desc

9. List open cursors per user
set pages 999
select sess.username, sess.sid, sess.serial#, stat.value cursors
from v$sesstat stat, v$statname sn, v$session sess
where sess.username is not null
and sess.sid = stat.sid
and stat.statistic# = sn.statistic#
and sn.name = ‘opened cursors current’
order by value

 

Posted October 29, 2013 by balaoracledba.com in Oracle10g/11g

FIND WEBLOGIC version and FMW Oracle E-Business Suite Component Version on R12.2   2 comments

After Logging into the application set the environment to RUN Filesystem

. /u01/oracle/R122/EBSapps.env run

Then

cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION

You will get Below Output:

WLS_PRODUCT_VERSION=10.3.6.0

To find the FMW version Oracle E-Business Suite Component Version on R12.2

export ORACLE_HOME=/u01/oracle/R122/fs1/FMW_Home/Oracle_EBS-app1

./opatch lsinv

You will get below Output

Oracle E-Business Suite Component 11.1.1.6.0



Addidtion Info
*********************************************************************************************
Oracle WebLogic Server 10.3.6 in Oracle Fusion Middleware 11g Release 1 (11.1.1.6)
  • Oracle Fusion Middleware
    • 10.3.6 WebLogic Server (WLS)
    • 11.1.1.6 OHS (WebTier)

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

12c Unplugging and Plugging the Database in the Same Container Database-PART7   Leave a comment

Here we are going to unplug TESTPDB1 and plug again with different name as “pdb_plug_nocopy”

So here we have 1 Container Database
1 Seeded Pluggable Database
1 Pluggable databases

2

Close the database.

alter pluggable database TESTPDB1 close immediate;

29-10-2013 12-44-50

Unlug the closed TESTPDB1 and then specify the path and name of the XML file.

mkdir -p /u01/app/oracle/oradata/CDB/TESTPDB_PLUG1/

alter pluggable database TESTPDB1 unplug into ‘/u01/app/oracle/oradata/CDB/TESTPDB_PLUG1/TESTPDB_PLUG1.xml’;

29-10-2013 12-47-22

Drop the closed PDB and keep the data files.

drop pluggable database TESTPDB1 keep datafiles;

select pdb_name, status from cdb_pdbs where pdb_name=’TESTPDB1′;

29-10-2013 12-48-08

The unplugging operation makes changes in the TESTPDB1 data files to record that the PDB was properly and successfully unplugged.

move the datafiles of testpd1 from /u01/app/oracle/oradata/CDB/testpdb1 to /u01/app/oracle/oradata/CDB/TESTPDB_PLUG1/

also edit the /u01/app/oracle/oradata/CDB/TESTPDB_PLUG1/TESTPDB_PLUG1.xml as per the changed locations accordingly.

Checking the Compatibility of the Unplugged PDB with the Host CDB
Before starting the plugging operation, make sure that the to-be-plugged-in PDB is compatible with the new host CDB. Execution of the PL/SQL block raises an error if it is not compatible.

Execute the following PL/SQL block:

set serveroutput on
DECLARE
compatible BOOLEAN := FALSE;
BEGIN
compatible := DBMS_PDB.CHECK_PLUG_COMPATIBILITY(
pdb_descr_file => ‘/u01/app/oracle/oradata/CDB/TESTPDB_PLUG1/TESTPDB_PLUG1.xml’);
if compatible then
DBMS_OUTPUT.PUT_LINE(‘Is pluggable TESTPDB1 compatible? YES’);
else DBMS_OUTPUT.PUT_LINE(‘Is pluggable TESTPDB1 compatible? NO’);
end if;
END;
/

29-10-2013 12-57-29

Plugging the Unplugged TESTPDB1: NOCOPY Method
Use the data files of the unplugged PDB to plug the PDB into another CDB without any copy.

create pluggable database pdb_plug_nocopy using ‘/u01/app/oracle/oradata/CDB/TESTPDB_PLUG1/TESTPDB_PLUG1.xml’
NOCOPY
TEMPFILE REUSE;29-10-2013 12-58-13

This operation lasts a few seconds. The original data files of the unplugged PDB now belong to the new plugged-in PDB in the new host CDB. A file with the same name as the temp file specified in the XML file exists in the target location. Therefore, the TEMPFILE_REUSE clause is required.

Verify the status and open mode of the plugged PDB. Proceed to the next section, “Opening the Plugged PDB,” to finalize the plugging operation.
select pdb_name, status from cdb_pdbs where pdb_name=’pdb_plug_nocopy’;

select open_mode from v$pdbs where name=’pdb_plug_nocopy’;

List the data files of the plugged PDB.
select name from v$datafile where con_id=3;

29-10-2013 13-13-04

Open the Database

last

lllll

 

NOTE: TESTPDB2 is another Pluggable Database which was there already.

Posted October 29, 2013 by balaoracledba.com in 12cDatabase