Errors in new init parameters for Oracle 11g
SQL> startup nomount pfile=”C:\db\init.ora”; ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings ORA-00842: DB_BLOCK_BUFFERS cannot be set with SGA_TARGET or MEMORY_TARGET ORA-01078: failure in processing system parameters
Solution: comment out
#memory_target=1716518912
ORA-00382: 32768 not a valid block size, valid range [2048..16384]
This error refers to the OS having limitation on block size selection: General quide for block sizes per OS
AIX-Based Systems,Compaq Tru64 UNIX,HP 9000 Series HP-UX,Linux Intel,Sun SPARC Solaris, (Windows NT, 95, 98, 2000): Have a DB_BLOCK_SIZE capability of 2048 to 16384
Linux, Solaris,AIX, HP, Tru64: Have a DB_BLOCK_SIZE capability of 2048 to 32768
SQL> startup nomount pfile=”C:\db\init.ora”; ORA-00381: cannot use both new and old parameters for buffer cache size specification SQL>
Solution:
Comment out:
db_block_buffers
or
db_cache_size
Oracle Error:
SQL> startup nomount pfile=”C:\db\init.ora”;
ORA-00380: cannot specify db_##k_cache_size since 16K is the standard block size
Solution: Cannot define a non-standard block size the same size as the db_block_size
IF db_block_size=2048 then you cannot set db_2k_cache_size
IF db_block_size=4096 then you cannot set db_4k_cache_size
If db_block_size=16384 then you cannot set db_16k_cache_size
IF db_block_size=32768 then you cannot set db_32k_cache_size
Error: During use of RMAN utility the following is generated.
RMAN-00554: initialization of internal recovery manager package failed
RMAN-03000: recovery manager compiler component initialization failed
RMAN-06001: error parsing job step library
RMAN-01006: error signalled during parse
RMAN-00600: internal error, arguments [8083] [] [] [] []
LFI-00005: Free some memory failed in lfibrdt().
LFI-00004: Call to lfibgl() failed.
[oracle@mylinux1 bin]$
Check: Look at the storage configuration of both the RMAN binaries and location of backups. In this example the storage was OCFS, which can be used for both the backup pieces and the binaries, but not with the tag – datavolume.
/dev/mapper/oracle_home /rac1 ocfs2 _netdev,datavolume,nointr 0 0
1. Logon to the Oracle server as the root user.
2. Dismount the storage in question.
umount /rac1
3. Mount the storage without the datavolume tag.
mount /dev/mapper/oracle_home /rac1 ocfs2 _netdev,nointr 0 0
4. Update your /etc/fstab file with new entries.
This completes resolution of RMAN error due to use of OCFS storage.
Larry Catt, OCP
oracle@allcompute.com
www.allcompute.com
Error:
[oracle@mylinux1 bin]$ ./dbca -silent -deleteDatabase -sourceDB orcl -sysDBAUserName larry -sysDBAPassword larry
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-00845: MEMORY_TARGET not supported on this system
Solution:
1. Logon to the database as sysdba
2. Execute the command.
SQL> show parameter memory_target;
NAME TYPE VALUE
———————————— ———– ——————————
memory_target big integer 3104M
SQL>
3. Issue the command.
SQL> alter system reset memory_target;
System altered.
SQL>
4. Shutdown the database
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
5. Startup the database.
SQL> startup open
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 217157632 bytes
Fixed Size 2211928 bytes
Variable Size 159387560 bytes
Database Buffers 50331648 bytes
Redo Buffers 5226496 bytes
Database mounted.
Database opened.
SQL>
6. Execute command:
SQL> show parameter memory_target
NAME TYPE VALUE
———————————— ———– ——————————
memory_target big integer 0
SQL>
7. re-execute
[oracle@mylinux1 bin]$ ./dbca -silent -deleteDatabase -sourceDB orcl -sysDBAUserName larry -sysDBAPassword larry
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
[oracle@mylinux1 bin]$
This completes resolution of Oracle Error ORA-32004 – ORA-00845.
Larry Catt, OCP
oracle@allcompute.com
www.allcompute.com