 | | | Oracle List | |
What is your oracle home set to? Either you can patch your 8.1.7 or otherwise somepeople do it on a separate OH. Did you look into oraInventory logs?
HTH
GovindanK
On Fri 9 Mar 2007 19 48 40 -08Oracle came up with a patch with hours to go
Subject ORA-600 [22635] and ORA-600 [KOKEIIX1] Reported While Upgrading
Or Patching Databases To 10.2.0.3 Doc ID Note 412271.1
HTH
GovindanK
--
http //
I came across this link recently.
[1]http //www.sun.com/bigadmin/hubs/dst/ leads to
Sun(sm) Alert Notification
* Sun Alert ID 102836
* Synopsis Olson TZ Data (tzdata2005r or greater) IncompaAt the end.
Simple to see (10.2.0.3)
SQL > create table t (x int) ROWDEPENDENCIES
Table created.
SQL > column scn form 99999999999999999999999
SQL > select dbms_flashback.get_system_change_number s
May be you would need to Purge the Recycle bin. Are you using Bigfile/DMT/LMT?
Refer to Metalink Notes Note 380473.1 Note 1061937.6
Are you receiving any error while shrinking?
HTH
GovindanK
Oni 've got an external table defined as
CREATE TABLE "CMAP_WH ". "OIL_WORLD_DATA "
( "MEASURE_NAME " VARCHAR2(50 BYTE)
"GEOGRAPHY_NAME " VARCHAR2(50 BYTE)
"COMMODITY_NAME " VARCHAR2(50 BYTE)
"IGNORE "My recommendation would be to go with the initial plan of two diskgroups per database. Oracle 's recommendations seems to come from a philosophy of consolidation where there would only be one databaseTrue genius! Unfortunately Oracle removed that feature on Unix-based
operating system too in 10g so it 's a good thing your developers used
perl so that you can make use of it on Unix too -)
Regardi 've got an external table defined as
CREATE TABLE "CMAP_WH ". "OIL_WORLD_DATA "
( "MEASURE_NAME " VARCHAR2(50 BYTE)
"GEOGRAPHY_NAME " VARCHAR2(50 BYTE)
"COMMODITY_NAME " VARCHAR2(50 BYTE)
"IJust curious about success stories creating installable
packages of an Oracle client for installation via LanDesk
or other means.
We have tried using the Wise Installer but it seems to
choke on the Installing 9.2.0.1 into a new ORACLE_HOME on an HPUX machine that already
has 9.2.0.4 installed in another ORACLE_HOME and a database running from
it. Want to patch the new 9.2.0.1 ORACLE_HOME up tSome mess-up in the old ORACLE_BASE/oraInventory was causing it (probably
caused by lil ' ol ' me). I renamed it (it 'll go away soon anyway) and let
OUI create another oraInventory. All is proceedin
Alexander has given some inputs. Also what version? Are you on Solaris 9.2.0.1 It had a bug The dbms_job used stop for no apparent reason (though in your case it does not kick in at the first placI am posting this on behalf of Mark Gardner with Fugro Consultants Inc.
in Austin Texas. Please direct all replies to MGardner@(protected)
Mark is looking for an Oracle DBA to come in as a consultant } There are lots of examples of successful validate outputs.
} Does anyone have an example of a failure or preferably some keywords
} that are in an output of a validate that fails?
} I need somethingFWIW . . .
I 'm thinking it might not be a bad idea to capture our current dbms_job and
dbms_scheduler jobs into a text file pre-DST so we can compare them with
post-DST
Here 's what I 'm gathering
dbI 've started having a strange issue here with our Oracle OEM console.
My connection preferences are gone and I can not add them back in. I 've
been running OEM without any major issues for years and tHelp
The test for DST is not working
SQL > select case to_number(to_char(to_timestamp_tz
( '20070311 00 00 00 US/EASTERN ' 'YYYYMMDD HH24 MI SS TZR ')
+ to_dsintervalHas anyone encountered the following error using impdp using
parallelism this is an excerpt from a 5 GB trace file that impdp
generated in the bdump directory.
***Got internal error Exception caughtSir
I am trying to install Oracle 10g using response file.I have edited se.rsp file as per requirement.
I am using Oracle 10g Standard Edition on Solaris 10 ( 64 bit)
I am getting bellow errHi
I have RMAN backing up our project databases with RMAN and the flashback recovery area.
We want to backup our flash back recovery area backupsets to a remote disk location for pickup on a standardHello
I have Oracle database version 9.2.0.7 which is working on HP-UX
(Itanium). Recently the corrupted block occurs. This problem appears
random at various time. Below I show dump block
Corrupt bI am trying to install the 10.2.0.2 patch for windows and Oracle installer
is requesting that I shutdown about ~30 services before I can continue. I
can actually only shut down about 20 of them. The r
You said " It looks like both the session got the ROW-X lock but one
session is
waiting on getting the Transaction lock. ". Can you provide a full test
case for that? The second session waits on the John
Along with what others have said have you considered using a
post-process PL/SQL routine to clean the data once it is loaded into
your table? Either you pay the price up front of cleaning I need to strip out all spaces from a string when loading data via
sqlldr direct load.
Is this possible? What would be the control file syntax?
Needs to work in Oracle 8 and 9.
John in tHi Gopal
I believe the intention of the WP is that the S.A.M.E. methodology is
followed.
The more disk groups the less disks would be striped and mirrored within
each one implying worse performanI recently built a 2-node RAC-on-Linux-on-VMWARE on my laptop in just 1-GB
of RAM with a single-core cpu. I followed Vincent Chan 's document at
http //www.oracle.com/technology/pub/articles/chan-ubl-On 3/12/07 Mark Strickland <strickland.mark@(protected) > wrote
>
> BTW compared to Symantec 's support site Metalink is a thing of beauty.
>
>
The only effective method for searcing the veritas suppoIs this a true statement
"In 10g you must license spatial to use locator. "
thanks.
|
|
|
