| OEM [message #134199] |
Tue, 23 August 2005 16:58  |
poratips
Messages: 345
Registered: April 2005
Location: IL
|
Senior Member |
|
|
Hi,
I have down loaded and installed Oracle 9i from OTN on my local m/c. I want to manage my prod db from my local m/c. How can I set up the OEM so I view my prod db?
I have TNSNAMES.ORA file on ORacle\ORa92\Network/admin
I can use sqlplus but not oem.
Thanks,
|
|
|
|
|
|
| Re: OEM [message #134600 is a reply to message #134250] |
Thu, 25 August 2005 13:53  |
poratips
Messages: 345
Registered: April 2005
Location: IL
|
Senior Member |
|
|
Thanks. I have checked the docs at a glance.
But I have question that I don't have any access to production server directly where our db resides but I have access db through another schema means I don't have direct admin schema role but I have access db through role so I can query the db vis data dictionary tables to check tables,indexes and performance related stuff through sql*plus.
Now my question is How can I set up the repository as my Prod db is located on another server?
What's the additional steps required to get set up OEM as DB on another server, OEM installed on my windows xp and I have data dict views privileges?
Thanks
|
|
|
|
|
|
|
|
| Re: OEM [message #134867 is a reply to message #134780] |
Sun, 28 August 2005 10:47 |
poratips
Messages: 345
Registered: April 2005
Location: IL
|
Senior Member |
|
|
Thanks. I don't hav e direct access to our database. Means I don't have direct access to abc schema but I got grnated priviliges to access abc schema via role for my xyz user.
So I am login through my xyz userid to access abc schema objects as well as they have given me a v$ data dictionary views access so I can check data dcit related information.
I am looking to set here OEM but I don't have any o/s level access on Unix to create ant Tablespace so I was thinking to set OEM on my win XP and check the db objects info.
Looking to docs it's ask me to set the oen repository and etc..so I am little confused. If you have simple steps to follow regarding this kind of access level user I will really appreciate.
Thanks
|
|
|
|
| Re: OEM [message #134904 is a reply to message #134867] |
Sun, 28 August 2005 20:58 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
You can create repository in a seperate database.
But first what kind of operations are you about to do with OEM?
If you are just looking for a GUI tool to browse the database objects,
dba studio or oem standalone without repository will do.
As said in documentation
The applications which require a standalone repository include:
* Change Manager
* Oracle Expert
* Oracle SQL Analyze
If you are not intending to use any of these, You no need a repository.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
