Home » RDBMS Server » Server Administration » problem after installing ASM instance (10g on linux redhat 4)
icon1.gif  problem after installing ASM instance [message #421975] Sat, 12 September 2009 11:02 Go to next message
samiraly
Messages: 57
Registered: June 2009
Member

after the instalation of ASM instance when i try to open sqlplus to start the instance it errors out
[asmuser@test dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Sep 12 05:59:04 2009

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

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/asminstance/dbs/initasminstance.ora'
SQL>




instance name is asminstance
oracle home /u01/app/oracle/product/10.2.0/asminstance


[asmuser@test dbs]$ pwd
/u01/app/oracle/product/10.2.0/asminstance/dbs
[asmuser@test dbs]$ ls -ltr
total 48
-rw-r-----  1 asmuser oinstall  8385 Sep 11  1998 init.ora
-rw-r-----  1 asmuser oinstall 12920 May  3  2001 initdw.ora
-rw-r-----  1 asmuser oinstall  1536 Sep 12 04:31 orapw+ASM
-rw-rw----  1 asmuser oinstall    24 Sep 12 04:31 lk+ASM
-rw-rw----  1 asmuser oinstall  1544 Sep 12 04:31 hc_+ASM.dat
-rw-rw----  1 asmuser oinstall   704 Sep 12 04:31 ab_+ASM.dat
-rw-r-----  1 asmuser oinstall  1536 Sep 12 04:31 spfile+ASM.ora



.BASH PROFILE
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
ORACLE_HOME=/u01/app/oracle/product/10.2.0/asminstance
ORACLE_SID=asminstance
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_HOME
export ORACLE_SID
export PATH
unset USERNAME
~
~
~
~
".bash_profile" 19L, 346C                                                


Re: problem after installing ASM instance [message #421983 is a reply to message #421975] Sat, 12 September 2009 12:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
ORACLE_SID=asminstance


It is supposed to be
ORACLE_SID=+ASM

[Updated on: Sat, 12 September 2009 12:01]

Report message to a moderator

Re: problem after installing ASM instance [message #421987 is a reply to message #421975] Sat, 12 September 2009 13:04 Go to previous message
samiraly
Messages: 57
Registered: June 2009
Member

[asmuser@test ~]$ ORACLE_SID=+ASM
[asmuser@test ~]$ export ORACLE_SID
[asmuser@test ~]$ echo $ORACLE_SID
+ASM
[asmuser@test ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Sep 12 07:52:37 2009

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

Connected to an idle instance.

SQL> startup
ASM instance started

Total System Global Area   83886080 bytes
Fixed Size                  1217836 bytes
Variable Size              57502420 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted



Issue resolved thank you very much Mahesh
Previous Topic: how to remove an oracle instance where two instances are there
Next Topic: should i install ASM instance at the same user as the database ?
Goto Forum:
  


Current Time: Mon Jul 01 01:23:28 CDT 2024