oracle linux database installer can't find elfutils-libelf-devel-0.97 pdksh-5.2.14

If you run the validation it's ok

The problem is in the database/stage/cvu/cv/admin/cvu_config
configuration file

You can ignore or set CV_ASSUME_DISTID=
to OEL6 or higher.

make a backup and test before :)

Can ping from Oracle linux to an address but not to a name

In Oracle linux, we assigned 8.8.8.8 as dns, and we could ping 8.8.8.8, but can't ping to www.google.com in example.

We solved assigning the dns we used to assign to our microsoft windows computer.

ORACLE EXP ORA-04063: package body "SYS.DBMS_CUBE_EXP" has errors SOLVED

PROBLEM:
Connected to: Oracle Database 12c Release 12.1.0.1.0 - 64bit Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_CUBE_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_CUBE_EXP"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_CUBE_EXP.schema_info_exp


SOLUTION:
The problem apparently are components incorrectly installed.
I solved in my developer database, if you are going to do it in production Isuggest to investigate a little more.

--BACKUP
create table sys.exppkgact$_backup as select * from sys.exppkgact$;
-- DELETE
delete from sys.exppkgact$ where package = 'DBMS_CUBE_EXP' and schema= 'SYS';

problems IMPDP in Oracle xe 11g FIXED

After exporting from 12c with expd version=11

I imported in 11g xe 64x successfully only after updating files, I think this is not legal, but I did only to try.

UDI-31626: operation generated ORACLE error 31626

ORA-31626: job does not exist

ORA-39086: cannot retrieve job information

ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326

ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551

ORA-06512: at line 11) I had to update i

n the folder C:\oraclexe\app\oracle\product\11.2.0\server\oracore\zoneinfo

all teh files from the same folder from 12c

2) I had to update all the contents from the folder C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\xml from an 11g version too.

the command exec dbms_metadata_util.load_stylesheets; must be successful

Import: Release 11.2.0.2.0 - Production on Thu Jan 28 17:21:11 2016

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

ORA-39006: internal error

ORA-39213: Metadata processing is not available

and the import was successfully

opening hlp files in windows 10 64x WORKING OK

get the winhlp.exe from here
http://www.tenforums.com/general-discussion/16982-cant-read-older-hlp-files-windows-10-a-2.html

then create a cmd like this and run like adm

set crtpth=C:\folderwhereiswinhlp32
takeown /f "%windir%\winhlp32.exe" >nul
icacls "%windir%\winhlp32.exe" /grant *S-1-5-32-544:F >nul
copy /y "%crtpth%\winhlp32.exe" %windir%
icacls "%windir%\winhlp32.exe" /setowner "NT Service\TrustedInstaller" >nul

and hlp can be opened

source (that forum) :)

windows remote desktop can't copy clipboard after configuring correctly

If you can't copy to the remote connections and they are configured correctly this is the solution.
from task manager kill theprocess rdpclip
go to windows system32 folder and open rdpclip
:)

SOLVED: ORACLE REPORTS ora-24323 FUNCTION TABLE

CASE 1  resolved
1. When you call the report the report runtime hangs and show this error.
2. if you copy the function table to the sqlplus and execution using the same parameters, you get disconnected.3. The way we solved the problem, was modifying two times  (adding a null; recompile, adding another null; and recompile)
4. execute from sqlplus and don't get disconnect.
5. execute the report and the error dissapear.

CASE 2 unresolved
1. When you call the report the report runtime hangs and show this error.
2. if you copy the function table to the sqlplus and execution using the same parameters, you DON'T get disconnected.
3. You can recreate the report, or as we do recreate the report in jasper, because we are migrating our reports, from oracle reports 6i.