Modify init.ora of CDB instance - Intergraph Smart Materials - Version 10.1 - Installation & Upgrade - Hexagon

Intergraph Smart Materials Installation (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Installation & Upgrade
Smart Materials/Smart Reference Data Version
10.1
  1. Open a Command Prompt as administrator.

  2. Set oracle_home=C:\oracle\19c_Sta\db

  3. Set oracle_sid=CDB

  4. sqlplus /nolog

  5. conn sys/<sys_password> as sysdba

  6. create pfile from spfile;

  7. edit <oracle_home>\database\init<SID>.ora

    Change these parameters:

    Processes = 600

    Open_cursors = 1300

    Compatible = 19.7.0

    Add this parameter:

    *.Sessions = 1000

  8. Save the file.

  9. Shutdown immediate.

    The PDB instance will shutdown automatically if you shut down the CDB instance.

  10. conn sys/<sys_password>@<SID of CDB> as sysdba.

  11. create spfile from pfile;

  12. startup