-
Archives
- April 2019
- March 2019
- September 2018
- August 2016
- July 2016
- May 2015
- April 2015
- December 2014
- November 2014
- August 2014
- February 2014
- January 2014
- November 2013
- July 2013
- June 2013
- March 2013
- December 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- March 2012
- October 2011
- August 2011
- June 2011
- May 2011
- April 2011
- March 2011
- December 2010
- November 2010
- October 2010
- August 2010
- July 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
-
Meta
Author Archives: Ronny Egner
Changing the Timezone for a particular Database *only* in a RAC
Sometimes there are requests that multiple databases running on the same RAC return different time values — so they must run in different time zones. This goal cannot achieved by changing the server time zone because that would affect ALL … Continue reading
Posted in Oracle in general
Leave a comment
ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at “SYS.CDBVIEW_INTERN during upgrade
During a database upgrade vom 11.2.0.4 to 18.4.1 i encountered the following problem: REASON: ERRORS FOUND: During Upgrade FILENAME: /data/oracle/product/cfgtoollogs/dbua/upgrade2019-02-22_10-18-20AM/DB/catupgrd1R0.log AT LINE NUMBER: 666432 —————————————————— Identifier CATALOG 19-02-22 11:00:37 SCRIPT = [/data/oracle/product/18.4/rdbms/admin/cdcore_cols.sql] ERROR = [ORA-01422: exact fetch returns … Continue reading
Posted in Oracle in general
Leave a comment
RMAN shows: could not locate the LNM save file ‘fqnacfte_1_1’ on server ‘nsrserverhost’. (2:9:2)
During an RMAN restore of a backup made to a networker server the restore fails retrieving a backup piece: restore datafile 2; channel ORA_SBT_TAPE_1: starting datafile backup set restore channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set channel ORA_SBT_TAPE_1: … Continue reading
Posted in Networker, Oracle in general
Leave a comment
Direct NFS: Failed to set socket buffer size.wtmax=[1048576] rtmax=[1048576], errno=-1 on Solaris
This error occured on Solaris (SPARC) using Direct NFS (dNFS). The MOS Note is incomplete and only recommends to increase the send and receive buffers, but the solution is below: /usr/sbin/ndd -set /dev/tcp tcp_xmit_hiwat 1056768 /usr/sbin/ndd -set /dev/tcp tcp_recv_hiwat … Continue reading
Posted in Oracle in general
Leave a comment
Exadata outage due to ASM disks missing
On some older Exadatas it can be that Grid Disks belonging to a cell are not found anymore. And not even FORCEing the moutn helps: FAILGROUP HEADER_STATU COUNT(*) —————————— ———— ———- EXA01CEL02 MEMBER 34 EXA01CEL03 MEMBER 34 EXA01CEL04 MEMBER 34 … Continue reading
Posted in Oracle in general
Leave a comment
ORA-29760: instance_number parameter not specified — without INSTANCE_NUMBER set
Oracle is complaining about: ORA-29760: instance_number parameter not specified And you have triple checked that the INSTANCE_NUMBER parameter is specified, but you still get the error. The reason for that is, that your ORACLE_SID contains a underscore, e.g. ORA_SB. Starting … Continue reading
Posted in Oracle in general
Leave a comment
ORA-00902: invalid datatype on MDSYS.SDO_GEORASTER during CREATE TABLE in 12c
Since i haven´t found this on the web: When you try to create a table with MDSYS.SGO_GEORASTER and you´re receiving an ORA-00902: invalid datapye try the following: SQL> @create_tab.sql “GEORASTER” “MDSYS”.”SDO_GEORASTER” , * ERROR at line 12: ORA-00902: … Continue reading
Posted in Oracle in general
Leave a comment
RAC refuses to start – or how installing TSM caused a cluster outage
Some days back i setup a new server for a customer of mine. Installation and patching ran fine, cluster was stable – no issues. Then suddenly the cluster started to act strange. Commands did not work anymore; after a reboot … Continue reading
Posted in Oracle in general
Leave a comment
Parity-based redundancy (RAID5/6/triple parity and beyond) on BTRFS and MDADM (Dec 2014)
While reading the following posts (second post) from Adam Leventhal I have wondered what is exactly the status of parity-based redundancy in general and triple-parity in particular on Linux in MDADM and BTRFS. TL;DR: There are patches to extend the … Continue reading
Posted in UNIX
4 Comments
Finally: I am now Oracle Certified Master 11g
Yes! I made it. I successfully accomplished the exam and i am now a proud member of the OCM family: