Home » RDBMS Server » Enterprise Manager » AWR (10g r2)
AWR [message #325495] Fri, 06 June 2008 06:37 Go to next message
muhammed
Messages: 6
Registered: June 2008
Location: Pakistan
Junior Member
Can anyone please tell me how to tmake full use of Automatic Workload repository in database 10g release 2

and then after tht how to generate recommendations from ADDM and apply them

Thanks

Muhammed
Re: AWR [message #325498 is a reply to message #325495] Fri, 06 June 2008 06:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What did you already read from the documentation?

Regards
Michel
Re: AWR [message #325499 is a reply to message #325495] Fri, 06 June 2008 07:08 Go to previous messageGo to next message
muhammed
Messages: 6
Registered: June 2008
Location: Pakistan
Junior Member
the steps i read are all performed..u can see the file attached with my post!
maybe u wud have a better idea then as in whwats the mistake i m making

thanks
Re: AWR [message #325500 is a reply to message #325499] Fri, 06 June 2008 07:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ "u" is not and will never be a member of this forum
2/ Read forum guide
3/ There is no file attached
4/ Explain what you did
5/ Explain what you know
...

Regards
Michel
Re: AWR [message #325502 is a reply to message #325495] Fri, 06 June 2008 07:19 Go to previous messageGo to next message
muhammed
Messages: 6
Registered: June 2008
Location: Pakistan
Junior Member
[oracle@t2 ~]$ cd /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/bin
[oracle@t2 bin]$ ls
adcfgclone.pl adchkutl.sh adclonectx.pl adclone.pl
[oracle@t2 bin]$ ./adcfgclone.pl dbTier

Using Java from /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/bin/../jre
Enter the APPS user password:

JDBCCLASSES = /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc14.jar
XMLPCLASSES = /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar
LOCAL_CPATH = /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/java:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar: /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc14.jar

First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:

oracle
= oracle

dba
= dba

Running:
/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/java:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar: /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile.lst -stage /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone 2> /tmp/adcfgclone.err; echo $? > /tmp/adcfgclone.resEnter the APPS password : apps

Log file located at /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/bin/CloneContext_06051732.log

Provide the values required for creation of the new Database Context file.

Target hostname (virtual or normal) [t2]:

Target instance is a Real Application Cluster (RAC) instance (y/n) [n]:

Target System database name:test2

Target system base directory for source homes:/d01/oracle/test2

Target system utl_file accessible directories list:/usr/tmp

Number of DATA_TOP's on the target system [4]:1

Target system DATA_TOP 1:/d01/oracle/test2/db/apps_st/data

Target system RDBMS ORACLE_HOME directory:/d01/oracle/test2/db/tech_st/10.2.0

Do you want to preserve the Display set to 130.35.33.102:111.0 (y/n) [y] ?:

Do you want the the target system to have the same port values as the source system (y/n) [y] ?:
Complete port information available at /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/bin/out/test2_t2/portpool.lst

Backing up /d01/oracle/test2/db/tech_st/10.2.0/appsutil/test2_t2.xml to /d01/oracle/test2/db/tech_st/10.2.0/appsutil/test2_t2.xml.bak

Creating the new Database Context file from :
/d01/oracle/test2/db/tech_st/10.2.0/appsutil/template/adxdbctx.tmp

The new database context file has been created :
/d01/oracle/test2/db/tech_st/10.2.0/appsutil/test2_t2.xml

Log file located at /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/bin/CloneContext_06051732.log
Check logfile /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/bin/CloneContext_06051732.log for details.

Running Rapid Clone with command:
perl /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/bin/adclone.pl java=/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/bin/../jre mode=apply stage=/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/d01/oracle/test2/db/tech_st/10.2.0/appsutil/test2_t2.xml showProgress contextValidated=true
Running:
perl /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/bin/adclone.pl java=/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/bin/../jre mode=apply stage=/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/d01/oracle/test2/db/tech_st/10.2.0/appsutil/test2_t2.xml showProgress contextValidated=true

XMLPARSER: /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar
JDBC: /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc14.jar
CLASSPATH: /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc 14.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/java:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/oui/OraIn staller.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/oui/ewt3.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/j lib/oui/share.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/oui/srvm.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/c lone/jlib/ojmisc.jar
OUI CLASSPATH: /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/ oui/ewt3.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/oui/xmlparserv2.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil /clone/jlib/oui/share.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/oui/srvm.jar:/d01/oracle/test2/db/tech_st/10.2.0/ap psutil/clone/jlib/ojmisc.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar:/d01/oracle/test2/db/tech_st/10. 2.0/appsutil/clone/jlib/ojdbc14.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/java
Setting LD_LIBRARY_PATH to /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/oui/lib/linux
Beginning database tier Apply - Thu Jun 5 17:33:42 2008
/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/d01/oracle/test2/db/tech_st/10.2.0/oui -classpath /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc 14.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/java:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/oui/OraIn staller.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/oui/ewt3.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/j lib/oui/share.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/jlib/oui/srvm.jar:/d01/oracle/test2/db/tech_st/10.2.0/appsutil/c lone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTier -e /d01/oracle/test2/db/tech_st/10.2.0/appsutil/test2_t2.xml -stage /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone -showProgress
APPS Password : Log file located at /d01/oracle/test2/db/tech_st/10.2.0/appsutil/log/test2_t2/ApplyDBTier_06051733.log
\ 50% completed RC-50004: Fatal: Error occurred in ApplyDatabase:
RC-50014: Fatal: Execution of AutoConfig was failed

ERROR while running Apply...
Thu Jun 5 17:38:53 2008

ERROR: Failed to execute /d01/oracle/test2/db/tech_st/10.2.0/appsutil/clone/bin/adclone.pl
Re: AWR [message #325503 is a reply to message #325495] Fri, 06 June 2008 07:20 Go to previous messageGo to next message
muhammed
Messages: 6
Registered: June 2008
Location: Pakistan
Junior Member
heres the logile too

Please check logfile.
[oracle@t2 bin]$

Connected to an idle instance.
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.

Total System Global Area 1077936128 bytes
Fixed Size 2076584 bytes
Variable Size 427819096 bytes
Database Buffers 633339904 bytes
Redo Buffers 14700544 bytes

Control file created.

alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/d01/oracle/test3/db/apps_st/data/system01.dbf'


alter tablespace TEMP1 add tempfile '/d01/oracle/test3/db/apps_st/data/temp01.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open


alter tablespace TEMP2 add tempfile '/d01/oracle/test3/db/apps_st/data/temp02.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open


ALTER DATABASE RENAME GLOBAL_NAME TO "test3.luckyerp"
*
ERROR at line 1:
ORA-01109: database not open


ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.

Total System Global Area 1077936128 bytes
Fixed Size 2076584 bytes
Variable Size 427819096 bytes
Database Buffers 633339904 bytes
Redo Buffers 14700544 bytes
Database mounted.

PL/SQL procedure successfully completed.

ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.

Total System Global Area 1077936128 bytes
Fixed Size 2076584 bytes
Variable Size 427819096 bytes
Database Buffers 633339904 bytes
Redo Buffers 14700544 bytes

Control file created.

alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/d01/oracle/test3/db/apps_st/data/system01.dbf'


alter tablespace TEMP1 add tempfile '/d01/oracle/test3/db/apps_st/data/temp01.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open


alter tablespace TEMP2 add tempfile '/d01/oracle/test3/db/apps_st/data/temp02.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open


ALTER DATABASE RENAME GLOBAL_NAME TO "test3.luckyerp"
*
ERROR at line 1:
ORA-01109: database not open


Re: AWR [message #325510 is a reply to message #325503] Fri, 06 June 2008 08:02 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In order to be able to address the original question, you have to get a correct database.

Regards
Michel
Previous Topic: cloning steps
Next Topic: configuring oracle EM
Goto Forum:
  


Current Time: Thu Mar 28 12:14:13 CDT 2024