Answer
Question: I installed agent on one of my server but when I start it I get the following error messages:
replica6-replica:</u01/oracle/product/agent/agent10g/bin> $emctl start agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Starting agent ...... failed.
The agentTZRegion value in /u01/oracle/product/agent/agent10g/sysman/config/emd.properties is not in agreement with what agent thinks it should be.Please verify your environment to
make sure that TZ setting has not changed since the last start of the agent.
If you modified the timezone setting in the environment, please stop the agent and
exectute 'emctl resetTZ agent' and also execute the script
mgmt_target.set_agent_tzrgn(<agent_name>, <new_tz_rgn>) to get the value
propagated to repository.
Consult the log files in: /u01/oracle/product/agent/agent10g/sysman/log
And when I try to reset the time zone, I get the following error message:
replica6-replica:</u01/oracle/product/agent/agent10g/bin> $emctl resetTZ agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Updating /u01/oracle/product/agent/agent10g/sysman/config/emd.properties...
----- Tue May 8 11:33:29 2007::tzOffset for US/East-Indiana is -300(min), but agent is runnning with tzOffset -240(min)
----- Tue May 8 11:33:29 2007::trying again after waiting for 1 sec to account for daylight transition
----- Tue May 8 11:33:29 2007::tzOffset for US/East-Indiana is -300(min), but agent is runnning with tzOffset -240(min)
-----
resetTZ failed.
The agentTZRegion in:
/u01/oracle/product/agent/agent10g/sysman/config/emd.properties
is not in agreement with what the agent thinks it should be.
Fix your environment.
Pick a TZ value that corresponds to time zone settings listed
in: /u01/oracle/product/agent/agent10g/sysman/admin/supportedtzs.lst
Please help.
Answer
Question: I had a Grid Control for monitoring several of my Oracle database servers, Operating Systems, Oracle Application Servers, plus few Oracle Agents. It was working like a champ. I did not have any problems until my boss wanted me to change the location of Grid Control to a new server. He wanted me to change my Grid Control server from GridControlA to GridControlB.
So, I installed my new version of Grid Control to my new server GridControlB. I removed Grid Control on GridControlA and shutdown the server. I went to each database servers and updated the emd.properties file and change the wallet and repository_url properties to point to the new Grid Control.
Now, my Grid Control can not see any of my database targets. What have I done wrong? Please help.
Answer
Question: I had
Oracle8i Database and upgraded to Oracle9i with the same tablespace structures.
SQL> create table
mytable (mycolumns number) tablespace users;
create table mytable (mycolumns number)
ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'
Please help me that why I am getting this error message.
Answer
Question: When
I run the export utility, I get the following error:
ORA-04020: deadlock detected while trying to lock object SYS.CDC_ALTER_CTABLE_BEFORE
How can I fix
the problem?
Answer
Question: I exported the old version dump file into the new 10g release file and since then
I have problem with my EM. I can not use my http://myserver:port/em
I get the following error messages when I start it.
To start:
/u01/app/oracle >emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://HRMS2:1158/em/console/aboutApplication
ps: unknown output format: -o cmd
ps: illegal option -- -
ps: unknown output format: -o ls
usage: ps [ -aAdeflcjLPy ] [ -o format ] [ -t termlist ]
[ -u userlist ] [ -U userlist ] [ -G grouplist ]
[ -p proclist ] [ -g pgrplist ] [ -s sidlist ]
'format' is one or more of:
user ruser group rgroup uid ruid gid rgid pid ppid pgid sid taskid
pri opri pcpu pmem vsz rss osz nice class time etime stime
f s c lwp nlwp psr tty addr wchan fname comm args projid project pset
Starting Oracle Enterprise Manager 10g Database Control ....................
started.
------------------------------------------------------------------
Logs are generated in directory
/u01/oracle/product/10.2.0/HRMS2_budget/sysman/log
Answer
Question: I added more than 200 users to to a group
in the portal and now I am getting the following message. How can I change the
parameter so I don't get this message.
Answer
Question: My OID Superuser (orcladmin) password was
locked. How can I unlock the orcladmin password?
The
following error I am getting when I connect or logon to OID as cn=orcladmin (the
superuser). Password
Policy Error:9001: cn=orcladmin: Your account is locked
Error:
Your password has expired. Please contact administrator to reset it.
Answer
I
want to change my port from 7777 to 80, how can I do that. For example:
when a user type "http://servername:7777, he or she be able to only
type "http://servername." How
can I do that.
How
to change the SYSMAN user password for the Oracle Grid Control?
How
can I pass a PL/SQL table as a parameter using PL/SQL language?
How
to clean my Intelligent Agent
on Oracle 9i?
I have an specific user that I want to run from an specific server. How can I check its session and if it is opening some other session so I kill its session.
Setting up Connect for ODBC with Oracle's Heterogeneous Services
Schedule
an automatic OFFLINE or COLD Oracle backup...
Schedule
an automatic ONLINE or HOT Oracle backup...
How to
secure my Oracle Database?
The
following are the most important Oracle Dictionary Tables.