2 Replies Latest reply: Nov 24, 2013 2:17 PM by user8860348 RSS

    Install HRCS9.0 and PT8.53 with Linux Issue: the files intiPT853.ora and initHRCS90.ora: maximum number of DB_FILES exceeded

    user8860348

      Folks,

       

      Hello. I have installed PeopleTools 8.53 with Oracle Linux 5.10 successfully. The entire PeopleTools  runs correctly in browser at the beginning.

      After I set up HCM and Campus Solution 9.0 Database Instance named HRCS90 in Linux successfully, PeopleTools 8.53 Database Instance PT853 cannot be mounted. Its error message is below:

       

      SQL> startup
      ORACLE instance started.

      Total System Global Area  538677248 bytes
      Fixed Size                  2146024 bytes
      Variable Size             528482584 bytes
      Database Buffers            4194304 bytes
      Redo Buffers                3854336 bytes
      ORA-00059: maximum number of DB_FILES exceeded

       

      In the file /home/user/OracleDB_Home/dbs/initPT853.ora, its parameter db_files has 3 values: small 400, medium 1021 and large 1500. The initial value is 1021 and it works correctly at the beginning.  But after set up another instance HRCS90, the above error message comes up and instance PT853 cannot mounted. I change the value of db_files from 1021 to 1500 in the file initPT853.ora and restart OS Linux. But get the same error as below:

       

      SQL> startup
      ORACLE instance started.

      Total System Global Area  538677248 bytes
      Fixed Size                  2146024 bytes
      Variable Size             528482584 bytes
      Database Buffers            4194304 bytes
      Redo Buffers                3854336 bytes
      ORA-00059: maximum number of DB_FILES exceeded


      In the file /home/user/OracleDB_Home/dbs/initHRCS90.ora, its parameter db_files has 3 values: small 80, medium 400 and large 1500. I use db_files=400 and it works correctly. I start up instance HRCS90 right after the above error message as below:

       

      SQL> shutdown immediate
      ORA-01507: database not mounted
      ORACLE instance shut down.

       

      SQL> exit
      Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options

       

      [user@userlinux bin]$ export ORACLE_SID=HRCS90
      [user@userlinux bin]$ ./sqlplus / as sysdba

      SQL*Plus: Release 11.1.0.6.0 - Production on Sat Nov 23 12:40:02 2013

      Copyright (c) 1982, 2007, Oracle.  All rights reserved.

      Connected to an idle instance.

       

      SQL> startup
      ORACLE instance started.

      Total System Global Area  538677248 bytes
      Fixed Size                  2146024 bytes
      Variable Size             528482584 bytes
      Database Buffers            4194304 bytes
      Redo Buffers                3854336 bytes
      Database mounted.
      Database opened.

       

      SQL> select * from psdbowner;

       

      DBNAME   OWNERID
        --------          --------
      HRCS90     MYNAME

       

      SQL>

       
      As we see above, the instance HRCS90 works corretly and PT853 cannot start up. The parameter DB_FILES of the file initPT853.ora has an issue.

       

      My question is:

      Because 1021 and 1500 are not enough to startup instance PT853, what value should be used for DB_FILES of the file initPT853.ora  ?

       

      Thanks.

       

        • 1. Re: Install HRCS9.0 and PT8.53 with Linux Issue: the files intiPT853.ora and initHRCS90.ora: maximum number of DB_FILES exceeded
          Nicolas.Gasparotto

          user8860348 wrote:

           

          Folks,

           

          Hello. I have installed PeopleTools 8.53 with Oracle Linux 5.10 successfully. The entire PeopleTools  runs correctly in browser at the beginning.

          After I set up HCM and Campus Solution 9.0 Database Instance named HRCS90 in Linux successfully, PeopleTools 8.53 Database Instance PT853 cannot be mounted.... 

          I'm sorry, but I don't understand what does "Instance" mean here.

           

          >In the file /home/user/OracleDB_Home/dbs/initPT853.ora, its parameter db_files has 3 values: small 400, medium 1021 and large 1500.

          Are you not using a spfile ? Does the file contain really the 3 values ? What is the last ? Have you checked the value in the database side "show parameter db_files" ?

           

          >But after set up another instance HRCS90, the above error message comes up and instance PT853 cannot mounted

          Again, I have no idea what it means.

           

          >In the file /home/user/OracleDB_Home/dbs/initHRCS90.ora, its parameter db_files has 3 values: small 80, medium 400 and large 1500. I use db_files=400 and it works correctly.

          Again, 3 values ? What is the last ? Have you checked the value in the database side "show parameter db_files" ?

           

          >As we see above, the instance HRCS90 works corretly and PT853 cannot start up. The parameter DB_FILES of the file initPT853.ora has an issue.

          Again, I don't understand what are HRCS90 and PT853 exactly. Cannot help.

           

          >Because 1021 and 1500 are not enough to startup instance PT853, what value should be used for DB_FILES of the file initPT853.ora  ?

          I'm sure, you don't have an issue with this parameter, 1500 files in the database is quite huge number. I built a demo recently, the default value 1021 was ok for me. You should have done something wrong somewhere.

           

          Nicolas.

          • 2. Re: Install HRCS9.0 and PT8.53 with Linux Issue: the files intiPT853.ora and initHRCS90.ora: maximum number of DB_FILES exceeded
            user8860348

            Folks,

            Hello. Thanks a lot for replying. I just check db_files parameter as below:

             

            SQL> sho parameter db_files;

             

            NAME                                 TYPE        VALUE
            ------------------------------------ ----------- ------------------------------
            db_files                             integer     80

             

            But in the file initPT853.ora, db_files=1021. I don't know why it becomes 80 in Database. I create SPFILE again as below:


            SQL> shutdown immediate
            ORA-01507: database not mounted
            ORACLE instance shut down.


            SQL> create spfile from pfile='/home/user/OracleDB_Home/dbs/initPT853.ora';

            File created.

             

            SQL> startup
            ORACLE instance started.

            Total System Global Area  538677248 bytes
            Fixed Size                  2146024 bytes
            Variable Size             528482584 bytes
            Database Buffers            4194304 bytes
            Redo Buffers                3854336 bytes
            Database mounted.
            Database opened.

             

            SQL> select * from psdbowner;

            DBNAME   OWNERID
            -------- --------
            PT853    MYNAME

             

            Database instance PT853 start up now! The issue is solved. Thanks a lot.