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"