Windows 10 October 2018 update, avoid delete file problem: free space and disable Storage Sense

Windows 10 October 2018 update, avoid delete file problem: free space and disable Storage Sense

https://www.forbes.com/sites/kevinmurnane/2018/09/23/installing-windows-10s-october-update-could-result-in-a-nightmare-heres-how-to-avoid-it/#5b4729da512e

windows 10 To prevent apps from being reopened use the shutdown.exe command-line.

shutdown 

shutdown.exe /s /t 0

restart

shutdown.exe /r /t 0

How to enable Group Policy on windows 10 Home edition

https://www.askvg.com/how-to-enable-group-policy-editor-gpedit-msc-in-windows-7-home-premium-home-basic-and-starter-editions/

ORA-12638: Credential retrieval failed SOLVED SQLNET.ORA

IN SQLNET.ORA change SQLNET.AUTHENTICATION_SERVICES

SQLNET.AUTHENTICATION_SERVICES=(NONE)
#SQLNET.AUTHENTICATION_SERVICES=(NTS)

sql developer 00604 12705 solved No se puede acceder a los archivos de datos NLS

Se ha producido un error al realizar la operación solicitada:

ORA-00604: se ha producido un error a nivel 1 de SQL recursivo
ORA-12705: No se puede acceder a los archivos de datos NLS o se ha especificado un entorno no válido
00604. 00000 -  "error occurred at recursive SQL level %s"
*Cause:    An error occurred while processing a recursive SQL statement
           (a statement applying to internal dictionary tables).
*Action:   If the situation described in the next error on the stack
           can be corrected, do so; otherwise contact Oracle Support.
Código de proveedor 604

sqldeveloper\sqldeveloper\bin\sqldeveloper.conf

add lines
AddVMOption  -Duser.region=us
AddVMOption  -Duser.language=en

How to genera from excel with semicolon instead in coma in csv files

In windows in regional settings put (;) instead of (,)

ORA-38802: ORA-02063: Edition doesn't exists, having only one edition through database link

I only have one edition

select * from dba_editions;
ORA$BASE          YES

It is the default edition

SELECT property_value
FROM   database_properties
WHERE  property_name = 'DEFAULT_EDITION';

ORA$BASE

making a select through a database link

select * from dual@database_with_problem.world 

I starting to get the error: 

ORA-38802: Edition does not exists

ORA-02063: 

I executed the command:

ALTER DATABASE DEFAULT EDITION = ORA$BASE;

And it get solved, magically.

After renaming database ORA-00604: error occurred at recursive SQL level 2

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-25153: Temporary Tablespace is Empty

You have to disable database triggers, before renaming, or after recreating the database.

SHUTDOWN IMMEDIATE
 STARTUP UPGRADE ;

SELECT 'ALTER TRIGGER '||OWNER||'.'||TRIGGER_NAME||' DISABLE;' FROM DBA_TRIGGERS WHERE base_object_type LIKE '%DATABASE%';

ORA-12224 connection forms 6i with oracle database 12c

used ip insteaad of name and it got fixed, why?
No idea.

BBBV_3_17.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jreyes)(PORT=1522))(CONNECT_DATA=(SID=BBBV)))
BBBV_3_17.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.3.17)(PORT=1522))(CONNECT_DATA=(SID=BBBV)))

upgrading 12.2 preupgrade.jar ORA-01017

SET ORACLE_SID=BBBV
SET ORACLE_BASE=c:\app\jreyes
SET ORACLE_HOME=C:\app\jreyes\product\12.1.0.1.13\dbhome_1

C:\app\jreyes\product\11.2.0\dbhome_1\jdk\bin\java -jar C:\app\product\12.2.0\dbhome_1\rdbms\admin\preupgrade.jar FILE TEXT DIR D:\TEMPD

ERROR - Unable to run sqlplus due to:
ORA-01017:
SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus


Solution:
I ran
C:\app\product\12.2.0\dbhome_1\bin\launch.exe c:\app\product\12.2.0\dbhome_1\bin dbua.cl
and I run from the wizard the preupgrade check and it worked.

GLOBAL_NAMES Domain is not going away (forcing a change)

I didn't found solution so I fixed in this way:

db_domain is null
a domain is added and can't be set to null

select * from global_name;

ABVP.WORLD

The domain always stays

alter database RENAME global_name TO XXX;

xxx.world

Changing domain the domain stays again

alter database RENAME global_name TO XXX.com.bo;

select * from global_name;
XXX.com.bo

alter database RENAME global_name TO abvp;

 select * from global_name;

abvp.com.bo

Chaging directly in the sys table, and rexecuting change to get a correct change in the database dictionary:

UPDATE SYS.props$ SET value$='ABVP' WHERE name='GLOBAL_DB_NAME';

  select * from global_name; --ABVP

COMMIT;
  select * from global_name; --ABVP
alter database RENAME global_name TO XXX;  select * from global_name; --XXX
alter database RENAME global_name TO ABVP;
  select * from global_name; --ABVP

Metalink note to Install and Configure Oracle Forms & Reports 12cR2 with OHS 12cR2

How to Install and Configure Oracle Forms & Reports 12cR2 with OHS 12cR2 Using a Single Domain (Doc ID 2127048.1)

datapatch perl.exe stopped working SOLVED

set oracle_sid variable


set oracle_home=C:\app\product\12.2.0\dbhome_1
set path=C:\app\product\12.2.0\dbhome_1\perl\bin;C:\app\product\12.2.0\dbhome_1\bin;%path%
SET ORACLE_SID=RFOR

C:
cd %ORACLE_HOME%\BIN
sqlplus /nolog
CONNECT SYS/password@RFOR AS SYSDBA
set heading off
select bundle_series from registry$history order by action_time desc;

SHUTDOWN IMMEDIATE
STARTUP upgrade
quit

cd %ORACLE_HOME%\OPatch
datapatch -verbose

SYS
password
-------output

Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of SQL patches:
Patch 26182467 (26182467:WINDOWS ORACLE JAVAVM COMPONENT BUNDLE PATCH 12.2.0.1.170718):
  Installed in the binary registry only
Bundle series PSU:
  ID 170718 in the binary registry and not installed in the SQL registry

Adding patches to installation queue and performing prereq checks...
Installation queue:
  Nothing to roll back
  The following patches will be applied:
    26182467 (26182467:WINDOWS ORACLE JAVAVM COMPONENT BUNDLE PATCH 12.2.0.1.170718)
    26204212 (WINDOWS DB BUNDLE PATCH 12.2.0.1.170718(64bit):26204212)

Installing patches...

Solved: Windows O/S-Error: (OS 5) Access is denied caused by service Log On account

ORA-00221: error on write to control file
ORA-00206: error in writing (block 1, # blocks 1) of control file
ORA-00202: control file:
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

The problem was in service properties
"Logon as" was not with "Local System Account"

SOLVED oracle.forms.webutil bean xxx not found when calling in startup trigger

You can't make a call to webutil functions on  PRE-FORM, WHEN-NEW-FORM-INSTANCE, because WebUtil PJCs is not loaded.

But you can use call a non repeteable timer, that calls the code that triggers calls.

You can test the initial time, and a variable to verify if the startup trigger were executed, to avoid some triggers to be executed before the wnfi trigger is fired.

To avoid any interaction of the form with the user,
1) the form can start minimized (without the option to restore and maximize) and restored by code only when the wnfi trigger ends.
2) the items can start disabled and become enabled when the timer startup triggers ends

CREATE_TIMER

ORA-00959: tablespace '_$deleted$' does not exist

ORA-00959: tablespace '_$deleted$' does not exist

I found after renaming the database, the users didn't had specified the temporal tablespaces, I assigned and it solved.

The test is execute sys.utl_recomp.recomp_serial();
gave the error

The free feature for Oracle to create materialized views in all release, how to update a materialized view from a trigger

It's called a package

First we have the select, of one or more tables; and the table to store it
Second we create a procedure that insert the query in a table
Third we update it
 1) if we want a transactional update, we create a procedure that inserts the values for the new records in the trigger of the tables
 2) if we want a log fast refresh, we create a log that stores id of records we want to be updated
 3) if we want a full update, we create job
Fourth
 For the update process depending the option we have to create a procedure, add to the trigger/job and that all.
Fifth
 Aditionally we have a validation procedure that periodically if he found differences can generate a full or partial refresh.


First
Create a package
XXX.PCK_MV_OWNER_TABLE
 Procedure:FullRefresh
  insert into table
  select from tableA,tableB
  -- note in this refresh you can put
 
 Procedure:PartialRefreshperTrigger
  This must be in a trigger update and or delete
   insert into table
   select from tableA,tableB
    where column=:new.value and column2=:new.value2

 Procedure:PartialRefreshperFunction
   insert into table
   select from tableA,tableB
     where not exists in table

 Procedure:PartialRefreshperFunction using log
  This requires a table that stores ids of modified rows, and a trigger that inserts the rowid when the needed columns of the table are modified, and generates a refresh only of those records in the database.
   insert into table
   select from tableA,tableB
     where not exists in table
   
 Procedure:fast refresh fast
  delete from;
  FullRefresh; 

 Procedure:fast refresh online
  truncate table;
  FullRefresh; 

 Procedure:validation
  with  
    a select from tableA,tableB
    b select fro mtable
  select count(*) from   
  (select from a
   minus
  select from b
  union all
  select from b
   minus
  select from a)
  if count>0 then
   fullrefresh; -fast or online it dependes on you
  end if;
 /
 Jobs
 create job executes validation periodically, depending the tables, etc.
 create job if using log to update the materialized view periodically
 optionally, create jobs makes partial insert, to reinforce validation.
 optionally, makes a full refresh

:)

can't see dialogs when installing 11.2. on oracle linux 7

The reason is the support is from 11.2.0.4

Where can I download 12.1.0.1 database release for linux 64x

in edelivery
http://www.dbajunior.com/download-oracle-12c-software/

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 :)