RE: Oracle Restart registration problem with dbca relase 11.2.0.2.0
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "pjhoraclel@xxxxxxxxx" <pjhoraclel@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 7 Feb 2011 23:18:40 +0100
I have had also problems with registering the database with Oracle restart, but
in my case it also did not work manually and I already had a registered db in
the configuration.
I had a user grid which owned the grid infrastructure, a user ora1 which owned
the db software and a user ora2, who owned a second oracle home. The
registration of the db owned by ora1 succeeded, but not the db owned by ora2. I
had to clear the grid infrastructure config and register the databases again to
get it to work.
Later on I installed a third db on this server using user ora3, and again I had
to clear the config before I could register the databases.
A case has been opened with Oracle, but nothing has been found.
To reconfigure the grid infrastructure (for a standalone sever) you need to run
the follwing as user root:
<GRID_HOME>/perl/bin/perl -I<GRID_HOME>/perl/lib -I<GRID_HOME>/crs/install
<GRID_HOME>/crs/install/roothas.pl -deconfig
<GRID_HOME>/perl/bin/perl -I<GRID_HOME>/perl/lib -I<GRID_HOME>/crs/install
<GRID_HOME>/crs/install/roothas.pl
After doing this you need to register the resources again using srvctl.
Also note that if you are using role separation, the privileges on several
directories and files are missing the write privilege for group.
$ORACLE_HOME/dbs directory + the init<instancname>.ora file
--> This will cause a failure to start the db using srvctl when a value is
given for the spfile option in the GI db configuration and there is no
init<instance_name>.ora file in the $ORACLE_HOME/dbs directory or this file
does not contain the spfile parameter
$ORACLE_HOME/srvm/admin/ directory
srvctl is trying to create a backup file of the /etc/oratab file in this
directory.
The /etc/oratab file itself is then updated to have the comment "# line added
by Agent" next to the database line
$ORACLE_HOME/network/admin directory and the
$ORACLE_HOME/network/admin/listener.ora file
When you start a listener (created with srvctl) under the Oracle Home (not
recommended, but possible), the following line is added to the
$ORACLE_HOME/network/admin/listener.ora file:
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LSNR_TEST=ON # line added by Agent
and a backup of this file is created in the same directory.
These are being tracked in bug 11063852
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Peter Hitchman
Sent: maandag 7 februari 2011 17:19
To: oracle-l
Subject: Oracle Restart registration problem with dbca relase 11.2.0.2.0
Database version: Oracle Enterprise Edition 11.2.0.2.0
OS: RHL 5.3
All,
I have been going down the job role separation route and installed the
Grid Infrastructure under a user called oragrid and set that up to run
the ohasd.
Then I installed the database software under the user Oracle.
When I ran the dbca command to create the database, this cropped up:
Exception while registering with HAS PRCR-1006 : Failed to add
resource ora.s2cnmat.db for null
PRCR-1071 : Failed to register or update resource ora.s2cnmat.db
CRS-0259: Owner of the resource does not belong to the group.
I tried again, putting the oracle account in the asmadmin group but it
did not help.
The oragrid account is also in the oinstall account.
The database works OK and I have yet to try and manually register it
with "Oracle Restart", but I cannot figure out what I am supposed to
do to avoid the error during dbca.
Any ideas?
Regards
Pete
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
