-
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.
Alla S. Pfauntsch
Oracle DBA
========================================
"Life is what happens while you are planning something else".
-
$ 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.
-
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.
-
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.
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|