Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2004
    Posts
    268

    Unanswered: Enterprise Manager Issue 11G R2

    OS: Linux Red-Hat 5.2
    Oracle 11G R2 Standard Edition.

    I am very new to Oracle (My backgroud is SQL Server/DB2) and I have been through a couple of documentation but I can not resolve my Enterprise manager problem.

    We have 4 databases on this server (1 Oracle instance). I got their http address from the "REPOSITORY_URL" of the emd.properties files. The port numbers are:

    1158
    5500
    5501
    5502

    When I put the url as https://server.ad.domain.netort/em

    I can only get to the one with the port number 5500 and none of the others. I am loging in with oracle ID and my $ORACLE_HOME is set to

    /u01/app/oracle/product/11.2.0/db_1

    and my $ORACLE_SID is set to the database name with the only port number (5500) that allows me to get to the login screen.

    All other databases, I get the "Unable to connect" error even though I change the $ORACLE_SID to their DbNames.

    Can someone please tell me what configurations (to which files, environments, variables) have to be made to allow me to get to the login page of each database ? I have not created the databases so, I did not select any options while creating them.

    Thanks in advance.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by mdx34 View Post
    We have 4 databases on this server (1 Oracle instance).
    With Oracle you only have one database per instance. If you need 4 databases open simultaneously, you'll need to define and start 4 instances.

  3. #3
    Join Date
    Oct 2004
    Posts
    268
    Thank you...........I guess it is not possible to run all 4 databases with one userid unless you manually change the oracle_sid and start/stop enterprise manager.

    What is the best practice ?. Create a different user for each database ?

    Thanks again.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    1) EM is not required to run or manage any DB
    2) if you want to be able to manage multiple DB, then buy EM Grid
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Oct 2004
    Posts
    268
    then, what is used to run/manage databases other than EM Grid ? SQLPLUS ?
    Last edited by mdx34; 12-12-11 at 16:13.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    any sql client, like SQuirreL SQL Client Home Page, can be used.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Oct 2004
    Posts
    268
    Thanks.................

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •