iSelfSchooling.com  Since 1999     References    .Job Openings      . FREE Online Oracle Materials 

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision     .Services     .Biography     .Acknowledgement      .Links... 

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

ARTICLES and 

ANSWERS to your Technical QUESTIONS

Question: 

How can I create a physical Oracle standby database (Data Guard)?

Answer

 

Question: 

I have an Oracle test database which I found unable to open, because my undo log somehow got corrupted.

In my alert file I get the following error when I try to open the database:

Errors in file /u01/oracle/admin/TESTGEA/ udump/ORA26786760.TRC:
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: '/u06/UNDOTBS01.DBF'
...
Error 376 happened during db open, shutting down database

The log file ORA26786760.TRC has very little information, it simply says:

KCRA: buffers claimed = 6/6, eliminated = 0
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: '/u06/UNDOTBS01.DBF'

It looks like that my database has corrupted undo tablespace. When I use the dbv command (dbv file='/u06/undotbs01.dbf' blocksize=64384) I get an error message that my undo tablespace is corrupted.

 

Please advise what I need to do. I cannot open my database and I cannot do anything.

Thanks for your help.

Answer

 

Question: 

How Can I use LogMiner to Analyze Redo Log Files?

Answer

 

Question: 

When the user run a report sometimes they get the following error message:

Please let us know how we can fix this problem.
-----
javax.servlet.jsp.JspException: Portlet execution failed
at gov.senate.transaact.common.ui .tags.ExecuteControllerTag .doStartTag(ExecuteControllerTag.java:68)

at htdocs._adminreports._AdminRepo rtsGenerationPortlet._jspServic e(_AdminReportsGenerationPortle t.java:57)
at com.orionserver.http.OrionHttpJ spPage.service (OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTab le.service(JspPageTable.java:350)
at oracle.jsp.runtimev2.JspServlet .internalService(JspServlet.java:509)
at oracle.jsp.runtimev2.JspServlet .service(JspServlet.java :413)
at javax.servlet.http.HttpServlet .service(HttpServlet.java:853)
at com.evermind.server.http .ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
at oracle.security.jazn.oc4j .JAZNFilter.doFilter(Unknown Source
at com.evermind.server.http .ServletRequestDispatcher .invoke(ServletRequestDispatcher.java:663)
at com.evermind.server.http .ServletRequestDispatcher .forwardInternal(ServletRequestDispatcher.java:330)
at com.evermind.server.http .HttpRequestHandler.processRequ est (HttpRequestHandler.java:830)
at com.evermind.server.http .AJPRequestHandler.run(AJPRequestHandler.java:224)
at com.evermind.server.http .AJPRequestHandler.run(AJPRequestHandler.java:133)
at com.evermind.util.ReleasableRes ourcePooledExecutor$MyWorker .run (ReleasableResourcePooledExecuto r.java:192)
at java.lang.Thread.run(Thread.java:534)
Caused By: java.lang.OutOfMemoryError

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.

Automatic Oracle startup and shutdown under Solaris OS...

 

What is the best option to used in dbms_stats in order to get the most accurate statistics within a schema?

 

SQL Trace is writing 100s of trace or dump files into user dump directory. How can I stop it?

 

How to install Oracle9i on the LINUX Operating System?

 

Oracle9i Limitation...

 

Why do I get this error message " FRM-10142 the HTTP Listener is not running on xxxx at port 8888. Please start the listener or check your runtime preferences, when I try to run my FORMS?" 

 

How can I re-organize a table that contains a LONG datatype and also how can I analyze all my Oracle tables and indexes?

 

How can I pass parameters between Oracle FORMS?

 

When I startup my database, I get an error and tells me that one of my datafile is missing. How can I bypass that error and start my database?

 

How to use csscan and how to convert my database from one charater set to another...

 

An Example of how to use DBMS_DDL package...

 

Examples of different type of Triggers...

 

Can anyone see an Oracle record without accessing to Oracle database?

 

Automatic Oracle startup and shutdown under Solaris OS...

 

Schedule an automatic OFFLINE or COLD Oracle backup...

 

Schedule an automatic ONLINE or HOT Oracle backup...

 

COMMON Oracle Database Recoveries...

 

Introduction to IP address...

 

I was a witness and we, too, can do...

 

How to use the Oracle Cluster Table?

 

How to apply Oracle patches in General?

 

How to troubleshoot the Oracle Intelligent Agent?

Author: Charlie Richards

email: n/a

 

How to create a FORM block?

Author: Jerry Smith

email: n/a

 

How to install the Oracle Collaboration Suite on a single/multiple LINUX server?

Author: LINUX users group

email: n/a

 

Some basic roles to secure the Oracle Database

Software installation remotely

How to rename a multiple UNIX file system?

How can I start and trace 8i and 9i Data Collection Service (Data Gatherer and IA)?

How to stop or start Oracle Application Server target components (Oracle10g iAS)?

Consider no experience...

Diagnostic and Tuning Tools

 

Articles on Basic information on Introduction to 

How to install the Oracle Collaboration Suite on a single/multiple LINUX server?

How to install Oracle RAC on Sun Cluster?

What is RDA?

How can I troubleshoot components of Oracle9iAS?

How can I setup Oracle9iAS passwords?

Nutrition and Your Health: 2005 Dietary Guidelines for Americans

By: Advisory Committee

How can we de-install Oracle9iAS from UNIX?

How can we de-install Oracle9iAS from Windows?

How to apply recommended patches?

How to install Oracle software remotely?  

How to start and stop an Oracle Internet Application Server?

How to install an Oracle Internet Application Server?

How to replicate data from location "A" to "B" based on a table with a NESTED TABLE collection type?

How to replicate data from location "A" to "B" based on an object table?

How to replicate data from location "A" to "B" based on a table with a VARRAY collection type?

How to replicate an object from location "A" to "B" based on a table with a column object?  

How to submit, run, and remove an Oracle job?

How to create, use, and pass a parameter list?

How to populate a POPLIST item?

How to create a database link?

How to use very fast time series queries?

How to use the "WHEN-VALIDATE-ITEM" trigger?

How to use DBMS_PIPE package?

How to use DBMS_SQL Package?

My failure...

 

Google
 
Web web site