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