scratch

 


Documentation:  

RCU is a utility to create the schemas, not administer the schemas once they are installed and working. There can be differences between schemas because of product differences. In general, Oracle Database steps can be followed for a backup and recovery, but caution should be taken if the goal is to also change the network configuration, such as the hostname and/or ip address.

You can backup the database and restore to the new system using standard database options, but the FMW documentation here may help:
The 12.2.1.4 documentation can be found here,

Administering Oracle Fusion Middleware (12.2.1.4)
15 Changing Oracle Fusion Middleware Network Configurations
https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/asadm/changing-network-configurations.html#GUID-EA5612E8-A1E8-4022-821E-44C15559914D


tnsnames.ora: 
kiaprod,krpdb =
 (DESCRIPTION=
   (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)
   (ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=s-kiadb.stat-inst.se)(PORT=1521)))
   (CONNECT_DATA=(SERVICE_NAME=kiaprod))
 )

KIAPROD3 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = sishk-krpdb2.stat-inst.se)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = kiaprod3)
    )
  ) 

sqlnet.ora(to work from 19c to 12C):

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

# SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.ALLOWED_LOGON_VERSION_SERVER=11
SQLNET.AUTHENTICATION_SERVICES = (None)
 

Kommentarer

Populære opslag fra denne blog

Alfa, opgradering 2024

Alfa: Debugging 3

Alfa: Forms & Reports Update - Patch 17882900