2 Replies Latest reply: Jan 4, 2014 12:50 PM by fb767351-a660-4b18-9a9f-73bc141f6a0c RSS

    ORA-01506: missing or illegal database name

    fb767351-a660-4b18-9a9f-73bc141f6a0c

      Hi Gurus/Experts,

       

      I am implementing  dataguard for digaster consideration for my primary database mydb. I have changed some initilization parameter for this implementation and while doing this when I changed a paraneter like below:

       

      SQL> alter system set db_file_name_convert="'/u01/app/oracle/oradata/mydb_un', '/u01/app/oracle/oradata/orcl_un'" scope=spfile;

       

      System altered.

       

      Because this parameter is static so I have restart my database with startup force option. But I am getting belwo error.:

       

      SQL> startup force

      ORA-01506: missing or illegal database name

       

      Below is my entries in $ORACLE_HOME/dbs location :

       

      hc_mydb.dat  initmydb.ora  init.ora  lkMYDB  lkMYDB_UN  orapwmydb  spfilemydb.ora


      And below is my current pfile entry:


      [oracle@localhost dbs]$ more initmydb.ora

      mydb.__db_cache_size=67108864

      mydb.__java_pool_size=4194304

      mydb.__large_pool_size=4194304

      mydb.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

      mydb.__pga_aggregate_target=171966464

      mydb.__sga_target=243269632

      mydb.__shared_io_pool_size=0

      mydb.__shared_pool_size=155189248

      mydb.__streams_pool_size=4194304

      *.audit_file_dest='/u01/app/oracle/admin/mydb/adump'

      *.audit_trail='db'

      *.compatible='11.2.0.0.0'

      *.control_files='/u01/app/oracle/oradata/mydb/control01.ctl','/u01/app/oracle/flash_recovery_area/mydb/control02.ctl'

      *.db_block_size=8192

      *.db_domain=''

      *.db_name='mydb'

      *.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'

      *.db_recovery_file_dest_size=4294967296

      *.db_unique_name='mydb_un'

      *.diagnostic_dest='/u01/app/oracle'

      *.dispatchers='(PROTOCOL=TCP) (SERVICE=mydbXDB)'

      *.log_archive_config='DG_CONFIG=(mydb_un,orcl_un)'

      *.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST REOPEN=8 MAX_FAILURE=4'

      *.log_archive_dest_2='SERVICE=orcl delay=10 db_unique_name=orcl_un'

      *.memory_target=413138944

      *.open_cursors=300

      *.processes=150

      *.remote_login_passwordfile='EXCLUSIVE'

      *.undo_tablespace='UNDOTBS1'

       

       

      Please help me to get it relsove and let me know what wrong I did.

       

       

      Regards,

      Michel

        • 1. Re: ORA-01506: missing or illegal database name
          mseberg

          Michel;

           

          I would expect you have both a Primary and Standby  INIT file and you are showing the correct one.

           

          From the information you posted I'm guessing either you did not try to start the database with a user with SYSDBA for example SYSTEM won't work. Or you set your SID incorrectly.

           

          Best Regards

           

          mseberg

          • 2. Re: ORA-01506: missing or illegal database name
            fb767351-a660-4b18-9a9f-73bc141f6a0c

            Hi Mseberg,

             

            As of now I do not have standby INIT file and one which INIT file which I am showing here that's for my primary database i.e mydb. I would like to let you know I am planning to implement dataguard where mydb would be my primary database ad orcl would be my stabd by database. Before creating standby database I am preparing all initilization parameter in my primary database.

             

            I have started my database with SYSDBA but still getting the same error. Please check below:

             

            [oracle@localhost ~]$ . oraenv

            ORACLE_SID = [oracle] ? mydb

            The Oracle base for ORACLE_HOME=/u01/home/oracle/product/11.2.0/db_1 is /u01/app/oracle

            [oracle@localhost ~]$ sqlplus / as sysdba

             

             

            SQL*Plus: Release 11.2.0.1.0 Production on Sun Jan 5 00:15:12 2014

             

             

            Copyright (c) 1982, 2009, Oracle.  All rights reserved.

             

             

            Connected to an idle instance.

             

             

            SQL> startup

            ORA-01506: missing or illegal database name

             

            Regards,

            Michel