Printable View
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
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.
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..
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
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..
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.
$ 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.
-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.
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??
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.
P.S. If you just type lsnrctl you get yourself to listener prompt and query, start, stop listener not Intelligent Agent:
$ lsnrctl
LSNRCTL for DEC OSF/1 AXP: Version 8.1.6.0.0 - Production on 05-DEC-2000 21:02:50
(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=166.34.207.20)(Port=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for DEC OSF/1 AXP: Version 8.1.6.0.0 - Production
Start Date 29-NOV-2000 00:36:30
Uptime 6 days 20 hr. 26 min. 24 sec
Trace Level off
Security OFF
SNMP ON
Listener Parameter File /usr/local/oracle/product/8.1.6/network/admin/listener.ora
Listener Log File /usr/local/oracle/product/8.1.6/network/log/listener.log
Services Summary...
INS1 has 1 service handler(s)
INS1 has 1 service handler(s)
The command completed successfully
Thanks mhaller and apfaunts..
Some improvement::
I was able to discover the node for my NT(local db where OEM is installed by typing in IP address)..
Now I shall change permissions on the Sunboxes and shall
try again.. Shall catch you guys again..
Thx.
Check your DBSNMPW.LOG file for additional errors.
Try the following:
Remove the $ORACLE_HOME/network/admin/snmp_ro.ora & snmp_rw.ora files.
Remove all files in the $ORACLE_HOME/network/agent directory, leaving only the subdirectories.
Restart the Oracle Intelligent Agent.
Also, take a look on metalink at(search on Starting the Intelligent Agent):
Note:75063.1
Note 70115.1
Thanks a lot all of you..
I am able to discover all the nodes(databases-remote)
and can access them..
Thanks again.. for being with me and supporting me..
~