This discussion is archived
1 2 Previous Next 27 Replies Latest reply: Jan 28, 2013 2:35 AM by 936666 Go to original post RSS
  • 15. Re: Problemm in new database
    936666 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    LRM-00109: could not open parameter file 'E:\ORACLE\ORA11G\INIT.ORA'
    file above does NOT exist
  • 17. Re: Problemm in new database
    936666 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Even following the steps cause error for me :(
  • 20. Re: Problemm in new database
    yoonas Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Thanks for your help!
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points