1 2 Previous Next 27 Replies Latest reply: Jan 28, 2013 4:35 AM by 936666 Go to original post RSS
      • 15. Re: Problemm in new database
        936666
        yes you are correct i have set oracle_home as
        set ORACLE_HOME=E:\app\pleelakr\product\11.2.0\*dbhome_1*
        now i'm able to resolve the issue.

        but at step 6 i am getting the error.
        • 16. Re: Problemm in new database
          sb92075
          LRM-00109: could not open parameter file 'E:\ORACLE\ORA11G\INIT.ORA'
          file above does NOT exist
          • 17. Re: Problemm in new database
            936666
            i deleted the file in the location and created new ora file and now able to get. dont know why but i am able to get now. :)

            SQL> create database ORA11G;
            create database ORA11G
            *
            ERROR at line 1:
            ORA-01501: CREATE DATABASE failed
            ORA-00200: control file could not be created
            ORA-00202: control file: '+DGRP2'
            ORA-17502: ksfdcre:4 Failed to create file +DGRP2
            ORA-15001: diskgroup "DGRP2" does not exist or is not mounted
            ORA-15077: could not locate ASM instance serving a required diskgroup
            ORA-29701: unable to connect to Cluster Synchronization Service
            • 18. Re: Problemm in new database
              sb92075
              933663 wrote:
              i deleted the file in the location and created new ora file and now able to get. dont know why but i am able to get now. :)

              SQL> create database ORA11G;
              create database ORA11G
              *
              ERROR at line 1:
              ORA-01501: CREATE DATABASE failed
              ORA-00200: control file could not be created
              ORA-00202: control file: '+DGRP2'
              ORA-17502: ksfdcre:4 Failed to create file +DGRP2
              ORA-15001: diskgroup "DGRP2" does not exist or is not mounted
              ORA-15077: could not locate ASM instance serving a required diskgroup
              ORA-29701: unable to connect to Cluster Synchronization Service
              why do you you flail from one error to another.
              • 19. Re: Problemm in new database
                936666
                Even following the steps cause error for me :(
                • 20. Re: Problemm in new database
                  yoonas
                  do you have ASM?

                  If not replace the '+DGRP2' to directory structure(where you want the files to be created) like 'e:\db'
                  • 21. Re: Problemm in new database
                    936666
                    No i did not have ASM
                    This is my database path E:\oracle\ORA11G
                    there now i am able to see the diag folder after running create SPFILE from PFILE='E:\oracle\ORA11G\init.ora'; command
                    on 8th step i failed
                    what are the steps to create the ASM files for my work.

                    Thanks!
                    • 22. Re: Problemm in new database
                      yoonas
                      I think you have to explore more on this before starting with manual database creation :)

                      running dbca will walk you through the steps and create a database for you.
                      db_create_file_dest='+DGRP2'
                      db_recovery_file_dest='+DGRP2'
                      db_create_online_log_dest_1='+DGRP2'
                      Modify the init to change the reference from diskgroup to directory
                      db_create_file_dest='E:\oracle\ORA11G\oradata'  
                      db_recovery_file_dest='E:\oracle\ORA11G\recovery'
                      db_create_online_log_dest_1='E:\oracle\ORA11G\oradata'
                      restart the with the modified init and try

                      >
                      command on 8th step i failed
                      >

                      Better post the complete error message

                      Edited by: yoonus on Jan 27, 2013 10:37 PM
                      • 23. Re: Problemm in new database
                        936666
                        SQL> create SPFILE from PFILE='E:\oracle\ORA11G\init.ora';

                        File created.

                        SQL> startup nomount
                        ORA-01261: Parameter db_create_file_dest destination string cannot be translated
                        ORA-01263: Name given for file destination directory is invalid
                        OSD-04018: Unable to access the specified directory or device.
                        O/S-Error: (OS 2) The system cannot find the file specified.
                        SQL> startup mount PFILE='E:\oracle\ORA11G\init.ora';


                        init.ora
                        db_name = 'ORA11G'
                        #Database name.
                        
                        db_create_file_dest='E:\oracle\ORA11G\oradata'  
                        #OMF configuration for Datafile,controlfile
                        db_create_online_log_dest_1='+DGRP2'
                        #OMF configuration for redolog file 
                        
                        db_recovery_file_dest='E:\oracle\ORA11G\recovery'
                        db_recovery_file_dest_size=10G
                        #FRA (FLASH RECOVERY AREA configuration)
                        
                        db_create_online_log_dest_1='E:\oracle\ORA11G\oradata'
                        #It is new feature with 11g for trace files (bdump,udump,cdump or many others
                        #folder created in "DIAG" folder inside "e:\oracle\ora11g" folder.
                        • 24. Re: Problemm in new database
                          936666
                          After i created oradata,recovery folder i am able to do it but on step 9 what to give instead of '+DGRP2'
                          • 25. Re: Problemm in new database
                            yoonas
                            Please create all these direcotries and make sure the path you specify can be accessed
                            E:\oracle\ORA11G\oradata
                            E:\oracle\ORA11G\recovery
                            E:\oracle\ORA11G\oradata
                            You can change the directory path i gave to the ones available on your system.
                            remove the below line also
                            db_create_online_log_dest_1='+DGRP2'
                            • 26. Re: Problemm in new database
                              yoonas
                              Come on

                              http://lmgtfy.com/?q=create+temporary+tablespace
                              create temporary tablespace TEMP TEMPFILE 'E:\oracle\ORA11G\oradata\temp01.dbf' size 5m;
                              
                              create tablespace USERDATA DATAFILE 'E:\oracle\ORA11G\oradata\userdata01.dbf' size 5m;
                              • 27. Re: Problemm in new database
                                936666
                                Thanks for your help!
                                1 2 Previous Next