Skip to Content
author's profile photo Former Member
Former Member

Sourcing DB Migration

Hi All

We have following system landscape with Distributed installation with single DB Server for both QAS and PRD.

OS : Windows 2008

DB : Oracle 11.2

QAS SERVER : C01 (CE7.1 EHP1 SCS,CI) & SOURCING7.0

PRD SERVER : C02 (CE7.1 EHP1 SCS,CI) & SOURCING7.0

DB SERVER (Oracle 11g) : DB instance of C01

SOURCING DB for QAS

DB Instance of C02

SOURCING DB for PRD

Now Our OS Team, planned to move the QAS DB (DB instance of C01 & SOURCING DB of QAS) to new Server (Separate Hardware box).

Please let me know the best possible ways to migrate the DB instance to new Hardware.

Regards

Ponnusamy

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 16, 2011 at 01:01 AM

    If I understand correctly, you would like to move the QA DB to another server. Iu2019m assuming QA Sourcing is on its own schema. Using Oracleu2019s standard export and import capabilities, you should be able to do the migration. Your DBA should be able to assist you with this.

    Once the DB is imported into the new server, you would have to run the configure utility in Sourcing and select the u201CUpdate Database Connection Infou201D option. This would allow you to enter the new DB connection information so when the application starts it can connect to the new DB server.

    Regards,

    Vikram

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Vikram,

      Thanks for the answer. Yes Sourcing is in different DB schema,

      DB teams can export and import the schema in new server and I can run the configure file again with new server details and deploy new sca files.

      Can you give me the steps to point my CE7.1 to new DB server. Since its distributed installation, I want my SCS & PAS to point to the New DB Server(Database instance).

      Regards

      Ponnusamy

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.