Database saide:-
=======================================================================
SQL> select name,status from v$database,v$instance;
NAME STATUS
--------- ------------
PROD OPEN
[oracle@apps15 11.1.0]$ lsnrctl status prod
LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 14-DEC-2016 15:23:45
Copyright (c) 1991, 2008, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=apps15.com)(PORT=1536)))
STATUS of the LISTENER
------------------------
Alias prod
Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date 14-DEC-2016 14:19:52
Uptime 0 days 1 hr. 3 min. 54 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/PROD/db/tech_st/11.1.0/network/admin/PROD_apps15/listener.ora
Listener Log File /u01/oracle/PROD/db/tech_st/11.1.0/log/diag/tnslsnr/apps15/prod/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps15.com)(PORT=1536)))
Services Summary...
Service "PROD" has 1 instance(s).
Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@apps15 bin]$ perl adbldxml.pl appsuser=apps appspass=apps
Starting context file generation for db tier..
Using JVM from /u01/oracle/PROD/db/tech_st/11.1.0/appsutil/jre/bin/java to execute java programs..
The log file for this adbldxml session is located at:
/u01/oracle/PROD/db/tech_st/11.1.0/appsutil/log/adbldxml_12141531.log
UnsatisfiedLinkError exception loading native library: njni11
Could not Connect to the Database with the above parameters, Please answer the Questions below
Enter Hostname of Database server: apps15.com
Enter Port of Database server: 1536
Enter SID of Database server: PROD
The context file has been created at:
/u01/oracle/PROD/db/tech_st/11.1.0/appsutil/PROD_apps15.xml
( OR )
Database context file creation:-
=======================================================================
[applmgr@apps15 admin]$ perl $COMMON_TOP/clone/bin/adclonectx.pl retrieve
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adclonectx Version 120.23.12010000.1
Running:
/u02/Apps/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u02/Apps/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/u02/Apps/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/u02/Apps/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.RetrieveContext
Log file located at /u02/Apps/inst/apps/PROD_apps15/appl/admin/RetrieveContext_12141552.log
Database Host [apps15]:
Database Host Domain [com]:
Database Port [1521]:1536
Database SID:PROD
APPS Schema Name [APPS]:
APPS Schema Password:apps
The following context files are available:
[1] PROD_apps15 (APPL_TOP Context)
[2] PROD_apps15 (Database Context)
Select the context to retrieve [1]:2
Destination file path [/u01/oracle/PROD/db/tech_st/11.1.0/appsutil/PROD_apps15.xml]:
Retrieved context file to /u01/oracle/PROD/db/tech_st/11.1.0/appsutil/PROD_apps15.xml
Log file location: /u02/Apps/inst/apps/PROD_apps15/appl/admin/RetrieveContext_12141552.log
Application Context file creation:-
=================================================================
[applmgr@apps15 admin]$ perl $COMMON_TOP/clone/bin/adclonectx.pl retrieve
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adclonectx Version 120.23.12010000.1
Running:
/u02/Apps/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u02/Apps/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/u02/Apps/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/u02/Apps/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.RetrieveContext
Log file located at /u02/Apps/inst/apps/PROD_apps15/appl/admin/RetrieveContext_12141549.log
Database Host [apps15]:
Database Host Domain [com]:
Database Port [1521]:1536
Database SID:PROD
APPS Schema Name [APPS]:
APPS Schema Password:apps
The following context files are available:
[1] PROD_apps15 (APPL_TOP Context)
[2] PROD_apps15 (Database Context)
Select the context to retrieve [1]:1
Destination file path [/u02/Apps/inst/apps/PROD_apps15/appl/admin/PROD_apps15.xml]:
Retrieved context file to /u02/Apps/inst/apps/PROD_apps15/appl/admin/PROD_apps15.xml
Log file location: /u02/Apps/inst/apps/PROD_apps15/appl/admin/RetrieveContext_12141549.log
=======================================================================
SQL> select name,status from v$database,v$instance;
NAME STATUS
--------- ------------
PROD OPEN
[oracle@apps15 11.1.0]$ lsnrctl status prod
LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 14-DEC-2016 15:23:45
Copyright (c) 1991, 2008, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=apps15.com)(PORT=1536)))
STATUS of the LISTENER
------------------------
Alias prod
Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date 14-DEC-2016 14:19:52
Uptime 0 days 1 hr. 3 min. 54 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/PROD/db/tech_st/11.1.0/network/admin/PROD_apps15/listener.ora
Listener Log File /u01/oracle/PROD/db/tech_st/11.1.0/log/diag/tnslsnr/apps15/prod/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps15.com)(PORT=1536)))
Services Summary...
Service "PROD" has 1 instance(s).
Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@apps15 bin]$ perl adbldxml.pl appsuser=apps appspass=apps
Starting context file generation for db tier..
Using JVM from /u01/oracle/PROD/db/tech_st/11.1.0/appsutil/jre/bin/java to execute java programs..
The log file for this adbldxml session is located at:
/u01/oracle/PROD/db/tech_st/11.1.0/appsutil/log/adbldxml_12141531.log
UnsatisfiedLinkError exception loading native library: njni11
Could not Connect to the Database with the above parameters, Please answer the Questions below
Enter Hostname of Database server: apps15.com
Enter Port of Database server: 1536
Enter SID of Database server: PROD
The context file has been created at:
/u01/oracle/PROD/db/tech_st/11.1.0/appsutil/PROD_apps15.xml
( OR )
Database context file creation:-
=======================================================================
[applmgr@apps15 admin]$ perl $COMMON_TOP/clone/bin/adclonectx.pl retrieve
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adclonectx Version 120.23.12010000.1
Running:
/u02/Apps/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u02/Apps/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/u02/Apps/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/u02/Apps/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.RetrieveContext
Log file located at /u02/Apps/inst/apps/PROD_apps15/appl/admin/RetrieveContext_12141552.log
Database Host [apps15]:
Database Host Domain [com]:
Database Port [1521]:1536
Database SID:PROD
APPS Schema Name [APPS]:
APPS Schema Password:apps
The following context files are available:
[1] PROD_apps15 (APPL_TOP Context)
[2] PROD_apps15 (Database Context)
Select the context to retrieve [1]:2
Destination file path [/u01/oracle/PROD/db/tech_st/11.1.0/appsutil/PROD_apps15.xml]:
Retrieved context file to /u01/oracle/PROD/db/tech_st/11.1.0/appsutil/PROD_apps15.xml
Log file location: /u02/Apps/inst/apps/PROD_apps15/appl/admin/RetrieveContext_12141552.log
Application Context file creation:-
=================================================================
[applmgr@apps15 admin]$ perl $COMMON_TOP/clone/bin/adclonectx.pl retrieve
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adclonectx Version 120.23.12010000.1
Running:
/u02/Apps/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u02/Apps/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/u02/Apps/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/u02/Apps/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.RetrieveContext
Log file located at /u02/Apps/inst/apps/PROD_apps15/appl/admin/RetrieveContext_12141549.log
Database Host [apps15]:
Database Host Domain [com]:
Database Port [1521]:1536
Database SID:PROD
APPS Schema Name [APPS]:
APPS Schema Password:apps
The following context files are available:
[1] PROD_apps15 (APPL_TOP Context)
[2] PROD_apps15 (Database Context)
Select the context to retrieve [1]:1
Destination file path [/u02/Apps/inst/apps/PROD_apps15/appl/admin/PROD_apps15.xml]:
Retrieved context file to /u02/Apps/inst/apps/PROD_apps15/appl/admin/PROD_apps15.xml
Log file location: /u02/Apps/inst/apps/PROD_apps15/appl/admin/RetrieveContext_12141549.log
No comments:
Post a Comment