System Copy in Unix

[Former Member]

Hi,

We are Restoring Backup of Production system to Quality Server.

SAP version is ECC 5.0. Database - Oracle 9.2.0.7.0. OS- HP Unix 5.1A

For that first of all we have installed UNIX Tru-64 on Quality Server.

Then after we have restored backup of production server on quality server.

Mounted file system on quality server.

Then applied OS patches similar to the patch level in Prod.

Then after created <SID>adm and ora<SID> users.

After all this, we tried to connect to database.

It is gettin connected, but we are unable to mount database.

<b>It is saying OS patched needs to be installed, whereas no patch is available in market now.</b>

Please do the needful to find cause of error.

Please suggest steps for copy in this manner.

Regards,

Payal Patel

[Former Member]

Hi Kamlesh,

I have copied part of pmon trace here...

after these all they have traced is some memory locations an all...

i have copied some of that part also...

please suggest anything...

/oracle/PRD/saptrace/background/prd_pmon_1310.trc

Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production

With the Partitioning option

JServer Release 9.2.0.7.0 - Production

ORACLE_HOME = /oracle/PRD/920_64

System name: OSF1

Node name: prdtest

Release: V5.1

Version: 1885

Machine: alpha

Instance name: PRD

Redo thread mounted by this instance: 0 <none>

Oracle process number: 2

Unix process pid: 1310, image: oracle@prdtest (PMON)

• SESSION ID:(1.1) 2007-08-17 09:36:15.834

error 472 detected in background process

ORA-00472: PMON process terminated with error

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x

49c210e18

sc_onstack: 0000000000000000, sc_mask 0000000000000000

pc: 0000000120c873ec, ps: 0000000000000008, ownedfp: 0000000000000001

r00: 0000000000000002

r01: 000000049c210870

r01: 000000049c210870

r02: 0000000000000003

r03: 0000000000000001

r04: 0000000140000758

r05: 000000011fffb4c8

r06: 000000011fffb2c8

r07: 0000000000000000

r08: 0000000000000000

r09: 0000000038000558

r10: 0000000000000002

r11: 00000001402a2200

r12: 0000000000000000

r13: 0000000058008ba0

r14: 0000000000000018

r15: 00000001402a2200

r16: 000000011fffb230

r17: 0000000000000007

r18: 0000000000000000

r19: 0000000000000000

r20: 0000000000000000

r21: 0000000000000000

r22: 0000000000000000

r23: 0000000000000000

r24: 0000000000000000

:

[Former Member]

Hi Friends,

Finally my problem is resolved after so much time...

It was due to one Unix patch, and SAP suggested that patch.

Thanks a lot for ur replies....

Regards,

Payal Patel

[Former Member]

Hi Fermin,

OS model is same for both the servers.

even patch level too is same.

I am trying with Oracle installation now.

Regards,

Payal Patel

[Former Member]

Hello,

The error is just bcoz of your PMON process is failed which is one of the most critical background process of oracle .....see the log shown as below in trace file

Errors in file /oracle/PRD/saptrace/background/prd_pmon_1346.trc:

ORA-00472: PMON process terminated with error

Thu Aug 16 12:59:22 2007

PMON: terminating instance due to error 472

Instance terminated by PMON, pid = 1346

Please send us the logfile of : /oracle/PRD/saptrace/background/prd_pmon_1346.trc for further interogation....

Regards,

kamlesh

[Former Member]

Hello.

I understand the OS model are not the same in Production and in QA, is it correct??

In that case backup-restore is not posible, copy should be performed with R3load tool.

Fermín.

[Former Member]

Hi,

We have verified backup twice.

This was our second attemp to restore.

We have confirmed with HP person that there is no problem at OS side.

We have tried setting kernel parameters with increased memory parameters, but that too could not help.

The note we refer for OS kernel parameter is 356370.

Did you find this issue related to Oracle?

Should we try with oracle installation?

Regards,

Payal Patel

Message was edited by:

Payal Patel

[Former Member]

Hello,

Very long back my friend had this..type issue.

He overcome this by installing some Oracle patch..exactly i don't remember..

If urgent take the help of Oracle also..post the issue in oracle metalink....!!

Note: Points always encourage me to reply !!

[Former Member]

Hi MSR ,

TNS Lost Contact error is solved now.

Following error came when tried to mount database for the first time:

ORA-00600: Internel error code, arguments [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]

And after this when tried for the second time it gave following error.

ORA-03113: end-of-file communication.

I am copying alert_<SID>.log for today's date.

Thu Aug 16 12:59:18 2007

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

SCN scheme 3

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up ORACLE RDBMS Version: 9.2.0.7.0.

System parameters with non-default values:

processes = 80

sessions = 96

timed_statistics = TRUE

event = 10183 trace name context forever, level 1, 10191 tr

ace name context forever, level 1, 10028 trace name context forever, level 1

shared_pool_size = 1006632960

enqueue_resources = 8000

control_files = /oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf, /oracle/PR

D/origlogA/cntrl/cntrlPRD.dbf, /oracle/PRD/saparch/cntrl/cntrlPRD.dbf

db_block_checksum = FALSE

db_block_size = 8192

db_cache_size = 2583691264

compatible = 9.2.0

log_archive_start = TRUE

log_archive_dest = /oracle/PRD/saparch/PRDarch

log_buffer = 1048576

log_checkpoint_interval = 0

db_files = 254

db_file_multiblock_read_count= 8

fast_start_mttr_target = 0

log_checkpoints_to_alert = TRUE

control_file_record_keep_time= 30

dml_locks = 2500

replication_dependency_tracking= FALSE

transactions_per_rollback_segment= 10

max_rollback_segments = 400

rollback_segments = PRS_0, PRS_1, PRS_2, PRS_3, PRS_4, PRS_5, PRS_6, PR

S_7, PRS_8, PRS_9, PRS_10, PRS_11, PRS_12, PRS_13, PRS_14, PRS_15, PRS_16, PRS_1

7, PRS_18, PRS_19

transaction_auditing = FALSE

remote_os_authent = TRUE

dblink_encrypt_login = TRUE

db_domain = world

hash_join_enabled = FALSE

background_dump_dest = /oracle/PRD/saptrace/background

user_dump_dest = /oracle/PRD/saptrace/usertrace

core_dump_dest = /oracle/PRD/saptrace/background

optimizer_features_enable= 9.2.0

sort_area_size = 2097152

sort_area_retained_size = 0

db_name = PRD

open_cursors = 800

optimizer_mode = choose

sortelimination_cost_ratio= 10

btree_bitmap_plans = FALSE

eliminatecommon_subexpr= FALSE

pushjoin_predicate = FALSE

optimizer_index_cost_adj = 10

optimpeek_user_binds = FALSE

Obsolete system parameters with specified values:

db_block_lru_latches

distributed_transactions

End of obsolete system parameter listing

Deprecated system parameters with specified values:

dblink_encrypt_login

End of deprecated system parameter listing

PMON started with pid=2

DBW0 started with pid=3

LGWR started with pid=4

CKPT started with pid=5

SMON started with pid=6

RECO started with pid=7

Thu Aug 16 12:59:21 2007

ARCH: STARTING ARCH PROCESSES

ARC0 started with pid=8

ARC0: Archival started

ARC1 started with pid=9

Thu Aug 16 12:59:21 2007

ARCH: STARTING ARCH PROCESSES COMPLETE

Thu Aug 16 12:59:21 2007

ARC1: Archival started

ARC1: Becoming the 'no FAL' ARCH

ARC1: Becoming the 'no FAL' ARCHARC1: Thread not mounted

Thu Aug 16 12:59:21 2007

ARC0: Becoming the heartbeat ARCH

ARC0: Becoming the heartbeat ARCHARC0: Thread not mounted

Thu Aug 16 12:59:22 2007

ALTER DATABASE MOUNT

Thu Aug 16 12:59:22 2007

Errors in file /oracle/PRD/saptrace/background/prd_pmon_1346.trc:

ORA-00472: PMON process terminated with error

Thu Aug 16 12:59:22 2007

PMON: terminating instance due to error 472

Instance terminated by PMON, pid = 1346

Thu Aug 16 12:59:22 2007

Errors in file /oracle/PRD/saptrace/background/prd_smon_1354.trc:

ORA-00472: PMON process terminated with error

Thu Aug 16 12:59:22 2007

Errors in file /oracle/PRD/saptrace/background/prd_ckpt_1352.trc:

ORA-00472: PMON process terminated with error

Thu Aug 16 12:59:22 2007

Errors in file /oracle/PRD/saptrace/background/prd_dbw0_1348.trc:

ORA-00472: PMON process terminated with error

Thu Aug 16 12:59:22 2007

Errors in file /oracle/PRD/saptrace/background/prd_lgwr_1350.trc:

ORA-00472: PMON process terminated with error

Thu Aug 16 12:59:22 2007

Errors in file /oracle/PRD/saptrace/background/prd_reco_1356.trc:

ORA-00472: PMON process terminated with error

Thu Aug 16 12:59:27 2007

USER: terminating instance due to error 1092

Instance terminated by USER, pid = 1361

Thu Aug 16 12:59:27 2007

SMON: terminating instance due to error 472

Instance terminated by SMON, pid = 1354

Thu Aug 16 12:59:27 2007

CKPT: terminating instance due to error 472

Instance terminated by CKPT, pid = 1352

Thu Aug 16 12:59:27 2007

DBW0: terminating instance due to error 472

Instance terminated by DBW0, pid = 1348

Thu Aug 16 12:59:27 2007

LGWR: terminating instance due to error 472

Instance terminated by LGWR, pid = 1350

Thu Aug 16 12:59:27 2007

RECO: terminating instance due to error 472

Instance terminated by RECO, pid = 1356

Regards,

Payal Patel

[Former Member]

Hello,

Verify the backup is successfully done or not.

Only don't change the backup volume name it must be target system =

<SID>.

Copy the above aft file name line from the source back<SID>.log to =

target<SID>.log file.

then

I think it seems to OS issue..........!!

Check memory allocations also !!

Note: Points always encourage me to reply !!

Message was edited by:

MSR

[Former Member]

Hello,

Please let me know the exact error message !!

[Former Member]

Please help if anyone has any idea...

We have restored the backup once again...

and now we are getting following error.

ORA-12547 TNS lost contact.

Regards,

Payal Patel