Q: cssd is not started on reboot (no process name matches cssd.bin although there're ocssd), and so ASM and database instances are not started. A: /dev/raw/raw* may be owned by root after reboot. Run chown oracle:dba /dev/raw/raw* /etc/init.d/init.cssd start sleep 90 export ORACLE_SID=+ASM1 sqlplus / as sysdba startup export ORACLE_SID=RACDB1 sqlplus / as sysdba startup Add the above chown line to the end of /etc/rc.d/rc.local so the ownership persists after reboot. Q: sqlplus / as sysdba throws ORA-1031 (insufficient privileges) on Linux/UNIX. But sqlplus sys/oracle as sysdba works. A: Make sure $ORACLE_HOME/network/admin/sqlnet.ora does not have SQLNET.AUTHENTICATION_SERVICES=(NTS) Q: ASM instance is up and v$asm_disgroup shows MY_DG2 is mounted. This command srvctl modify instance -d racdb -i racdb1 -s +ASM1 per Note:276208.1 is run. But startup the database instance throws ORA-205 (error in identifying control file): Wed Jan 18 14:42:07 2006 ORA-00202: control file: '+MY_DG2/racdb/controlfile/current.260.562151423' ORA-17503: ksfdopn:2 Failed to open file +MY_DG2/racdb/controlfile/current.260.562151423 ORA-15001: diskgroup "MY_DG2" does not exist or is not mounted ORA-15055: unable to connect to ASM instance ORA-01031: insufficient privileges Wed Jan 18 14:42:07 2006 ORA-205 signalled during: ALTER DATABASE MOUNT... Shutting down instance: further logons disabled A: SQLNET.AUTHENTICATION_SERVICES should not be set to NTS on Linux/UNIX and must be set to NTS on Windows. Database instance startup must login without specifying password (orapwd file must be used so make sure that's set correctly; if necessary, recreate orapwd). http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10739/storeman.htm says [On ASM, startup] MOUNT Mounts the disk groups specified in the ASM_DISKGROUPS initialization parameter NOMOUNT Starts up the ASM instance without mounting any disk groups Here's my +ASM1: SQL> select * from v$database; select * from v$database * ERROR at line 1: ORA-01507: database not mounted SQL> startup mount ORA-01081: cannot start already-running ORACLE - shut it down first SQL> select instance_name, status, parallel, logins, database_status, instance_role from v$instance; INSTANCE_NAME STATUS PAR LOGINS DATABASE_STATUS INSTANCE_ROLE ---------------- ------------ --- ---------- ----------------- ------------------ +ASM1 STARTED YES ALLOWED ACTIVE UNKNOWN 'STARTED' status means startup nomount. So does 'UNKNOWN' instance_role. -------------------------------------------------------------------------------- column parameter format a37 column description format a30 word_wrapped column "Session Value" format a10 column "Instance Value" format a10 select a.ksppinm "Parameter", a.ksppdesc "Description", b.ksppstvl "Session Value", c.ksppstvl "Instance Value" from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx and a.ksppinm like '%asm%' escape '\' order by 1 / Parameter Description Session Va Instance V ------------------------------------- ------------------------------ ---------- ---------- _asm_acd_chunks initial ACD chunks created 1 1 _asm_allow_only_raw_disks Discovery only raw devices TRUE TRUE _asm_allow_resilver_corruption Enable disk resilvering for FALSE FALSE external redundancy _asm_ausize allocation unit size 1048576 1048576 _asm_blksize metadata block size 4096 4096 _asm_disk_repair_time seconds to wait before 14400 14400 dropping a failing disk _asm_droptimeout timeout before offlined disks 60 60 get dropped (in 3s ticks) _asm_emulmax max number of concurrent disks 10000 10000 to emulate I/O errors _asm_emultimeout timeout before emulation 0 0 begins (in 3s ticks) _asm_kfdpevent KFDP event 0 0 _asm_libraries library search order for ufs ufs discovery _asm_maxio Maximum size of individual I/O 1048576 1048576 request _asm_stripesize ASM file stripe size 131072 131072 _asm_stripewidth ASM file stripe width 8 8 _asm_wait_time Max/imum time to wait before 18 18 asmb exits _asmlib_test Osmlib test event 0 0 _asmsid ASM instance id asm asm asm_diskgroups disk groups to mount MY_DG1, MY MY_DG1, MY automatically _DG2 _DG2 asm_diskstring disk set locations for discovery asm_power_limit number of processes for disk 1 1 rebalancing 20 rows selected. -------------------------------------------------------------------------------- http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10739/storeman.htm says ASM shutdown NORMAL means "ASM waits for the connected ASM instances (and other ASM SQL sessions) to exit before shutting down the instance." It probably means "connected database instances (and other database SQL sessions)". SQL> shutdown ORA-15097: cannot SHUTDOWN ASM instance with connected RDBMS instance SQL> shutdown normal ORA-15097: cannot SHUTDOWN ASM instance with connected RDBMS instance SQL> select instance_name, db_name, status from v$asm_client; INSTANCE_NAME DB_NAME STATUS ---------------------------------------------------------------- -------- ------------ RACDB1 RACDB CONNECTED -------------------------------------------------------------------------------- CREATE TABLESPACE TEST db_create_file_dest is set to '+MY_DG2'. create tablespace testts; dba_tablespaces shows: initial_extent=65536, LMT, sysetm allocation, ASSM dba_data_files shows: filename='+MY_DG2/racdb/datafile/testts.273.579021687', bytes=100mb, blocks=12800, autoextensible='YES', maxbytes=3.4360E+10, maxblocks=4194302, increment_by=12800, user_blocks=12792 (8 blocks smaller than total blocks) create tablespace testts datafile '+MY_DG2' size 1m; dba_tablspaces shows the same dba_data_files shows: filename='+MY_DG2/racdb/datafile/testts.273.579021797', bytes=1048576, blocks=128, auto='NO', maxbytes=0, increment=0, user_blocks=120 create tablespace testts datafile '+MY_DG2' size 1m extent management local uniform size 128k; dba_tablespaces shows: initial/next extent=131072, min_extents=1, max=2147483645, allocation='UNIFORM' dba_data_files shows: blocks=128, user_blocks=112 (16 blocks smaller) -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------