Configuring OEM when creating a database MANUALLY

From: Flav <flav_tech_at_yahoo.com>
Date: 25 Oct 2001 11:28:48 -0700
Message-ID: <6e6c02ed.0110251028.22a5af4a_at_posting.google.com>


I have a problem with having the OEM Console recognize a database that is being created manaually without using Database Assistant.

Steps used are as follows:

Database called DBA created including following tablespaces:

TS# NAME

---------- ------------------------------
         0 SYSTEM
         1 RBS
         2 DATA
         3 TEMP
         4 INDX
         5 OEM
         6 QUERY_DATA
         7 OEM_REPOSITORY

8 rows selected.

Some of the parameters specified in initDBA.ora init file:

compatible = 8.1.5

db_block_buffers = 100                                              
db_block_size = 4096
db_file_multiblock_read_count = 8
db_files = 1024

global_names = TRUE
#Uncomment
db_domain = world
rollback_segments = (sysrol)

# Parameters to be edited
instance_name = dba
service_names = dba.world

db_name = DBA
control_files = (D:\oraclass\DATA\DISK1\control01.con) background_dump_dest = (D:\oraclass\BDUMP) user_dump_dest = (D:\oraclass\UDUMP)
java_pool_size = 1000000

Following info added to listener.ora

    (SID_DESC =
(GLOBAL_DBNAME = dba.world)
(ORACLE_HOME = d:\Oracle\Ora81)
(SID_NAME = dba)

    )

Following info added to tnsnames.ora

DBA.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cr608834-a)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = dba.world)

    )
  )

Other info:
Configuring the OEM is no problem.
The OEM_REPOSITORY is used to store the OEM repostiory info successfully.

Discovering the node (host) is not problem via the OEM Config tool Howerver, upon opening the OEM Console, I do not see the DBA database.

Anybody have any ideas? Thanks in advance. Please email to flav_tech_at_yahoo.com
Please note that configuring OEM after creating a database via the Database Configuration is not a problem. Everything works. I want to know why it is not working when a database is created manually. Note: The location of the database is in a directory called C:\oraclass
It's not in the C:\oracle\oradata\dba directory Received on Thu Oct 25 2001 - 20:28:48 CEST

Original text of this message