RE: need help on how to configure the 10g console to see a manually created database

From: <jsb_at_digistar.com>
Date: Tue, 3 May 2005 09:47:31 -0400 (EDT)
Message-ID: <Pine.GSO.4.58.0505030934080.27480@digistar.com>

On Tue, 3 May 2005, Christian Antognini wrote:

> The only thing I can think of is that your environment is not correctly
> configured.
>
> How do you enter the "options"? Via parameters or interactively? (if you
> post the complete output is always helpful...)

$ uname -a
Linux box.dom.com 2.6.9-5.ELsmp #1 SMP Wed Jan 5 19:29:47 EST 2005 x86_64 x86_64 x86_64 GNU/Linux

$ cat /etc/redhat-release
Red Hat Enterprise Linux ES release 4 (Nahant)

$ cat /etc/oratab
*:/d02/app/oracle/product/10.1.0.3:N

$ tnsping ADEV

TNS Ping Utility for Linux: Version 10.1.0.3.0 - Production on 03-MAY-2005 09:39:09

Used parameter files:

Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = box.dom.com)(PORT = 1531)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ADEV))) $ emca

STARTED EMCA at Tue May 03 09:44:34 EDT 2005 Enter the following information about the database to be configured Listener port number: 1531
Database SID: ADEV

Service name: BOX.DOM.COM:1531:ADEV
Email address for notification:
Email gateway for notification:

Password for dbsnmp:
Password for sysman:
Password for sys:

You have specified the following settings

Database ORACLE_HOME ................ /d02/app/oracle/product/10.1.0.3
Enterprise Manager ORACLE_HOME ................

/d02/app/oracle/product/10.1.0.3

Database host name ................ box.dom.com
Listener port number ................ 1531
Database SID ................ ADEV
Service name ................ BOX.DOM.COM:1531:ADEV

Email address for notification ............... Email gateway for notification ...............

Do you wish to continue? [yes/no]: yes
May 3, 2005 9:44:57 AM oracle.sysman.emcp.EMConfig checkConfiguration SEVERE: Database instance unavailable. Fix the error(s) and run EM Configuration Assistant again in standalone mode. Could not complete the configuration. Refer to the log file for details

Thanks

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 03 2005 - 09:51:52 CDT