DB copy

Hi,

We have a sol man installation with an oracle DB.

I want take a copy of sol man oracle db and use that in the new installation of sol man.

I know it is possible to use SAPinst to take copy of DB. Is anybody having any documentation?

Thanks

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

> We have a sol man installation with an oracle DB.

> I want take a copy of sol man oracle db and use that in the new installation of sol man.

> I know it is possible to use SAPinst to take copy of DB. Is anybody having any documentation?

Yes, this is call "homogeneous system copy" and is availabe at http://service.sap.com/instguides

You need to copy both ABAP + Java.

Markus

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Markus,

Is it possible to install a new SOL MAN on an new oracle DB and later on make a system copy of Old SOL MAN DB and move it on the new oracle DB?

Thanks

> Is it possible to install a new SOL MAN on an new oracle DB and later on make a system copy of Old SOL MAN DB and move it on the new oracle DB?

No.

But the system copy is done likewise.

Be aware of the fact, that a SolMan is ABAP + Java. Java stores lots of information also in the filesystem so you must execute sapinst on the source system and "pack" the Java part. Sapinst has an option for copying ABAP + Java systems, it's very straightforward. You only have to follow the guide.

For a backup scenario you always must backup the file system containing the J2EE engine at the same time as the database. If you just have the database this is not enough.

Markus

Thanks Again Markus,

Is it some documentation that I can use?

> Is it some documentation that I can use?

yes, as I posted above:

http://service.sap.com/instguides

--> SAP NetWeaver

--> SAP NetWeaver 7.0 (2004s)

--> Installation

Then in the middle part under "System copy" choose

For EHP1 - ABAP + Java

Markus

My SOLMAN installation is SAP NetWeaver 7.0 (2004s), but the System copy guide is for SAP Netweaver 7.0 EHP 1.

Can I use this guide for older version?

Thanks again

I thought you were on EHP1 with SolMan already.

Basically the procedure is the same, so yes.

Markus

Hi,

Yes, you can follow this guide as the procedure is same but if you still feel like you need the system copy guide for NW2004s, you can get it downloaded in the following path.

http://service.sap.com/instguides

--> SAP NetWeaver

--> SAP NetWeaver 7.0 (2004s)

--> Installation

In the last section, Drill down 2 - Installation - SAP NetWeaver Systems and then select the link System Copy for SAP Systems Based on NW 7.0 SR2 ABAP+Java to download the document.

Regards,

Varadharajan M

Hi again,

Should I stop my source system before take a copy of that?

Hi,

Yes!!!

If you use SAPINST, you can start the export process without stopping SAP, the SAPINST tool will prompt you to stop the SAP instances after the preparation steps.

Regards,

Varadharajan M

Hi and thanks again,

My source system is a production system.

Is it nessecery to take an offline back up of my source system before taking a copy of?

Is it possible that making an copy do some damage to my source system.

Thanks

Hi,

As far as I know, the system copy won't damage the source system as the system copy export will happen only when the SAP instance is down. But it is always good to have a backup of the database before doing such activities to be in the safer side.

Regards,

Varadharajan M

Hi,

After I make system copy and install new sap solman installation. I cannot start my visual admin or config tool?

Is it possible to start visual admin and configtool when sap server is down?

I can not start my java part of server but ABAP starting good. I get this error SAP-Basis System: Transaction Canceled BT .

Thanks

Hi,

To launch the Visual Admin or Config tool, you shold have ur DB up and runnin. BTW, whats the issue when u try to launch the configtool and visual admin ?

Hope you have completed all the post system copy activity in the new system as mentioned in the system copy guide ?

Regards,

Varadharajan M

Hi Varadharajan,

I did complete all post system copy and I completed with no error.

I can just start the ABAP part and not JAVA part. And when I try to start visual admin I get this massage.

Create and manage a personal list of connections or connect to a previously specified connections..

Thanks

Hi Reza,

Launch config tool and then update the Admin logon details in the secure store. Then restart the Java engine once and then try to launch Visual Admin. This would resolve ur issue.

Also have a look at this [thread|;.

Regards,

Varadharajan M

Hi Varadharajan,

It is working now :). I take copy of another SAP production system.

Now I should perform follow-up Activities for ABAP.

Du you know before I start SAP server what is the most important thing to do?

Du you know how for Oracle before starting the SAP system I can delete all entries from

DBSTATHORA, DBSTAIHORA, DBSTATIORA, DBSTATTORA this tables and delete the user OPS$ .

Thanks

Regards

Reza

yes, you can delete these table's contents safely.

Hi,

I hope You have followed All the steps mentioned in concerned SAP System copy guide.

You can open Config tool even though the Java Stack DB is not up.

For Starting of Visual Administration the Java Stack DB should be up.

Please check that Your Java stack is up or not ?

Regards,

Bhavik G. Shroff

Hi,

My SAP servere working and JAVA stsck is up. Should I use BRtools to delete this table?

Regards

Reza

you can delete entries from these tables. DO NOT delete these tables!

try this:

sqlplus / as sysdba

truncate table sapsr3.DBSTATHORA;

good luck.

Thanks,

Yes I know I want just delete the entries from this table. I will try that.

Du you know before I start SAP server what is the most important thing to do?

Redards

Reza

the whole procedure is in the homogeneous system copy guide. go get it at http://service.sap.com/systemcopy

Reza,

Good to hear that the Java is up and running If you are not sure about deleting the entries in the table, I'd ask u to get help from a DBA.

Regards,

Varadharajan M

Hi,

I want to delete these entries from these tables but when I do try form command prompt start sql to connect to Oracle with * sqlplus / as sysdba* I get this

Microsoft Windows [Version 5.2.3790]

C:\Documents and Settings\Administrator>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Aug 25 13:53:06 2010

ERROR:

ORA-12560: TNS:protocol adapter error

Enter user-name:

I have not any username or password.

The OracleSOT102TNSListener is start.

My Oracle DB is start and my SAP solman is start t00.

Regard

Reza

> C:\Documents and Settings\Administrator>sqlplus / as sysdba

> SQL*Plus: Release 10.2.0.4.0 - Production on Wed Aug 25 13:53:06 2010

> ERROR:

> ORA-12560: TNS:protocol adapter error

Yes - because you are logged in as administrator - that use doesn't have the proper environment. Administer your syste using <sid>adm.

Markus

Hi,

The user administrator will not be having the env variables set. SAPINST would have created the <SID>ADM user with all the required env variables set.

Better to use the <SID>ADM user to administer SAP as well as DB. Else set the env variables like ORACLE_HOME, PATH and all for the administrator.

Regards,

Varadharajan M

Hi and thanks,

Yes correct

Any idea how can I Delete the user OPS$ADM. And why?

Redards

you don't want leftovers from the previous installation with accesses from old SID.

DROP USER "OPS$SAP\PRDADM" CASCADE;

DROP USER "OPS$SAP\ORAPRD" CASCADE;

Answers (0)

Ask a Question

Top Q&A Solution Author

User

Count

DB copy

Accepted Solutions (1)

Accepted Solutions (1)

Answers (0)

Struggling with Filters on Select - Fiori App

Re: How can I save Requirement in Cloud ALM

Re: How can I save Requirement in Cloud ALM

Re: fuzzy search with multiple name fields

SAC: Find drill level in hierarchy based on string