Forum Stats

  • 3,854,251 Users
  • 2,264,344 Discussions
  • 7,905,622 Comments

Discussions

DB upgrade on Siebel 16.0

d.candeloro
d.candeloro Member Posts: 5
edited Jul 8, 2020 1:53PM in Database Upgrade

Hi everybody,

my client has a Siebel 16.0 installation on Oracle Database 11.2.0.3.0. The DB version 11g will stop being supported at the end of the 2020, so my client wants to upgrade the DB to the supported version 12.2.0.1.0.

In order to let the Siebel works I guess I need to do the following tasks:

1. update the tnsnames.ora file with the new host/port

2. copy the Siebel schema from the previous db instance to the new DB instance.

Are there other steps I am not considering?

Thank you.

Best Regards,

Davide

Answers

  • Dude!
    Dude! Member Posts: 22,830 Black Diamond
    edited Jul 8, 2020 10:51AM

    Your client will probably want to update to 19c (12.2.0.3).

    What you might want to consider is updating the database to 11.2.0.4, so you have a direct DB upgrade path. Other than that your question is too vague and you need to ask more specifically. 

  • d.candeloro
    d.candeloro Member Posts: 5
    edited Jul 8, 2020 11:10AM

    According to Oracle Support the 19c version is not certified for working with Siebel IP2016.

    The last certified version is 12.2.0.1.0:

    Siebel is running on Oracle Database 11.2.0.3.0 now. So, suppose that we create a new instance of the database with version 12.2.0.1.0 and we copy the Siebel schema from the current db instance to the new one. What are the other steps to perform in order to let the Siebel works on the new instance of the DB?

    If my question is too vague, please let me know how I can help you understand my doubt.

    Best Regards,

    Davide

  • Dude!
    Dude! Member Posts: 22,830 Black Diamond
    edited Jul 8, 2020 12:24PM

    You're asking in the database upgrade forum. Upgrading the database is complex task.

    If your question is more about Siebel than DB specific, why aren't you asking in the Siebel forum:

  • d.candeloro
    d.candeloro Member Posts: 5
    edited Jul 8, 2020 1:53PM