3 Replies Latest reply on Aug 7, 2008 5:37 AM by 629992

    PeopleSoft Database creation manually on Windows, Oracle 10g error -

    652329
      Hi,

      Database creation manually on Windows..errore encountered... running script createdb10.sql

      ERROR at line 1:
      ORA-01501: CREATE DATABASE failed
      ORA-01100: database already mounted

      I am trying to install the PeopleTools 8.48 on Oracle 10g on windows XP and encountered the below error while running the createdb10.sql..

      I have followed all the steps given the installation guide... still no luck... Any idea friends..? I have installed the PeopleSoft few years back without any issues... but this titime I got stuck..

      I have edited the createdb10.sql
      ===================
      set echo on
      spool createdb.log

      SQL> -- startup nomount pfile=D:\oracle\product\10.2.0\db_1\database\initHRDMO.ora
      SQL>
      SQL> CREATE DATABASE HRDMO
      2 maxdatafiles 1021
      3 maxinstances 1
      4 maxlogfiles 8
      5 maxlogmembers 4
      6 CHARACTER SET WE8ISO8859P15
      7 NATIONAL CHARACTER SET UTF8
      8 DATAFILE 'D:\oracle\product\10.2.0\oradata\HRDMO\system01.dbf' SIZE 2000M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
      9 EXTENT MANAGEMENT LOCAL
      10 SYSAUX DATAFILE 'D:\oracle\product\10.2.0\oradata\HRDMO\sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
      11 DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'D:\oracle\product\10.2.0\oradata\HRDMO\temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
      12 UNDO TABLESPACE "PSUNDOTS" DATAFILE 'D:\oracle\product\10.2.0\oradata\HRDMO\psundots01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
      13 LOGFILE GROUP 1 ('D:\oracle\product\10.2.0\oradata\HRDMO\redo01.log') SIZE 100M,
      14 GROUP 2 ('D:\oracle\product\10.2.0\oradata\HRDMO\redo02.log') SIZE 100M,
      15 GROUP 3 ('D:\oracle\product\10.2.0\oradata\HRDMO\redo03.log') SIZE 100M;
      CREATE DATABASE HRDMO
      *
      ERROR at line 1:
      ORA-01501: CREATE DATABASE failed
      ORA-01100: database already mounted


      SQL> spool off