Error message: OpenSSH failed to add the hosts to the list of known hosts
Workstation: Windows 7 x64 Authenticated with domain server
OpenSSH: OpenSSH for Windows v3.8.1p1-1 x64
This issue has been going on for a while in my machine, what is boring is that every (more...)
Once I heard someone who said "When you teach you learn twice", and it is very true, helping others through this blog has in the long run helped me too. This blog has been a valuable reference for me too, while "googling" for a specific issue I'm facing sometimes I find the answer in a post I made in the past that I didn't remember, so (more...)
Everything was just fine, in my opinion there's not too many new functionality I could take advantage of at this time, and there were some new apps installed and yes, a very cool world clock similar to that one I used (more...)
Version : Oracle 22.214.171.124.0 PSU 9
After applying the PSU the DBMS_MEATADA didn't work.
SQL> select DBMS_METADATA.GET_DDL('TABLE','EMP','SCOTT') from DUAL;
ORA-39212: installation error: XSL stylesheets not loaded correctly
ORA-06512: at "SYS.DBMS_METADATA", line 5088
ORA-06512: at "SYS.DBMS_METADATA", line 7589
ORA-06512: at line 1
A side effect of this, when trying to execute DataPump it failed, since this requries DBMS_METADATA to extract the object metadata.
C:\> expdp aUser/aPassword schemas=SCOTT dumpfile=SCOTT logfile=SCOTT job_name=SCOTT
Export: Release 126.96.36.199.0 - Production on Thu Sep 13 11:15:16 2012
Copyright (c) 1982, (more...)
The first one, has to do with a runtime error during the execution of the OPatch utility. Suddenly a window pops up saying it cannot find the msvcr71.dll library, this is a module containing standard C library functions such as asprintf, memcpy and cos, it is part of the Microsoft C Runtime Library. The workaround for it was to look for it at one of the previously installed Oracle Homes and copy it (more...)
Thank you Justin and Good Luck with your new professional goals.
Cause: The values of one or more configuration properties were inconsistent with database in-memory settings or server parameter file settings. This may happen by altering initialization parameters directly instead of altering property values using Data Guard broker.
Actions: Query property the InconsistentProperties on the database or check the Data Guard broker log to find which properties are set inconsistently. Reset these properties to make them consistent with the database settings. Alternatively, enable the database or the entire configuration to allow the configuration property settings to be propagated to to the (more...)
Recently something weird happened, one of those auto updates that bring down the system and ask for restart of applications, and suddenly my Firefox stopped displaying the Enterprise Manager performance graphs. I had to temporarily switch to Internet Explorer while I was able to find a solution (more...)
This error was recently reported to me,
ORA-00600: internal error code, arguments: [kgiinb_invalid_obj], [0x102BE8B38],
[0x12CF3EED8], , , , , , , , , at
OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object
src, String procedure ....
Oracle Server - Enterprise Edition - Version: 188.8.131.52
This problem can occur on any platform.
Oracle Server Enterprise Edition - Version: 184.108.40.206
After some research I found that basically this is due to a bug (7420394) which can be fixed by applying the patch for it, or upgrading to 11.2.0.
] ... hmmm ... it looks impressive, overall considering that an ORA-00600 is not one that probably is going to make your DBA day.
Actually it is not as tragic and epic as it could seem to be at first glance, it has to do with a bug. In this particular case it showed up in an Oracle 11g Rel.1 (220.127.116.11.0) version on a x64 windows platform. This error is triggered when the SYS_AUTO_SQL_TUNING_TASK runs, and it may spontaneously show up and keep on (more...)
Message: ORA-00604: error occurred at recursive SQL level 1
ORA-13236: internal error in R-tree processing: [insertion at root (mdrbin_mem_ins_rt)]
ORA-13236: internal error in R-tree processing: [partition and pair bucket (mdrbin_optmz_mem_ins_node)]
ORA-13236: internal error in R-tree processing: [pair buckets (mdrbin_partition_pair_bckts)]
ORA-13236: internal error in R-tree processing: [mdrugnd - getting a node (mdrbin_pair_bckts)]
ORA-13234: failed to access R-tree-index table [MDRT Table]
ORA-29400: data cartridge error
Error - OCI_NODATA
ORA-06512: at "MDSYS.SDO_IDX", line 149
ORA-06512: at line 1
StackTrace: at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String (more...)
Larry Ellison entered in his own personal style, and the first phrase that he pronounced gave the guideline to what this was about ... he said "Sometime back when we bought Sun the customers said that Oracle was already into the hardware business, but we didn't receive the memo" ... referring (more...)
Oracle Open World Day 0. Arrival to SFO.
Visiting the Oracle Open World in my personal experience is the opportunity to meet with peers, networking, updating knowledge, interact with people, meet the gurus, and have fun. My OOW started on Saturday, and the visit to the holy Oracle Headquarters is a must for me. It's the reminder of the long journey I've walked so far along with the company.
The temparature was nice, a typical autum californian day, beautiful, I love this weather. However, you never know, I remember some years back San Francisco had a severe cold front that (more...)
Let's assume a given date in a default DD-MON-RR format like this:
select sysdate - to_date('08-OCT-75') from dual;
Define a Variable which will hold the number in days and fraction of days
define DateDay = 13084.4081
Then the query
TO_NUMBER(SUBSTR(A,1,4)) - 2000 years,
TO_NUMBER(SUBSTR(A,6,2)) - 01 months,
TO_NUMBER(SUBSTR(A,9,2)) - 01 days,
FROM (SELECT TO_CHAR(TO_DATE('20000101','YYYYMMDD')
+ &DateDay,'YYYY MM DD HH24:MI:SS') A
and you've got your formatted output.
YEARS MONTHS DAYS HO (more...)
The operation can be performed by creating a datafile copy, either with the traditional commands or by means of recovery manager. In this case the following script was prepared to move a datafile.
copy datafile '
sql 'ALTER TABLESPACE
set newname for datafile (more...)
- Windows 2003, x86
- Oracle 18.104.22.168.0
When trying to start the listener, it took more time than usual, and after a while it showed up the following messages on the console:
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 22.214.171.124.0 - Production
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
And when trying to display the services this was shown by the lsnrctl services (more...)
There are some ORA-600 which can be easily googled, and there are others which are pretty difficult to find. This is the case. M.O.S reports this ORA600 to be related to a bug (9929660) on the 11.2 platform and which is fixed on 12.0.
Recently this error showed up on a Windows 2003 platform with Oracle 126.96.36.199.0. After deciphering the almost cryptic related trace and dump file and diagnosing after the possible environment causes. I found out this error was triggered at one of the internal performance maintenance task, (more...)
Start monitoring the index.
alter index SchemaOwner.IndexName monitoring usage;
After a while, query the V$OBJECT_USAGE view.
select * from V$OBJECT_USAGE;
It came to my surprise that the view was empty. The reason ... I knew it some time back ... but I forgot. I googled and I found a very good reference from Alex Gorvachev, who went (more...)
ALTER USER IDENTIFID BY VALUES '14C785FC66029BF9';
it could take the hashed value from the DBA_USERS data dictionary view. However starting with Oracle 11g this column is null ... so where are we supposed to take this hashed value from?.
SQL> SELECT USERNAME, (more...)