Real Application Cluster

AskDBA.org Forum » Real Application Cluster

ORA-29760: instance_number parameter not specified (3 posts)

About This Topic

Tags

  1. daniesh

    member
    Joined: Nov '08
    Posts: 29

    offline

    Posted 2 years ago
    #

    Hi

    I have installed ASM on the cluster. its a 2 node cluter. i have installed pfile locally.
    i am not able to start asm instance using pfile.
    startup pfile=/u01/app/admin/+ASM/pfile/init+ASM.ora
    ORA-29760: instance_number parameter not specified.
    but i have mentioned the above parameter in my pfile.
    you can find below my pfile parameter setting.
    instance_type=asm
    +ASM1.instance_name=+ASM1
    +ASM2.instance_name=+ASM2
    +ASM1.instance_number=1
    +ASM2.instance_number=2

    I dont know where i am going wrong.

    please help me on this.

    Thanks,

  2. Amit Bansal

    Oracle DBA
    Joined: Jun '08
    Posts: 73

    offline

    Posted 2 years ago
    #

    Daniesh,

    I think you need to have pfile name as "init+ASM1.ora"

    -Amit

  3. Saurabh Sood

    admin
    Joined: Jun '08
    Posts: 46

    offline

    Posted 2 years ago
    #

    Hi,

    Try to put the following parameters in this pfile:
    *.cluster_database=true
    *.cluster_database_instances=2
    *.instance_type=asm

    Regards,
    Saurabh Sood

    Saurabh Sood
    Senior Consultant:DBA Services

Reply

You must log in to post.

AskDBA.org Forum » Real Application Cluster
251 posts in 104 topics over 45 months by 63 of 110 members. Latest: xiaoling, Williams29, Agatha