OraFAQ Forum: Enterprise Manager

Home » RDBMS Server » Enterprise Manager » AWR (10g r2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

AWR [message #325495]

Fri, 06 June 2008 06:37

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

Report message to a moderator

Re: AWR [message #325498 is a reply to message #325495]

Fri, 06 June 2008 06:55

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What did you already read from the documentation?

Regards
Michel

Report message to a moderator

Re: AWR [message #325499 is a reply to message #325495]

Fri, 06 June 2008 07:08

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

Report message to a moderator

Re: AWR [message #325500 is a reply to message #325499]

Fri, 06 June 2008 07:10

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: AWR [message #325502 is a reply to message #325495]

Fri, 06 June 2008 07:19

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

Report message to a moderator

Re: AWR [message #325503 is a reply to message #325495]

Fri, 06 June 2008 07:20

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

Report message to a moderator

Re: AWR [message #325510 is a reply to message #325503]

Fri, 06 June 2008 08:02

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In order to be able to address the original question, you have to get a correct database.

Regards
Michel

Report message to a moderator

Previous Topic:	cloning steps
Next Topic:	configuring oracle EM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 21:43:19 CST 2024