Tales of an oracle dba

Friday, November 25, 2016

restore table space in PDB

As said earlier, I am currently doing a POC on multitenant 12.1.0.2 for my customer.
Unfortunately 12.1 and not 12.2 which seems to have really nice features especially with regards to FLASHBACK, limiting resources in the containers ....

One of the tasks I am investigating is backup and recovery. here some findings so far.

Situation :

CDB called CDB

container called ORA1

I have used OMF this time on a regular fs just to be able to easily remove datafiles while the db is running ....




SQL>!rm /oradata/CDB/2223196C0BE77A23E053144EA8C066EC/datafile/o1_mf_users_d3k2nnz6_.dbf'



SQL> alter session set container = ora1

  2  /



Session altered.



SQL>  select * from phil.test;



no rows selected



SQL>

SQL> create table phil.test2 as select * from dba_objects;

create table phil.test2 as select * from dba_objects

                                                   *

ERROR at line 1:

ORA-01116: error in opening database file 10

ORA-01110: data file 10:

'/oradata/CDB/2223196C0BE77A23E053144EA8C066EC/datafile/o1_mf_users_d3k2nnz6_.db

f'

ORA-27041: unable to open file

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

ok the file is gone ! yippee

next step connect to RMAN

ok connected in the CDB :





$ rman target /



Recovery Manager: Release 12.1.0.2.0 - Production on Fri Nov 25 15:18:00 2016



Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.



connected to target database: CDB (DBID=2009742972)



RMAN> restore tablespace ora1:users;



Starting restore at 25-NOV-16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=17 device type=DISK



channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00010 to /oradata/CDB/2223196C0BE77A23E053144EA8C066EC/datafile/o1_mf_users_d3k2nnz6_.dbf

channel ORA_DISK_1: reading from backup piece /oraarch/bck/CDB_0grlqcro_1_1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 11/25/2016 15:18:11

ORA-19870: error while restoring backup piece /oraarch/bck/CDB_0grlqcro_1_1

ORA-19573: cannot obtain exclusive enqueue for datafile 10



RMAN>



RMAN>



RMAN> alter database datafile 10 offline;



RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of sql statement command at 11/25/2016 15:19:35

ORA-01516: nonexistent log file, data file, or temporary file "10"







RMAN> exit

ok the CDB is not aware of datafile 10 ....

connect to SQLPLUS





 sqlplus / as sysdba



SQL*Plus: Release 12.1.0.2.0 Production on Fri Nov 25 15:21:54 2016



Copyright (c) 1982, 2014, Oracle.  All rights reserved.





Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options



SQL> alter session set container = ora1;



Session altered.



SQL>  alter database datafile 10 offline;



Database altered.

ok back to RMAN





rman target /



Recovery Manager: Release 12.1.0.2.0 - Production on Fri Nov 25 15:22:44 2016



Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.



connected to target database: CDB (DBID=2009742972)



RMAN> restore tablespace ora1:users;



Starting restore at 25-NOV-16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=267 device type=DISK



channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00010 to /oradata/CDB/2223196C0BE77A23E053144EA8C066EC/datafile/o1_mf_users_d3k2nnz6_.dbf

channel ORA_DISK_1: reading from backup piece /oraarch/bck/CDB_0grlqcro_1_1

channel ORA_DISK_1: piece handle=/oraarch/bck/CDB_0grlqcro_1_1 tag=TAG20161125T151456

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

Finished restore at 25-NOV-16



RMAN> recover tablespace ora1:users;



Starting recover at 25-NOV-16

using channel ORA_DISK_1



starting media recovery

media recovery complete, elapsed time: 00:00:00



Finished recover at 25-NOV-16



RMAN> exit

ok table space restored and recovered .

where are the datafiles now ?





SQL> alter session set container=ora1;



Session altered.



SQL> select name from v$datafile;



NAME

--------------------------------------------------------------------------------

/oradata/CDB/datafile/o1_mf_undotbs1_c1yz8bk7_.dbf

/oradata/CDB/2223196C0BE77A23E053144EA8C066EC/datafile/o1_mf_system_c1yzs31m_.db

f



/oradata/CDB/2223196C0BE77A23E053144EA8C066EC/datafile/o1_mf_sysaux_c1yzs31t_.db

f



/oradata/CDB/datafile/o1_mf_users_d3k7f3tk_.dbf

ok so the users tablespace was restored in the CDB root directory ....
instead of here :



/oradata/CDB/2223196C0BE77A23E053144EA8C066EC/datafile/o1_mf_users_d3k2nnz6_.dbf

hmm lets check if we see the same when connecting to PDB instead of CDB when recovering :

so same scenario remove the datafile ...



[oracle@12cR1 datafile]$ rman target sys@ora1



Recovery Manager: Release 12.1.0.2.0 - Production on Fri Nov 25 15:42:42 2016



Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.



target database Password:

connected to target database: CDB (DBID=2009742972)



RMAN> restore tablespace users;



Starting restore at 25-NOV-16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=21 device type=DISK



channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00010 to /oradata/CDB/datafile/o1_mf_users_d3k7f3tk_.dbf

channel ORA_DISK_1: reading from backup piece /oraarch/bck/CDB_0grlqcro_1_1

channel ORA_DISK_1: piece handle=/oraarch/bck/CDB_0grlqcro_1_1 tag=TAG20161125T151456

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

Finished restore at 25-NOV-16



RMAN> recover tablespace users;



Starting recover at 25-NOV-16

using channel ORA_DISK_1



starting media recovery

media recovery complete, elapsed time: 00:00:00



Finished recover at 25-NOV-16




RMAN> alter tablespace users online;



Statement processed

okay restored where they were originally stored

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options



SQL> select name from v$datafile;



NAME

--------------------------------------------------------------------------------

/oradata/CDB/datafile/o1_mf_undotbs1_c1yz8bk7_.dbf

/oradata/CDB/2223196C0BE77A23E053144EA8C066EC/datafile/o1_mf_system_c1yzs31m_.dbf




/oradata/CDB/2223196C0BE77A23E053144EA8C066EC/datafile/o1_mf_sysaux_c1yzs31t_.dbf



/oradata/CDB/2223196C0BE77A23E053144EA8C066EC/datafile/o1_mf_users_d3k8lbts_.dbf

for me while making sense I see lots of potential issues with this ;) so I hope it was worthwhile to note this down

Thursday, October 27, 2016

multitenant series

Yes I finally get the opportunity to work on multitenant, my customer is evaluating this feature.

the coming weeks you will see more posts about this oracle feature. It will be more like small findings about multitenant.

So far I learned a lot this series will document it for you and for me ;--)

stay tuned

Tuesday, October 11, 2016

OTN Appreciation Day : SuperCluster

OTN Appreciation event

Tim Hall aka as Mr Oraclebase started a great initiative to show and share our love for the oracle community and the OTN program.

The idea was to do a non tech talk about an Oracle software feature / product you are fond of.

I am definitely cheating here because the product I choose to show my appreciation contains other Oracle Software products (Oracle database, RAC, Grid ,Solaris ), for people who know me it is no surprise I will be talking about SuperCluster in this blogpost.

I would like to convince you to dig deeper in the Sparc SuperCluster :-), don't hesitate to contact me in case of questions.

I often call it Exadata ++ and it definitely is that, it offers you the stability , flexibility and ease of use, straightforwardness of Solaris together with the secret sauce of exadata : storage cells and as a bonus an infiniband integrated ZFS SA from which the os boot, you can use it as well to put on other data or backups.

To me it is the ultimate consolidation platform and in memory machine
( up to 32TB of RAM in the M6) you can run both database applications as other applications on the same box.

The product made fantastic improvements over the years and from the early beginning offers almost zero overhead virtualization with hardware isolation.

The latest generation comes with incredible M7 chip which not only offers 32 cores per chip but also “DATA ANALYTICS ACCELERATORS” called DAX, the DAX takes work from the main cores, it takes over decompression, encryption, ….

The M7 can encrypt and decrypt with almost no overhead, the benchmarks I saw had an overhead of 3%.

I hope to lay my hands on one of those machines the next months.

I also hope I made you curious about this fantastic product Some links : https://community.oracle.com/community/server_%26_storage_systems/application_development_in_c__c%2B%2B__and_fortran/softwareinsilicon/overview http://www.oracle.com/technetwork/server-storage/engineered-systems/oracle-supercluster/overview/index.html

post OOW thoughts

OOW 2016 where to start…

My first and last OOW dated from 2012 so this was my second OOW.

It started with some quirks : issues in Brussels caused my flight to be delayed by 132min making me miss my other flight in Zurich, I was happy to hear that i was rebooked on a flight to Boston the same day, sad to hear 1h before that flight that that flight was cancelled and that i had to stay over in Zurich and take the plane the next day to Frankfurt to continue the journey.

So instead of arriving thursday I arrived one day later friday, missing some appointments I made in the morning.

After that it only got better.

Jan Karremans and Oyvind Isene came to collect me from the airport from where we took an Uber to Fremont to visit the Tesla factory.Ilmar Kerm and his Kristina joined us at the factory,

It was great to see how a car is in 6 days made from raw materials. I was surprised to see how many things they make theirselves onsite, other factories I visited worked with more suppliers.

Contrary to last time, I on purposely decided not to overload my agenda with sessions, most of the sessions I can I attend at other conferences.

For me the most important part of Open World are the demo grounds, the hands on labs and of course meeting up with friends and fellow oracle enthousiasts

The demo grounds in the exhibition hall is the place where you can get in contact with the product managers and sometimes even the developers of a software feature or product. I spend quite some time there and missed quite a few sessions because i didn’t see time pass ;-)

I am not going to bother you with the sessions I followed, that would bring us too far ;-)

It was great seeing so many friends back this year and to participate in the different activities organised by the community and product managers :

the ACE dinner

the golden gate run on Sunday

the bay swim on Monday

the gathering with SQL Developer friends in the 21st amendement

the Super Cluster reception

....

I really would like to thank Jennifer and Laura and everybody else from the ACE and OTN program for all the effort they put in giving us a great time at OOW.

Being part of the ACE program really made this a great experience.

Thursday, June 9, 2016

APR2016 combo ojvm + psu patch

Strange behaviour we noticed yesterday. we downloaded and installed the combo PSU OJVM patch p22738657 using opatch version 12.1.0.1.10 we deployed it both on Linux x86_64 as on Solaris SPARC. using opatchauto in the case of linux and using a generated oplan in the case of SPARC amazed to see that it looks like in both cases the OJVM patch wasn't install

[grid@charel008 ~]$ opatch lspatches
23006522;OCW Interim patch for 23006522
22806133;DATABASE BUNDLE PATCH: 12.1.0.2.160419 (22806133)
22674709;Database PSU 12.1.0.2.160419, Oracle JavaVM Component (Apr2016)
22502518;ACFS Patch Set Update : 12.1.0.2.160419 (22502518)
21436941;WLM Patch Set Update: 12.1.0.2.5 (21436941)
 
OPatch succeeded.

  
[oracle@charel008 ~]$ opatch lspatches
23006522;OCW Interim patch for 23006522
22806133;DATABASE BUNDLE PATCH: 12.1.0.2.160419 (22806133)
 
OPatch succeeded.

I checked a bit the usual directories to check and checked in

$ORACLE_HOME/.patch_storage/NApply/2016-05-25_10-48-41AM

And I don’t see the ojvm patch there However I see it here ….in grid home

 $GRID_HOME/.patch_storage/NApply/2016-05-25_11-06-16AM/
[ogrd@bert007 2016-05-25_11-06-16AM]$ ls
patchlist.txt
[ogrd@bert007 2016-05-25_11-06-16AM]$ cat patchlist.txt
User invokes OPatch via "NApply" to process the following patches:
 
snipped...

Patch ID: 22674709
Patch Location: "/u01/stage/patch_apr/22738657/22674709"
Patch storage area: "/u01/app/grid/product/12.1.0/grid/.patch_storage/22674709_Apr_5_2016_08_56_18"

then In bundle.xml in the patch directory


            
                
                    Oracle Database
                    Oracle 12.1.0.2.0
                
                
                    Oracle Database
                    Oracle 12.1.0.2.0
                
            
        
        
            
                
                    Oracle Database
                    Oracle 12.1.0.2.0
                
                
                    Oracle Database
                    Oracle 12.1.0.2.0
                
                
                    Oracle Database
                    Oracle 12.1.0.2.0
                
                
                    Oracle Database
                    Oracle 12.1.0.2.0

While for the patch straight under it is put type=”oracle_datababase” so I think the issue is there in the bundle.xml in the patch directory. Let's see what support says UPDATE : Support wasn't very clear about this and kept on saying that this patch shouldn't be installed on a non Exadata system, while this isn't the case. " Overview of Database Patch Delivery Methods ( Doc ID 1962125.1 ) Database Patch for Engineered Systems and Database In-Memory Short Name DBBP Target environment/s 12c DB installs on Exadata. Also applicable to any 12c system using Database In-Memory (DBIM) features, RAC or non-RAC. Applicable to both Database and Grid homes. DB Versions 12.1.0.2 onwards only Platform/s Unix platforms, including Exadata systems, but also for any system using DB In-Memory (DBIM) Released Released monthly. Patch Content Includes miscellaneous fixes for Engineered Systems along with fixes for Database In-Memory. Critical Patch content is included quarterly. Also includes fixes for the Grid home for Exadata and RAC systems. See Note:888828.1 Exadata Recommended Patch Information Note:756671.1 Current Recommended Patches Recommended Version Recommend to be on the latest quarterly release Notes The patch name sometimes causes confusion - the patches can be used in both Exadata and non-Exadata systems. " this sr took really a long time and came to the wrong conclusion focussing on the workaround which was manually deinstall GI OJVM patch and re-apply the ovm on DB home. After closure we had a meeting with oracle support manager and they think that indeed the issue with the xml file which i pointed out from the beginning ;-)

Wednesday, May 11, 2016

installing em13c : errors not captured ....

I installed Em 13c last week on Redhat 7.2 the installation was on a vmware vm at the customer that was given to me without explanation. After going through the prereqs and installing missing packages I started the installation of this "temporary" setup. what is OEL so much easier .... Everything went fine up to the configuration of Bi publisher that step failed miserably. Log files showed that the oms which is stopped before didn't come up. digging a bit deeper showed following in the logs :


2016-05-06 17:08:31,778 INFO  [75] oracle.sysman.oii.oiix.OiixSpawner$StreamReader - (if [ "compile" = "compile" ] ; then \
  /u01/app/oem/middelware/bin/gennttab > ntcontab.c ;\
  gcc -m64  -fPIC -c ntcontab.c ;\
  rm -f /u01/app/oem/middelware/lib/ntcontab.o ;\
  mv ntcontab.o /u01/app/oem/middelware/lib/ ;\
          /usr/bin/ar rv /u01/app/oem/middelware/lib/libn11.a /u01/app/oem/middelware/lib/ntcontab.o ; fi)
 
2016-05-06 17:08:32,093 INFO  [76] oracle.sysman.oii.oiix.OiixSpawner$StreamReader - gcc: error trying to exec 'as': execvp: Permission denied
 
2016-05-06 17:08:32,095 INFO  [76] oracle.sysman.oii.oiix.OiixSpawner$StreamReader - mv: cannot stat ‘ntcontab.o’: No such file or directory
 
2016-05-06 17:08:32,102 INFO  [76] oracle.sysman.oii.oiix.OiixSpawner$StreamReader - /usr/bin/ar: /u01/app/oem/middelware/lib/ntcontab.o: No such file or directory
 
2016-05-06 17:08:32,102 INFO  [76] oracle.sysman.oii.oiix.OiixSpawner$StreamReader - make: *** [ntcontab.o] Error 1
 
2016-05-06 17:08:32,103 INFO  [64] oracle.sysman.oii.oiix.OiixSpawner - End output from spawned process.
2016-05-06 17:08:32,103 INFO  [64] oracle.sysman.oii.oiix.OiixSpawner - ----------------------------------
2016-05-06 17:08:32,103 INFO  [64] oracle.sysman.oii.oiis.OiisCompActions - Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'mkldflags ntcontab.o nnfgt.o' of makefile '/u01/app/oem/middelware/network/lib/ins_net_client.mk'. See '/u01/stage/em/disks/OraInstall2016-05-06_04-01-07PM/install2016-05-06_04-01-07PM.log' for details.
Exception Severity: 1
2016-05-06 17:08:32,103 INFO  [64] oracle.sysman.oii.oiic.OiicAPISessionInterfaceManager - Retry Handler not registered, using Super class functionality
2016-05-06 17:08:32,104 OFF   [64] oracle.sysman.oii.oiio.oiiol.OiiolTextLogger - Error in invoking target 'mkldflags ntcontab.o nnfgt.o' of makefile '/u01/app/oem/middelware/network/lib/ins_net_client.mk'. See '/u01/stage/em/disks/OraInstall2016-05-06_04-01-07PM/install2016-05-06_04-01-07PM.log' for details.
2016-05-06 17:08:32,104 INFO  [64] oracle.sysman.oii.oiis.OiisCompActions - Calling Action unixActions10.2.0.3.0  make  registerOnly = false    installMakePath = /usr/bin/make installMakeFileName = /u01/app/oem/middelware/rdbms/lib/ins_rdbms.mk    installTarget = client_sharedlib        undoMakeFileName =      installArguments = ORACLE_HOME=/u01/app/oem/middelware  logFile = /u01/app/oem/middelware/install/make.log      undoTarget =    progMsg = Building Client Shared Libraries
2016-05-06 17:08:32,105 INFO  [64] oracle.sysman.oii.oiio.oiiol.OiiolTextLogger - The output of this make operation is also available at: '/u01/app/oem/middelware/install/make.log'
2016-05-06 17:08:32,106 INFO  [64] oracle.sysman.oii.oiix.OiixSpawner - Start output from spawned process:
2016-05-06 17:08:32,106 INFO  [64] oracle.sysman.oii.oiix.OiixSpawner - ----------------------------------
2016-05-06 17:08:32,114 INFO  [77] oracle.sysman.oii.oiix.OiixSpawner$StreamReader - /u01/app/oem/middelware/bin/genclntsh
 
2016-05-06 17:08:32,159 INFO  [78] oracle.sysman.oii.oiix.OiixSpawner$StreamReader - collect2: fatal error: cannot find 'ld'
compilation terminated.
 
2016-05-06 17:08:32,159 INFO  [78] oracle.sysman.oii.oiix.OiixSpawner$StreamReader - genclntsh: Failed to link libclntsh.so.11.1
 
2016-05-06 17:08:32,159 INFO  [78] oracle.sysman.oii.oiix.OiixSpawner$StreamReader - make: *** [client_sharedlib] Error 1
 
2016-05-06 17:08:32,159 INFO  [64] oracle.sysman.oii.oiix.OiixSpawner - End output from spawned process.
2016-05-06 17:08:32,159 INFO  [64] oracle.sysman.oii.oiix.OiixSpawner - ----------------------------------
2016-05-06 17:08:32,160 INFO  [64] oracle.sysman.oii.oiis.OiisCompActions - Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'client_sharedlib' of makefile '/u01/app/oem/middelware/rdbms/lib/ins_rdbms.mk'. See '/u01/stage/em/disks/OraInstall2016-05-06_04-01-07PM/install2016-05-06_04-01-07PM.log' for details.
Exception Severity: 1
2016-05-06 17:08:32,160 INFO  [64] oracle.sysman.oii.oiic.OiicAPISessionInterfaceManager - Retry Handler not registered, using Super class functionality
2016-05-06 17:08:32,160 OFF   [64] oracle.sysman.oii.oiio.oiiol.OiiolTextLogger - Error in invoking target 'client_sharedlib' of makefile '/u01/app/oem/middelware/rdbms/lib/ins_rdbms.mk'. See '/u01/stage/em/disks/OraInstall2016-05-06_04-01-07PM/install2016-05-06_04-01-07PM.log' for details.
2016-05-06 17:08:32,160 INFO  [64] oracle.sysman.oii.oiis.OiisCompActions - Calling Action unixActions10.2.0.3.0  make  registerOnly = false    installMakePath = /usr/bin/make installMakeFileName = /u01/app/oem/middelware/sqlplus/lib/ins_sqlplus.mk        installTarget = install undoMakeFileName =      installArguments = ORACLE_HOME=/u01/app/oem/middelware  logFile = /u01/app/oem/middelware/install/make.log      undoTarget =    progMsg = Linking SQLPLUS Executables
2016-05-06 17:08:32,161 INFO  [64] oracle.sysman.oii.oiio.oiiol.OiiolTextLogger - The output of this make operation is also available at: '/u01/app/oem/middelware/install/make.log'
2016-05-06 17:08:32,162 INFO  [64] oracle.sysman.oii.oiix.OiixSpawner - Start output from spawned process:
2016-05-06 17:08:32,162 INFO  [64] oracle.sysman.oii.oiix.OiixSpawner - ----------------------------------
2016-05-06 17:08:32,165 INFO  [79] oracle.sysman.oii.oiix.OiixSpawner$StreamReader - mkdir -p /u01/app/oem/middelware/sqlplus/bin
16-05-06 17:08:32,166 INFO  [79] oracle.sysman.oii.oiix.OiixSpawner$StreamReader - cp -f /u01/app/oem/middelware/lib/libsqlplus.so \
        /u01/app/oem/middelware/sqlplus/lib/libsqlplus.so
 
2016-05-06 17:08:32,175 INFO  [79] oracle.sysman.oii.oiix.OiixSpawner$StreamReader - Linking /u01/app/oem/middelware/sqlplus/bin/sqlplus
 
2016-05-06 17:08:32,175 INFO  [79] oracle.sysman.oii.oiix.OiixSpawner$StreamReader - rm -f /u01/app/oem/middelware/sqlplus/bin/sqlplus
 
2016-05-06 17:08:32,176 INFO  [79] oracle.sysman.oii.oiix.OiixSpawner$StreamReader - gcc -o /u01/app/oem/middelware/sqlplus/bin/sqlplus -m64 -L/u01/app/oem/middelware/sqlplus/lib/ -L/u01/app/oem/middelware/lib/ -L/u01/app/oem/middelware/lib/stubs/  /u01/app/oem/middelware/sqlplus/lib/s0afimai.o -lsqlplus -lclntsh  `cat /u01/app/oem/middelware/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oem/middelware/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lclient11 -lnnetd11  -lvsn11 -lcommon11 -lgeneric11 -lmm -lsnls11 -lnls11
2016-05-06 17:08:32,176 INFO  [79] oracle.sysman.oii.oiix.OiixSpawner$StreamReader -  -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/app/oem/middelware/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oem/middelware/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lclient11 -lnnetd11  -lvsn11 -lcommon11 -lgeneric11   -lsnls11 -lnls11  -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lclient11 -lnnetd11  -lvsn11 -l
2016-05-06 17:08:32,176 INFO  [79] oracle.sysman.oii.oiix.OiixSpawner$StreamReader - common11 -lgeneric11 -lsnls11 -lnls11  -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11   `cat /u01/app/oem/middelware/lib/sysliblist` -Wl,-rpath,/u01/app/oem/middelware/lib -lm -lpthread   `cat /u01/app/oem/middelware/lib/sysliblist` -ldl -lm -lpthread  -L/u01/app/oem/middelware/lib
 
2016-05-06 17:08:32,186 INFO  [80] oracle.sysman.oii.oiix.OiixSpawner$StreamReader - collect2: fatal error: cannot find 'ld'
compilation terminated.

So basically ld and ar where not allowed to execute due to some acl .... once fixed as root with


setfacl -m u:oem:rx /usr/bin/ld.bfd
setfacl -m u:oem:rx /usr/bin/as

and I restarted the installation it went on smoothly. the sad point is that this error which happened way before configuring the BI publisher wasn't caught earlier...

Monday, March 7, 2016

kfod corrupt after patching

Short post that hopefully will save you time After patching to QFSDP 2016 jan it looked like dbca wasn't seeing ASM disks any more. Quickly @vanpupi found that it was related to kfod. apparently on a linux system it uses % instead of $ in $ORACLE_HOME/bin/kfod both in GI as in the DB home change the kfod file to following


OHOME=%ORACLE_HOME%

to 


OHOME=$ORACLE_HOME

did the trick good find pieter