Configuring OEM when creating a database MANUALLY
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