Recent content by cliousa

If you read the Oracle RAC on Solaris installation guide, that should the best cookbook available. It's easy, takes about 1 day for two nodes to complete. Good luck, HTH, clio_usa - OCP 8/8i/9i DBA

Hi You can clone your database from a cold backup How to clone db from cold backup or hot backup How to clone db from hot backup HTH, clio_usa - OCP 8/8i/9i DBA Hope that helps, clio_usa - OCP DBA ------------------ www.dbaclick.com

How to fix the Pentium 4 problem when installing Oracle 8i/9i see this: http://www.dbaclick.com/forums/archive/8/1351.html http://www.dbaclick.com/forums/archive/8/824.html Hope that helps, clio_usa - OCP DBA ------------------ www.dbaclick.com

Shutdown the instance first, then try again. And always set the oracle_sid on the command prompt before working with each instance, eg. c:\>set oracle_sid=..... c:\>sqlplus /nolog SQL> ..... Hope that helps, clio_usa - OCP DBA ------------------ www.dbaclick.com

1. Should we make the SYSTEM tablespace locally managed? No. I doubt you can do that in 9.2.0. AT least in 9.0.1 was still LMT. There's no benefit of doing it. 2. Should we make our LMT tablespaces UNIFORM or AUTOALLOCATED? UNIFORM is better, since you have control over the extent's size...

Check this article: http://www.dbaclick.com/forums/archive/15/2549.html (CREATE OR REPLACE PROCEDURE retrieve_lob ). It shows how to retrieve LOB data to flat file. Hope that helps, clio_usa - OCP DBA ------------------ www.dbaclick.com

To find the Oracle version, first find your ORACLE_HOME: $ echo $ORACLE_HOME Then start the SQL*Plus and see the version: $ sqlplus /nolog Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production SQL> TO...

There is a bug in 8.1.7 if SERIAL_REUSE = ALL in setup in init.ora file. This bug is fixed in Oracle9i As workaround unset the SERIAL_REUSE parameter in your init.ora file which means using the default value of SERIAL_REUSE = DISABLE Hope that helps, clio_usa - OCP DBA ------------------...

tnsping Oracle binary cannot find the message files from the proper ORACLE_HOME. Make sure the ORACLE_SID, oRACLE_HOME and LD_LIBRARY_PATH are setup in the bash shell environment. Hope that helps, clio_usa - OCP DBA ------------------ www.dbaclick.com

Yeap. That alwasy helps. Use counter and commit when reached the commit point. Example: SET ECHO OFF SET TRANSACTION USE ROLLBACK SEGMENT BIG_ONE; DECLARE v_commit_point NUMBER := 1000; v_error_code NUMBER; v_error_message VARCHAR2(200); v_id NUMBER; CURSOR...

Before you start the instance set the ORACLE_SID variable first: c:\> set oracle_sid=SID-NAME c:\> svrmgrl svrmgrl> connect internal Hope that helps, clio_usa http://www.dbaclick.com Hope that helps, clio_usa - OCP DBA ------------------ www.dbaclick.com

An ORA-12540 can be a result of the processes parameter in the "init.ora" being too low. Processes should be set to the number of background processes plus one for each connection to the database. Hope that helps, clio_usa - OCP DBA ------------------ www.dbaclick.com

If you stop paying for Support & Upgrade - you can still use the license you paid for. There is one catch - you cannot apply patches or upgrade to the next version, unless you renew your Support & Upgrade options. And you cannot renew your Support & Upgrade options once you terminated them on...

It's the same, since the GUI is the same. When you come to the screen which ask you for Enterprise, Standard edition, there will be another option - Client. Select this ratio button and carry one. Hope you know how to start the OUI on UNUX? Hope that helps, clio_usa http://www.dbaclick.com

Read this article: http://www.dbaclick.com/modules.php?op=modload&name=News&file=article&sid=275 It has examples for both insert/query BLOB datatypes in Oracle. Hope that helps, clio_usa http://www.dbaclick.com