| oracle11g installation [message #484661] |
Thu, 02 December 2010 04:41  |
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
|
Senior Member |
|
|
Hi,
I have created the ASM, installed Grid and ORacle 11g on linux (5) platform.
I am using following linux version.
Red Hat Enterprise Linux Server release 5.5 (Tikanga)
Kernel \r on an \m
Oracle_home = /opt/oracle/product/11.2.0/db
Grid Path = /opt/grid/11.2.0/grid
[oracle@bluemoon admin]$ ps -ef | grep pmon
oracle 2902 1 0 15:14 ? 00:00:00 asm_pmon_+ASM
oracle 5374 3024 0 17:28 pts/1 00:00:00 grep pmon
[oracle@bluemoon dbs]$ export ORACLE_SID=+ASM
[oracle@bluemoon dbs]$ asmcmd
Connected to an idle instance.
ASMCMD> ls
ASMCMD-08102: no connection to ASM; command requires ASM to run
After installing I am not able to connect but it is showing above error and showing the ASM process.
In bash_profile, Oracle_home = /opt/oracle/product/11.2.0/db
Please advise. This is very urgent.
|
|
|
|
|
|
| Re: oracle11g installation [message #484685 is a reply to message #484661] |
Thu, 02 December 2010 05:20  |
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
|
Senior Member |
|
|
Thank very much Mahesh.
But I have one doubt.
What is the use of ORACLE_HOME?
Listener is in Grid/network/admin path where as tnsnames is in oracle_home/network/admin path. If I create the database, will the listener entry be added or not?
|
|
|
|
|
|
| Re: oracle11g installation [message #484825 is a reply to message #484661] |
Thu, 02 December 2010 23:11 |
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
|
Senior Member |
|
|
Hi,
I am able to connect to ASM and I created the database using DBCA but When I connect to database it is connecting to Idle instance. why it is conencting to Idle Instance.
[oracle@bluemoon ~]$ export ORACLE_SID=IPDCDB1
[oracle@bluemoon ~]$ sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 3 11:58:32 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01031: insufficient privileges
See the status of the ASM and database.
[oracle@bluemoon ~]$ ps -ef | grep pmon
oracle 2924 1 0 Dec02 ? 00:00:00 asm_pmon_+ASM
oracle 3972 1 0 Dec02 ? 00:00:00 ora_pmon_IPDCDB1
oracle 5886 3033 0 11:52 pts/1 00:00:00 grep pmon
Oratab entry:
--------------
+ASM:/opt/grid/11.2.0/grid:N
IPDCDB1:/opt/oracle/product/11.2.0/db:N # line added by Agent
Tnsnames entry in oracle_home.
------------------------------
[oracle@bluemoon ~]$ more /opt/oracle/product/11.2.0/db/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /opt/oracle/product/11.2.0/db/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
IPDC_DB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bluemoon)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = IPDC_DB1)
)
)
DUMMY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bluemoon)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Dummy)
)
)
Please clarify.
|
|
|
|
|
|
| Re: oracle11g installation [message #484827 is a reply to message #484826] |
Thu, 02 December 2010 23:30 |
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
|
Senior Member |
|
|
I am seeing the below files under /opt/oracle/cfgtoollogs/dbca/IPDC_DB1 directory.
[root@bluemoon IPDC_DB1]# ll
total 1168
-rw-r----- 1 oracle oinstall 287538 Dec 2 21:41 apex.log
-rw-r----- 1 oracle oinstall 10475 Dec 2 21:05 context.log
-rw-r----- 1 oracle oinstall 310102 Dec 2 21:00 CreateDBCatalog.log
-rw-r----- 1 oracle oinstall 0 Dec 2 20:45 CreateDBFiles.log
-rw-r----- 1 oracle oinstall 251 Dec 2 20:45 CreateDB.log
-rw-r----- 1 oracle oinstall 235953 Dec 2 21:25 emRepository.log
-rw-r----- 1 oracle oinstall 5052 Dec 2 21:17 interMedia.log
-rw-r----- 1 oracle oinstall 2604 Dec 2 21:04 JServer.log
-rw-r----- 1 oracle oinstall 81 Dec 2 21:41 lockAccount.log
-rw-r----- 1 oracle oinstall 720 Dec 2 21:09 ordinst.log
-rw-r----- 1 oracle oinstall 128 Dec 2 21:42 postDBCreation.log
-rw-r----- 1 oracle oinstall 0 Dec 2 21:00 sqlPlusHelp.log
-rw-r----- 1 oracle oinstall 268696 Dec 3 11:43 trace.log
-rw-r----- 1 oracle oinstall 28364 Dec 2 21:09 xdb_protocol.log
[root@bluemoon IPDC_DB1]# more postDBCreation.log
utl_recomp_begin: 09:41:31
utl_recomp_end: 09:41:36
Database closed.
Database dismounted.
ORACLE instance shut down.
DB_RUNNING
Please let me know where exactly exists the alert file.
|
|
|
|
|
|
|
|
| Re: oracle11g installation [message #484866 is a reply to message #484854] |
Fri, 03 December 2010 06:45 |
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
I see everyone else has given up, so I'll try to sum up what you need to know, though it is all in the 2 Day DBA guide.
To connect to your ASM instance, do this:
export ORACLE_HOME=/opt/grid/11.2.0/grid
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=+ASM
sqlplus / as sysasm
To connect to your database instance, do this:
export ORACLE_HOME=/opt/oracle/product/11.2.0/db
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=IPCDB1
sqlplus / as sysdba
|
|
|
|
| Re: oracle11g installation [message #485064 is a reply to message #484661] |
Sun, 05 December 2010 23:50 |
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
|
Senior Member |
|
|
Sorry John, I didn't get you.
In bash_profile,
1)If I keep grid(/opt/grid/11.2.0/grid) path as ORACLE_HOME then ASM is working fine but when I put oracle home(/opt/oracle/product/11.2.0/db) path as ORACLE_HOME then ASM is not working. What is the exactly oracle_home path?
2) How should I declare the two ORACLE_HOME paths differently?
3) Is it required to export ORACLE_HOME path every time when I connect to database?
Please clarify.
I am seeing the following error in the above attached log.
"ERROR: failed to establish dependency between database IPDC_DB1 and diskgroup resource ora.IPDCDATA1.dg"
|
|
|
|
|
|
| Re: oracle11g installation [message #485090 is a reply to message #484661] |
Mon, 06 December 2010 02:41 |
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
|
Senior Member |
|
|
Thank you very much Mahesh.
If I export ORACLE_HOME differently for connecting the ASM and database then it is working ASM and database.
I have two clarifications here.
1) Without executing .profile files or manully exporting ORACLE_HOME, is there any way to connect to ASM and database automatically? (For example Suppose I exported ORACLE_SID=+ASM, If i give sqlplus it should connect to ASM else I exported ORACLE_SID=IPDCDB1, If i give sqlplus it should connect to IPDCDB1).
2) I am seeing the 3 database are created in my server but If i give ps -ef | grep pmon then it is showing 2 databases. When I stop and start the listener then also two databases are starting but third database is not starting? Please tell me how the database will start automatically If I start the listener.
[oracle@bluemoon ~]$ more /etc/oratab
#Backup file is /opt/oracle/product/11.2.0/db/srvm/admin/oratab.bak.bluemoon line added by Agent
#
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
+ASM:/opt/grid/11.2.0/grid:N
IPDC01:/opt/oracle/product/11.2.0/db:N
IPDC09:/opt/oracle/product/11.2.0/db:N
IPDCDB1:/opt/oracle/product/11.2.0/db:N # line added by Agent
----------------
[oracle@bluemoon ~]$ ps -ef | grep pmon
oracle 2899 1 0 15:05 ? 00:00:00 asm_pmon_+ASM
oracle 3008 1 0 15:06 ? 00:00:00 ora_pmon_IPDCDB1
oracle 3164 1 0 15:08 ? 00:00:00 ora_pmon_IPDC09
oracle 3397 3134 0 15:24 pts/0 00:00:00 grep pmon
|
|
|
|
| Re: oracle11g installation [message #485124 is a reply to message #485090] |
Mon, 06 December 2010 05:29 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
1) Did you even try to read that 2 Day DBA manual that we are all fond of?
ORACLE_SID is bounded/registered with the ORACLE_HOME it is been created with.
So, if you want to export ORACLE_SID, you need to export ORACLE_HOME too.
What you can do is (even without exporting ORACLE_SID),
set add tnsentres to tnsnames.ora in grid_home that will talk to database in oracle_home via listener.
something like this
sqlplus user/pass@oracleDbYouwantToConnnect
Quote:
>>Please tell me how the database will start automatically If I start the listener.
When you stop/start the listener, you start/stop the listener. Not the database.You have to start /stop the database.
You can manually write a script or edit dbshut/dbstart to include the correct listener.
[Updated on: Mon, 06 December 2010 05:31] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
