EMCSTSDB & RAMBDB

Hi Allan,

Do you have the StorageScope AND the FLR license keys enabled in CC Console? And have all the relevant Host Agent DCPs enabled?

Regards,
Séamus Coffey
EMC Global Services

EMCSTSDB and RAMBDB are two separate databases with different service name. Although they sit on the same host, you have to login to two different databases to see their objects. In RAMBDB, you won't be able to see any of EMCSTSDB tables and views. To see EMCSTSDB objects:
1. You have to log out of RAMBDB.
2. Reset your oracle SID to EMCSTSDB
3. Login to EMCSTSDB through SQLPLUS or other tools like TOAD
4. From SQLPLUS, select * from user_objects, you should be able to get all objects you want in EMCSTSDB.

Hope this helps.

I think i have it I checked the tnsnames.ora and the emcstsdb is on another server which noone told me about.

I now just need to find a login for this dbase.

I'm unsure what the reason is for this but I do have all the correct licenses etc and have the srmserver etc running and have collected data via the dcp's within my server I only see the rambdb but nothing at all for emcstsdb.

Can storagescope run from within he rambdb database?

I must caveat this by stating I have just started here and have been looking at FLR and thought it would be easier to run sql etc to do away with duplicate data etc.

i.e in the Repository\oradata\ I only have rambdb and sample nothing that would suggest emcstsdb.

some files I can find are

D:\apps\ecc\Repository\database\initemcstsdb.ora
""\SPFILEEMCSTSDB.ORA
""\hc_emcstsdb.dat

Again in the init.ora I can see the following

background_dump_dest=C:\ECC\REPOSITORY\ADMIN\EMCSTSDB\BDUMP
cluster_database=FALSE
compatible=10.2.0.2.0
control_files=C:\ECC\REPOSITORY\ORADATA\EMCSTSDB\CONTROL01.CTL, C:\ECC\REPOSITORY\ORADATA\EMCSTSDB\CONTROL02.CTL, C:\ECC\REPOSITORY\ORADATA\EMCSTSDB\CONTROL03.CTL
core_dump_dest=C:\ECC\REPOSITORY\ADMIN\EMCSTSDB\CDUMP

but I believe the controlcenter was upgraded and installed on another drive but I have none of this, so I am wondering how in the world can I be getting data??

Folks,

I know have access thanks to all the help . I got the password from the create_user.log

Al