| Problems with connecting to ASM instance [message #459515] |
Sun, 06 June 2010 09:16  |
rodnower
Messages: 17
Registered: June 2010
Location: Israel
|
Junior Member |
|
|
I have Oracle11 with RAC installed on RedHat 5.
I have two servers with two instances one on each one.
In each server I succeed connect to appropriate instance of database but not to instance of ASM.
I connect with user oracle11 and type:
export ORACLE_SID=+ASM1
sqlplus "/ as sysdba"
It connects but write:
Connected to an idle instance
and when I try to access to parameters or views I have errors.
For know that +ASM1 is the SID I type:
ps aux | grep pmon
and get:
asm_pmon_+ASM1
I tried also with +ASM but it was also unsuccessfully.
What is wrong here?
|
|
|
|
|
|
|
|
| Re: Problems with connecting to ASM instance [message #459570 is a reply to message #459516] |
Mon, 07 June 2010 02:30  |
rodnower
Messages: 17
Registered: June 2010
Location: Israel
|
Junior Member |
|
|
Thank you for replay.
I have been read Posting Guidelines, but I may not to copy too many things from my workstation, because computer that is connected to Internet is not the same one.
Here some more information:
cat /proc/version:
Linux version 2.6.18-164.el5 (workbuild@x86-003.build.bos.redhat.com (gcc version .. (Red Hat 4.1.2-46))
select * from v$version:
Oracle Database 11g Enterprise Edition
Release 11.2.0.1.0-64bit - Production
PL/SQL Release 11.2.0.1.0 - Production
Core 11.2.0.1.0 - Production
TNS for Linux: version 11.2.0.1.0 - Production
NLSRLL version 11.2.0.1.0 - Production
And I actually set also ORACLE_HOME of the ASM:
cat /etc/oratab:
+ASM1:/oracle11/product/11.2.0/grid:N
LIBD:/oracle11/product/11.2.0/db:N
Now I'm sure about SID of ASM, and I do:
su - oracle11
export ORACLE_HOME=/oracle11/product/11.2.0/grid/
export ORACLE_SID=+ASM1
cd $ORACLE_HOME/bin
pwd
/oracle11/product/11.2.0/grid/bin
./sqlplus /nolog
SQL> conn / as sysdba
Connected to an idle instance
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
