Enterprise Manager :: Not Working After Host Name Change

Oct 21, 2010

I'm not a DBA, but I've inherited an Oracle 11g database on a Linux Red Hat 5 box that I am now responsible for. I've had to relocate it, and my host name has changed. I've muddled through a few changes (network & listener changes), and the database seems to be working a- ok.

My problem is that the OEM doesn't seem to be working now. I don't think the dbconsole is running. When I try to launch it, I'm using the command line:

su - oracle - c "export Oracle_SID=databasename;/u01/app/oracle/product/11.1.0/db1/bin/emctl start dbconsole"

I'm getting the error: EM Configuration issue /u01/app/oracle/product/11.1.0/db1/hostname_databasename not found (obviously replace the hostname and database name with the appropriate names)

The hostname however, contains the OLD hostname.I tried a quick method of copying the folder, and changing the name to include the new hostname, but that didn't work.

View 1 Replies


ADVERTISEMENT

Enterprise Manager :: Change Host Name In New Instance Of R12

Mar 30, 2011

I have created a new instance with address

[URL].......

Now ideally I would like to change this so I can access this from another a machine. Is this possible? Or do I have start from scratch?

View 4 Replies View Related

Enterprise Manager :: Host Credentials For 11g

May 14, 2013

I am trying to use Database Replay in 11g Release 1 using Enterprise Manager. In the last step it asks for 'Host Credentials' to start the capture. But when i give the username and password for the host, it throws error as 'Invalid username/password' all the time.

View 15 Replies View Related

Enterprise Manager :: How To Set Preferred Credentials For Host In OEM 11g

Oct 24, 2011

I am having a problem in setting Preferred Credentials in OEM.

My env:
O/S: Oracle Enterprise Linux 5.3
OEM: 11g Grid Control.

My OEM is running as expected. I have a few target database instances on different hosts. I can login and monitor all these database instances. Now I am trying to set Preferred Credentials to hosts but none is working. I am doing this as:

1. OEM Console->Preferences->Preferred Credentials.

2. For my host I enter normalusername, normal password, privileged username, privileged password.

3. Then I click on test

I get the following error "ERROR:Connection to TD3OEDB01A as user oracle failed."

I can connect to TD3OEDB01A as oracle user and root user. I am entering correct passwords.

Even when I try to set Preferred Credentials to the same server where my OEM and Repository DB is running (same machine) - it does not work.

There emoms.trc file contents looks like this:

2011-10-24 11:14:42,047 [EMUI_11_14_42_/console/pref/setCredentials$targetType=host] ERROR creds.SetPrefCreds testCreds.1690 - SetPrefCreds.testCreds(): CredsException: All values must be specified for each set of credentials.

2011-10-24 11:23:59,350 [EMUI_11_23_59_/console/pref/setCredentials$targetType=host] ERROR creds.SetPrefCreds saveCreds.1490 - SetPrefCreds.saveCreds(): CredsException: Some credential changes were successfully applied. However, one or more credential sets were not saved for the following targets, due to either missing credential values or not clearing all credential values when attempting to delete credentials: TD3OEDB01A

2011-10-24 11:24:52,929 [EMUI_11_24_52_/console/pref/setCredentials$targetType=host] ERROR creds.SetPrefCreds testCreds.1690 - SetPrefCreds.testCreds(): CredsException: Connection to TD3OEDB01A as user oracle failed.

View 2 Replies View Related

Enterprise Manager Host Credentials On Linux

May 10, 2011

Am using Oracle 10g on redhat linux machine.

My Agent Connection to Instance is down . I am trying to start it up using EM when i enter my user name and password on host credentials connection fails (am using a suer that installed my oracle software).

View 1 Replies View Related

Enterprise Manager :: Grid - Populating Target In Host?

Jul 31, 2010

In one of our cluster environment host 1 has 30+ targets. We are trying to add the targets in the grid. But while doing Agent Synchronization targets are not getting populated in the host..

Checked the log file of the same. Getting error as below..Not sure how to fix this.

2010-07-30 22:15:42,777 Thread-4158 ORAXML-229, File=file:/oracle/product/em/agent10g/magerdbspr08.corp.internal.com/sysman/emd/collection/rac_database_db303pta.xml, Line=0, Msg=LPX-00229: input source is empty (01006)
2010-07-30 22:15:46,534 Thread-4675 target {dbb01pta, rac_database} is broken: Computation of a critical dynamic property failed. Retries Completed (00156)
2010-07-30 22:15:46,580 Thread-4675 ORAXML-229, File=file:/oracle/product/em/agent10g/magerdbspr08.corp.internal.com/sysman/emd/collection/oracle_database_d01pt1_d01pt.xml, Line=0, Msg=LPX-00229: input source is empty (01006)
2010-07-30 22:15:46,581 Thread-4675 ORAXML-229, File=file:/oracle/product/em/agent10g/magerdbspr08.corp.internal.com/sysman/emd/collection/rac_database_dpta.xml, Line=0, Msg=LPX-00229: input source is empty (01006)
2010-07-30 22:15:47,603 Thread-4166 target {tta, rac_database} is broken: Computation of a critical dynamic property failed. Retries Completed (00156)
2010-07-30 22:15:47,648 Thread-4166 ORAXML-229, File=file:/oracle/product/em/agent10g/magerdbspr08.corp.internal.com/sysman/emd/collection/oracle_database_dta_d22.xml, Line=0, Msg=LPX-00229: input source is empty (01006)

View 1 Replies View Related

Enterprise Manager :: Null Point Error On Charts Of Host CPU And On Active Ses

Oct 17, 2012

i am getting error when iam starting enterprise manager GUI dbcosole,its not displaying the graphs of HOST CPU and active session graphs instaed its giving me error such as java.lang error and null point error below the graphs.

i stop and start the dbconsole from services and from command prompt and rebooted the server,but still showing the same error..did open in other kernals such as mozilla and google still the same issue..

View 3 Replies View Related

Enterprise Manager :: OEM Is Not Working

Sep 24, 2010

I tried to start my oem managing but got the following error.

[oracle@Eagle2 ~]$ emctl start dbconsole
OC4J Configuration issue. /home/oracle/app/product/11.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_Eagle_boomiedb not found.

View 19 Replies View Related

Enterprise Manager Is Not Working - Handle Is Invalid?

May 31, 2013

Recently I noticed EM web wasn't working, I suspect it happened because i configured EM before adding server to domain. Anyway I decided to drop de repository and re-create it but now i am facing a some errors:

C:\>echo %ORACLE_SID%
orcl
C:\>echo %ORACLE_HOME%
C:\oracle\product\10.2.0\db_1

[code]....

Enter the following information:

Database SID: orcl
java.io.IOException: The handle is invalid
at java.io.FileInputStream.close0(Native Method)
at java.io.FileInputStream.close(FileInputStream.java:245)
at sun.nio.cs.StreamDecoder$CharsetSD.implClose(StreamDecoder.java:505)

[code]....

You have specified the following settings

Database ORACLE_HOME ................ c:\oracle\product\10.2.0\db_1
Database hostname ................ ora01
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

[code]....

So now i am facing all these java errors and my EM isn't working.

S.O. = Windows Server 2003 SP 2 x64
Oracle 10.2.0.4.0

View 2 Replies View Related

Enterprise Manager :: Configure Enterprise Manager In Windows 2003 Server?

Aug 21, 2010

I am having a database running in my windows 2003 server and I want to configure Enterprise manager for that database to check the resource utilization during the peak hours and also the number of transactions...

View 1 Replies View Related

Enterprise Manager :: Unable To Connect To Enterprise Manager Console?

Dec 20, 2010

i have already give the grant option cnnect,resource to scott but it is not connecting to enter prise manager console of Oracle database 11gR1. i am getting this error while connecting "The application requires more database privileges than you have currently been granted. Click on Help to get more version specific information"

when i am giving scott the dba rights then it is connecting. but i cann't give dba rights to scott.so, how/what is the specific command to give permission scott for connecting to enter prise manager console.

View 1 Replies View Related

Enterprise Manager :: Oracle Enterprise Manager Communication Error?

Feb 2, 2010

We have the Oracle Enterprise Manager Grid Control 10.2.0.5. We recently upgraded our Databases from 10.2.0.3 to 10.2.0.4 and since then we are having this problem.

Whenever i click an Agent on the Grid Control it gives me this error: "Communication between the Oracle Management Service host to the Agent host is unavailable. Any functions or displayed information requiring this communication link will be unavailable. For example: deleting/configuring/adding targets, uploading metric data, or displaying Agent home page information such as Agent to Management Service Response Time (ms)."

I get the same error when i try to configure a host or a database.

Don't know what is wrong

View 4 Replies View Related

Enterprise Manager :: How To Start Enterprise Manager On Windows 7

Mar 21, 2013

How to start EM on windows 7?

View 3 Replies View Related

Enterprise Manager :: Oracle 9i Enterprise Edition Installation Error / End Header Not Found

Feb 18, 2011

My problem is i install Oracle 9i enterprise edition 9.0.1.1.1 in windows xp professional but at the time of oracle database confiuration assistent it show me following errors it show:

Not a zip file(End header not found)

View 1 Replies View Related

Enterprise Manager :: Config - Enter Price Manager Grid Control For All DB

Feb 8, 2010

we have 5 database servers in different locations,

1.main database 10g(production) ip-192.1.1.1
2.standby for production 10g ip- 192.1.1.2

both are linux

3.another database 10g windows
4. another database 9i windows

both are in same location

5.new database 10g in linux ip-192.1.1.3
some other location
i m having a system windows xp installed
i m monitoring, all 10g by oracle enterpric manager
linux os monitor by Putty software

and i m monitoring below 10g database by sqlplus. now how could i monitor all the database by oracle enterprise manager grid control installed in my system that windows OS installed.

View 4 Replies View Related

Enterprise Manager :: Can't Open Enterprise Manager

May 11, 2011

i have change my database name successful but after that when i open my enterprise manager i can open it but i cannot do anything in enterprise manager . i cannot show any tabs there.. i have attached my this enterprise manager login page here

View 12 Replies View Related

Enterprise Manager :: JDK 1.6.0 SR6?

May 6, 2011

I'm trying to install OMS on AIX and one of the prerequisites is JDK 1.6.0 SR6 but I couldn't find it in the IBM site, can some one tell me where can I download JDK 1.6.0 SR6?

View -1 Replies View Related

Enterprise Manager Cannot Start

Sep 2, 2013

I am trying to start enterprise manager without success. i used to work after installation of db 10g but do day when i run the command below it fails. also i donot see any thing useful in the logs that am being directed to directory /oracle/Ora10R2/Orahome/localhost.localdomain_dse/sysman/log

[oracle@cdsdb ~]$ emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.2.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
Starting Oracle Enterprise Manager 10g Database Control .....
[code]....

View 1 Replies View Related

Enterprise Manager :: EM Port For Second DB

Jul 2, 2010

I have two databases on the same oracle 11g install. The first (ORCL) database uses the default port for EM (1158). However, I don't know what the second one uses. I go to the portlist.ini file, but it only has the entry for the default (ORCL) database.

View 3 Replies View Related

Enterprise Manager :: How To Use OEM Remotely

Oct 21, 2011

How can I use OEM remotely?

my DB server is on 172.17.1.4 IBM-AIX

and my computer is 172.17.1.53

Because I am tired of using sqlplus :@

View 2 Replies View Related

Enterprise Manager :: Listener Is Getting Down?

Apr 25, 2010

When i run EM ,in my explorer show these
SID = ORCL

instance is open agent is up but ...listener is down .my listener is active and run.... however i can connect to DataBase and execute DDL or DML transactions.How i could resolve it ?

View 6 Replies View Related

Server Administration :: Oracle Ocfs2 Not Working In Enterprise Linux 6.2

Mar 29, 2013

RPMS needed by OCFS2 for oracle enterprice linux 6.2,Since we unable to mount through OCFS2 console.

View 1 Replies View Related

Forms :: Menu Tree Not Working Properly - Change It?

Feb 12, 2010

I have a form in which menu tree is populated with this sql

SELECT 1, Level, MenuLabel, MenuName, MenuId
FROM MenuFile
CONNECT BY PRIOR MenuId = ParentId START WITH menuId = :moduleid||'0000'

The result is attached in the CSV file enclosed in sheet mrnufile1As we can see in row 3 the item LPC has menuid BDME13.
In my view This item should be in ROW 19.How can i change query do get the desired the result.I have also tried another sql query.

select * from menufile where applicationid = 'BD' order by parentid,menuid

Result of this query is in 2nd Half of CSV file

View 2 Replies View Related

Cannot Find Enterprise Manager After Installation

Aug 15, 2013

I have install oracle 11g database enterprise edition But i cannot find the Oracle Enterprise Manager after the installation. i want the gui based Oracle Enterprise Manager i have access the the web base Oracle Enterprise Manager but not the gui based.how to use and download the GUI Based Oracle Enterprise Manager ....

View 1 Replies View Related

Enterprise Manager Configuration Failed

Jul 29, 2013

when i install a db using the Assistant Configuartion Database i get no error exept this:

Enterprise manager configuration failed due to the following error - Listener is not up. Start the listener and run EM configuration again. Refer to the log file at C:\Oracle\cfgtoollogs\dbca\emConfig. Log for more details. You can retry configuring this database with Enterprise Manager later by manually running C:\Oracle\product\11.1.0\db_1\bin\emca script.

So I try lsnrctl start and i get:

C:\Windows\system32>lsnrctl start
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 29-LUG-2013 10:26:25
Copyright © 1991, 2010, Oracle. All rights reserved.
TNS-01106: Il listener con nome LISTENER � stato gi� avviato

So I try lsnrctl status and i get:

C:\Windows\system32>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 29-LUG-2013 10:23:34
Copyright © 1991, 2010, Oracle. All rights reserved.
Connessione a (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

[code]...

The file "server.xml" in E:\app\Andrea.Rimoldi\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole\config\ does not exist...

Is there any way to retrieve or recover this file?

View 11 Replies View Related

Enterprise Manager :: How To See Process Running In OEM

Jan 20, 2010

when I run the form and do some action intheform (call procedure , etc..) how can to see what is the process in running in OEM? Do it have any way to monitor it?

View 1 Replies View Related

Enterprise Manager :: OEM Installation In Linux

May 23, 2010

I am trying to install OEM but the GUI asks for weblogic server home.i checked many documents in net but none has weblogic installation procedure. Is it the sequence of installation ?

View 2 Replies View Related

Enterprise Manager :: Job Submission Failure

Mar 27, 2012

am trying to create a backup job in my UAT/testing instance, but with little success. I'm trying to create a backup job to disk (backup is to be stored in a drive local to the DB server) and it seems simple enough, but I keep getting the following error:

The job submission has failed for the following reason

ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error ORA-06512: at "SYSMAN.DECRYPT", line 5 ORA-06512: at "SYSMAN.MGMT_CREDENTIAL", line 408 ORA-06512: at SYSMAN.MGMT_CREDENTIAL", line 1007 ORA-06512: at "SYSMAN.MGMT_CREDENTIAL", line 1400 ORA-06512: at SYSMAN.MGMT_JOBS", line 295 ORA-06512: at "SYSMAN.MGMT_JOBS", line 78 ORA-06512: at line 1

In "Recovery Settings", I have a "Flash Recovery Area Location" defined (path local to the DB -i.e. the server that the DB resides on), a "Flash Recovery Area Size" of 4 defined, and a Flashback Retention Time of 24 hours defined. Everything else is riding default values.

In "Backup Settings", there's nothing defined. Everything here is riding default values. As I understand it, not specifying a Disk Backup Location is fine so long as the Flash Recovery Area is defined. All the local services are turned on (scheduling, etc.).

If it's relevant, I mirrored the recovery/backup settings in UAT to the same as PROD, but changed what I needed to in order to accommodate the UAT environment (e.g. paths, etc.)

View 1 Replies View Related

Enterprise Manager :: Managing OEM Remotely

Aug 23, 2013

I want to manage my database remotely, through Internet. Is it possible to do that with OEM? Where can I find information related to this? Is there another monitoring software that allows me to perform this?

View 10 Replies View Related

Enterprise Manager :: Daemon Not Running?

Feb 18, 2009

enctl is started but its status shows that EM Daemon is not running.What does it mean?And how can i reolve this error.

oracle@srv603484:~> emctl start dbconsole
TZ set to US/Pacific
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

[code]...

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved