Results 1 to 5 of 5

Thread: Ora_01504

  1. #1
    Join Date
    Mar 2013
    Posts
    11

    Unhappy Unanswered: Ora_01504

    CREATE DATABASE ass2_db
    USER SYS IDENTIFIED BY sys
    USER SYSTEM IDENTIFIED BY system
    LOGFILE GROUP 1 ('c:\oracle\oradata\redo01a.log') SIZE 100M ,
    GROUP 2 ('c:\oracle\oradata\redo02a.log') SIZE 100M ,
    GROUP 3 ('c:\oracle\oradata\redo03a.log') SIZE 100M
    MAXLOGFILES 5
    MAXLOGMEMBERS 5
    MAXLOGHISTORY 1
    MAXDATAFILES 100
    CHARACTER SET US7ASCII
    NATIONAL CHARACTER SET AL16UTF16
    EXTENT MANAGEMENT LOCAL
    DATAFILE 'c:\oracle\oradata\system01.dbf' SIZE 325M REUSE
    SYSAUX DATAFILE 'c:\oracle\oradata\sysaux01.dbf' SIZE 325M REUSE
    DEFAULT TABLESPACE users
    DATAFILE 'c:\oracle\oradata\users01.dbf'
    SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
    DEFAULT TEMPORARY TABLESPACE tempts1
    TEMPFILE 'c:\oracle\oradata\temp01.dbf'
    SIZE 20M REUSE
    UNDO TABLESPACE undotbs
    DATAFILE 'c:\oracle\oradata\undotbs01.dbf'
    SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;


    ora_01504 database name 'ass2_db 'doesn't match parameter db_name 'orcl'

    help please

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    01504, 00000, "database name '%s' does not match parameter db_name '%s'"
    // *Cause:  The name in a database create or mount does not match the name
    //          given in the INIT.ORA parameter db_name.
    // *Action: correct or omit one of the two names.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    ORA-01504: database name 'string' does not match parameter db_name 'string'

    Cause: The name in a database create or mount does not match the name given in the INIT.ORA parameter db_name.

    Action: correct or omit one of the two names.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  4. #4
    Join Date
    Mar 2013
    Posts
    11

    but how

    I have changed the sid and the sid home
    and I have changed the init.ora file from orcl to ass2_db

    I'm lost

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I'm lost
    Moss grows on the North side of trees.
    Can you find your way home?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •