ORA-01078, LRM-00110

ORA-01078: failure in processing system parameters Cause: Failure during processing of INIT.ORA parameters during system startup. Action: Further diagnostic information should be in the error stack.

LRM-00110: syntax error at "string" Cause: A syntax error was detected. Action: Change the input so that the correct syntax is used. Note: LRM errors are parameter messages.

Example: SQL> startup nomount pfile=/fs/u02/oracle/admin/mydb/pfile/initmydb.ora create database …… LRM-00110: syntax error at 'ache' ORA-01078: failure in processing system parameters create database mydb * ERROR at line 1: ORA-01034: ORACLE not available Reason: The script failed with an Oracle parameter error LRM-00110. Check the init.ora file and it looks like this: $ more /fs/u02/oracle/admin/mydb/pfile/initmydb.ora ache and I/O ########################################### db_block_size=8192 db_file_multiblock_read_count=8 Solution: fix the syntax error, the init.ora file looks like: $ more /fs/u02/oracle/admin/mydb/pfile/initmydb.ora ########################################### # Cache and I/O ########################################### db_block_size=8192 db_file_multiblock_read_count=8

Last updated: August 25, 2009

All Oracle errors in the blog can be found at: Oracle errors
All ESRI ArcSDE errors in the blog can found at: ArcSDE Errors

ORA-01157

ORA-01157: cannot identify/lock data file string - see DBWR trace file Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However the first instance to open the database will need to access all online data files. Accompanying error from the operating system describes why the file could not be identified. Action: Have operating system make file available to database. Then either open the database or do ALTER SYSTEM CHECK DATAFILES.

Note: The error happened when creating a tablespace: create tablespace TBS datafile '/u02/oracle/MYDB/tbs01.dbf' size 50M extent management local autoallocate segment space management auto; ERROR at line 1: ORA-01157: cannot identify/lock data file 12 - see DBWR trace file ORA-01110: data file 12: '/u02/oracle/MYDB/tbs01.dbf'

Last updated: August 24, 2009

All Oracle errors in the blog can be found at: Oracle errors
All ESRI ArcSDE errors in the blog can found at: ArcSDE Errors

ORA-01033

ORA-01033: ORACLE initialization or shutdown in progress Cause: An attempt was made to log on while Oracle is being started up or shutdown. Action: Wait a few minutes. Then retry the operation.

sde.log: % sdemon -o start Please enter ArcSDE DBA password: ------------------------------------------------------- ArcSDE 9.2 for Oracle10g Build 1206 Fri Oct 19 08:31:29 2007 ------------------------------------------------------- Reading /apps/sde/sdedb/etc/dbinit.sde: set ORACLE_HOME = /oracle/product/10.2.0.3se set ORACLE_SID = sdedb unset TWO_TASK DB_open_instance()::db_connect (OCI8) error: 1033 init_DB DB_instance_open_as_dba: -51 DBMS error code: 1033 ORA-01033: ORACLE initialization or shutdown in progress Could not start ArcSDE -- Check Network, $SDEHOME disk, DBMS settings and dbinit.sde.

Last updated: August 24, 2009

All Oracle errors in the blog can be found at: Oracle errors
All ESRI ArcSDE errors in the blog can found at: ArcSDE Errors

More Oracle DBA tips, please visit Oracle DBA Tips  

How to determine a Solaris OS is 32 bits or 64 bits by using isainfo

isainfo command can be used to determine whether a Solaris system has 32–bit or 64-bit capabilities enabled.

Option	Note	Examples on SPARC system
	Display the name or names of the native instruction sets for applications supported by the current OS version.	$ isainfo sparcv9 sparc
-v	Prints detailed information about the other options	$ isainfo -v 64-bit sparcv9 applications vis2 vis 32-bit sparc applications vis2 vis v8plus div32 mul32 $ isainfo -v 32-bit sparc applications
-b	Prints the number of bits in the address space of the native instruction set.	$ isainfo -b 64
-n	Prints the name of the native instruction set used by portable applications supported by the current version of the OS.	$ isainfo -n sparcv9
-k	Prints the name of the instruction set or sets that are used by the OS kernel components such as device drivers and STREAMS modules.	$ isainfo -k sparcv9

Last updated: August 5, 2009

how to find who and what sql is using temp segments

For 8.1.7 to 9.2	SELECT a.username, a.sid, a.serial#, a.osuser, b.tablespace, b.blocks, c.sql_text FROM v$session a, v$sort_usage b, v$sqlarea c WHERE a.saddr = b.session_addr AND c.address= a.sql_address AND c.hash_value = a.sql_hash_value ORDER BY b.tablespace, b.blocks;
For 10.1 and above	SELECT a.username, a.sid, a.serial#, a.osuser, b.tablespace, b.blocks, c.sql_text FROM v$session a, v$tempseg_usage b, v$sqlarea c WHERE a.saddr = b.session_addr AND c.address= a.sql_address AND c.hash_value = a.sql_hash_value ORDER BY b.tablespace, b.blocks;

Last updated: August 4, 2009