Skip to Content

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 13, 2015 at 10:35 PM

    >>SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation<<

    Have you checked ora_sql_results.log log file?

    Just curious to know, why are you running SWPM if you are doing a backup and restore of the DB?

    As you have already installed Oracle and the OS is Unix why don't you just copy the SAP kernel, profiles and the environment files from the source to the target and adapt them?

    Cheers

    RB

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 14, 2015 at 08:28 AM

    Dear Vince,

    Another alternative to clone oracle db is copy the all datafile, orilog, and mirrlog from source system to target system. adapt the database structure using control file (control file adaptation is needed following target system condition). this method was worked for me.

    Please check this link:

    http://www.dba-oracle.com/oracle_tips_db_copy.htm

    Thanks & regards,

    Husin

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2015 at 01:44 PM

    Cloning the DB is not the issue, getting SWPM to recognize that it was already done is.

    Thanks for the link.

    Add comment
    10|10000 characters needed characters exceeded