OEM logon and Setup
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: OEM logon and Setup

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    Hi :
    I installed a database on NT and I have my set up my TNSnames.ora to access multiple databases. Everything is fine. But I have installed OEM and wanted to access that.
    It is asking for Management server and stuff like that. Could anyone of you help me set up. Thx

  2. #2
    Join Date
    Sep 2000
    Posts
    128
    On the OEM CD (and most likely on your database server CD) will be the OMS software as an install option.

    You need to install and setup this before you can use most of OEM.

    You can install on the same machine as your database or a different NT machine. I tried running it on a 64Mb NT workstation once - not good :( quite resource intensive it seems.

  3. #3
    Join Date
    Oct 2000
    Posts
    449
    I tried on my local database. An OEM_repositort TS and Dbf got created along with an user, but in the console when I log in, it does not accept the connect strings properly.
    It complains about the host configuration.
    I am stuck..

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Couple of things to do first:

    Check whether the OMS has been started if not start it.

    Then check your tnsnames.ora file. It is the service name that you have to give, which inturn would be your sid_name

    Then the username is sysman/oem_temp

    The node that your OEM connects to should have the OMS installed. If not I would suggest you to go ahead and install as terry said.

    the host name should be the full path
    example: hello.oracle.com

    And then try. If you still have problem, let us know.

    Sam

  5. #5
    Join Date
    Oct 2000
    Posts
    449
    Thanks guys.. It worked so far.. perfectly..

    Now that I am logged in.. I was surfing, and I cannot find a database that I can use this with. I am looking to know how to add a database a well (all db's that I connect to as per my tnsnames.ora)..

    All I can see in the console is
    Network
    - Groups
    - Nodes
    - Developer servers


    Thx..

  6. #6
    Join Date
    Sep 2000
    Posts
    43
    You need to discover that node where you database is located. To be able to do that you need to have Intelligent Agent up and running on that box. To find out whether it is installed, telnet to that box, go to $ORACLE_HOME/bin and do ls -la *dbsnmp*
    That should list it:
    $ ls -la *dbsnmp*
    -rwsr-s--- 1 oracle dba 11255808 Jul 24 21:28 dbsnmp
    Then you can start it:
    dbsnmp_start (or _status, or _stop).
    Intelligent Agent is used to discover nodes and in old OEM version for everything else... Now you can just have Data Gatherer installed instead... but to discover, Intelligent Agent is still necessary.
    Alla S. Pfauntsch
    Oracle DBA
    ========================================
    "Life is what happens while you are planning something else".

  7. #7
    Join Date
    Oct 2000
    Posts
    449
    $ pwd
    /u01/app/oracle/product/8.1.6/bin
    $ ls -l dbs*
    -rwxr-xr-x 1 oracle oinstall 2272 Dec 14 1999 dbshut
    -rwsr-s--- 1 root oinstall 1466472 Nov 10 15:54 dbsnmp
    -rwxr-xr-x 1 oracle oinstall 4690 Dec 14 1999 dbstart
    $ dbsnmp_start
    ksh: dbsnmp_start: not found
    $

    I dont undersatnd why I cannot do this..

    Please suggest further.. apfaunts.

    Thx.

  8. #8
    Join Date
    Apr 2000
    Posts
    126

    OEM logon and Setup

    -rwsr-s--- 1 root oinstall 1466472 Nov 10 15:54 dbsnmp

    This should be owned by oracle not root. To start the IA, the command is lsnrctl dbsnmp_start.

  9. #9
    Join Date
    Oct 2000
    Posts
    449
    I tried on NT after I tried on Solaris and failed..

    Check this out
    on NT 4.0 Oracle 8i

    C:\>lsnrctl

    LSNRCTL for 32-bit Windows: Version 8.1.6.0.0 - Production on 05-DEC-2000 15:50:52

    (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.

    Welcome to LSNRCTL, type "help" for information.

    LSNRCTL> status
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 8.1.6.0.0 - Production
    Start Date 04-DEC-2000 12:59:41
    Uptime 1 days 2 hr. 51 min. 26 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File E:\Oracle\Ora81\network\admin\listener.ora
    Listener Log File E:\Oracle\Ora81\network\log\listener.log
    Services Summary...
    PLSExtProc has 1 service handler(s)
    cdn has 1 service handler(s)
    cdn has 2 service handler(s)
    mydb1 has 1 service handler(s)
    The command completed successfully
    LSNRCTL> dbsnmp
    Ambiguous text "dbsnmp", valid completions are:

    dbsnmp_start dbsnmp_stop dbsnmp_status

    LSNRCTL> dbsnmp_status
    The db subagent is not started.
    LSNRCTL> dbsnmp_start
    LSNRCTL> dbsnmp_status
    The db subagent is not started.
    LSNRCTL> dbsnmp_start
    LSNRCTL>


    Why is it unable to start??

  10. #10
    Join Date
    Sep 2000
    Posts
    43
    Sorry, I misstyped:
    [/usr/local/oracle/product/8.1.6/bin]
    $ lsnrctl dbsnmp_stop

    LSNRCTL for DEC OSF/1 AXP: Version 8.1.6.0.0 - Production on 05-DEC-2000 20:58:26

    (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.


    [Integration_Lab:insc01db1:oracle]
    [/usr/local/oracle/product/8.1.6/bin]
    $ lsnrctl dbsnmp_start

    LSNRCTL for DEC OSF/1 AXP: Version 8.1.6.0.0 - Production on 05-DEC-2000 20:58:30

    (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.


    [Integration_Lab:insc01db1:oracle]
    [/usr/local/oracle/product/8.1.6/bin]
    $

    And mhaller is correct - it should be owned by oracle not root. Oracle will not be able to execute what is owned by root. Looks like you guys messed it up when installed oracle software because group oinstall is used only for installation. Ask your sysadmin to change owner and group - owner: oracle, group - dba.
    Alla S. Pfauntsch
    Oracle DBA
    ========================================
    "Life is what happens while you are planning something else".

Posting Permissions

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


Click Here to Expand Forum to Full Width