Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Using SWPM to clone a database to a new system

We are running Oracle 11.2.0.4 oh HP-UX 11.31 systems.

I have tired both and OFFLINE and then a database file copy from System A to System B.

When I get to the SWPM part where it does the backup/restore it fails.

I have done cloning databases outside of SAP tools so I think I know how to do it..

The first issue is that regardless of the way I move the datasbase the ALTER DATABASE RECOVER wants more archive logs... somehting that chokes the SAP tool.

So I thought I fixed it (tested by bringing the DB on System B up OK).  But now I can not get past the backup/Restore option.

In the pop-up I get:

An error occurred while processing option SAP NetWeaver 7.0 including Enhancement Package 3 > Software Life-Cycle Options > System Copy >Oracle > Target System Installation > Central System > Based on AS ABAP > Central System( Last error reported by the step: SQL statement or script failed. DIAGNOSIS: Error message: ORA-01012: not logged on ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 1803841536 bytes Fixed Size 2206448 bytes Variable Size 956302608 bytes Database Buffers 838860800 bytes Redo Buffers 6471680 bytes Database mounted. Database opened. File created. Database closed. Database dismounted. ORACLE instance shut down. ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 1803841536 bytes Fixed Size 2206448 bytes Variable Size 956302608 bytes Database Buffers 838860800 bytes Redo Buffers 6471680 bytes Database mounted. Database opened. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options . SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.)

So... what is causing hte ORA-01012: not logged on message?

I know what is causing the ORA-32004: obsolete or deprecated parameter

(s) specified for RDBMS instance, it is SAPs requirement in the use of

the remote_os_authentication parameter.

How do I get by these? I mean I know my "new" database is up fine but

I can't get past the Backup/Restore database option in SWPM.

If there was only a 'skip' button...


Thanks for ANY help

Vince

Tags:
Not what you were looking for? View more on this topic or Ask a question