Skip to main content

FMW - Repository Creation Utility (RCU) schemas - Oracle Forms

English Version


Este post e sobre a criacao do repositorio pra produtos Oracle Fusion Middleware, usando o utilitario Repository Creation Utility (RCU), em linha de comando - silent mode - esta abordagem pode ser usada pa automacao.


Criar Var c/ informacao de ligacao a DB

Neste caso ja tenho uma base de dados, Vendor Oracle, Versao Oracle 12c

[weblogic@wls1 bin]$ export MWDB=wls1.mydomain:1521/ORCL

Ficheiro com passwords

primeira linha SYS user, o resto para cada uma das componetenes Oracle Fusion Middleware.
Um destes dias publico pro SOA/OSB .. hoje fico me apenas pelas necessarias para Oracle Forms

[weblogic@wls1 bin]$ echo "oracle
componentSTB1
componentPSS1
componentIAU1
componentIAU1
componentIAU1"> $ORACLE_HOME/fusion.passwords

[weblogic@wls1 bin]$ cat $ORACLE_HOME/fusion.passwords
oracle
componentSTB1
componentPSS1
componentIAU1
componentIAU1
componentIAU1

Executar o RCU em silent mode
Vou necessitar da ligacao a DB connectionstring, dai ter colocado o URL numa variavel, o prefixo para os database schemas
e o ficheiro com as passwords.
[weblogic@wls1 bin]$ cd $ORACLE_HOME/oracle_common/bin

[weblogic@wls1 bin]$ ./rcu -silent -createRepository -connectString $MWDB \
-dbUser sys -dbRole sysdba -lockSchemas false -schemaPrefix RA \
-component STB -component OPSS -component IAU -component IAU_APPEND -component IAU_VIEWER < $ORACLE_HOME/fusion.passwords

RCU Logfile: /tmp/RCU2018-12-14_19-16_144421421/logs/rcu.log

Enter the database password(User:sys):

Processing command line ....
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites
The selected Oracle database is not configured to use the AL32UTF8 character set.
Oracle strongly recommends using the AL32UTF8 character set for databases that support Oracle Fusion Middleware.

Enter the schema password for [RA_STB]:
Enter the schema password for [RA_OPSS]:
Enter the schema password for [RA_IAU]:
Enter the schema password for [RA_IAU_APPEND]:
Enter the schema password for [RA_IAU_VIEWER]:

Repository Creation Utility - Checking Prerequisites
Checking Component Prerequisites
Repository Creation Utility - Creating Tablespaces
Validating and Creating Tablespaces
Repository Creation Utility - Create
Repository Create in progress.
Percent Complete: 25
Percent Complete: 25
Percent Complete: 27
Percent Complete: 29
Percent Complete: 31
Percent Complete: 31
Percent Complete: 31
Percent Complete: 42
Percent Complete: 42
Percent Complete: 54
Percent Complete: 54
Percent Complete: 54
Percent Complete: 63
Percent Complete: 63
Percent Complete: 75
Percent Complete: 75
Percent Complete: 75
Percent Complete: 84
Percent Complete: 84
Percent Complete: 89
Percent Complete: 89
Percent Complete: 100
Repository Creation Utility: Create - Completion Summary

Database details:
-----------------------------
Host Name : wls1.mydomain
Port : 1521
Service Name : MW_PDB.MYDOMAIN
Connected As : sys
Prefix for (prefixable) Schema Owners : RA
RCU Logfile : /tmp/RCU2018-12-14_19-16_144421421/logs/rcu.log

Component schemas created:
-----------------------------
Component Status Logfile
Common Infrastructure Services Success /tmp/RCU2018-12-14_19-16_144421421/logs/stb.log
Oracle Platform Security Services Success /tmp/RCU2018-12-14_19-16_144421421/logs/opss.log
Audit Services Success /tmp/RCU2018-12-14_19-16_144421421/logs/iau.log
Audit Services Append Success /tmp/RCU2018-12-14_19-16_144421421/logs/iau_append.log
Audit Services Viewer Success /tmp/RCU2018-12-14_19-16_144421421/logs/iau_viewer.log

Repository Creation Utility - Create : Operation Completed

Referencias e Mais Info

RCU | FORMS

Obrigado pela leitura, espero que este post o tenha ajudado.
Rogerio

Labels:

Comments

Post a Comment

Popular posts from this blog

DB - How to monitor Oracle datapump jobs

These days there is lot of work around database migrations not only but mainly to cloud providers. One of the ways to migrate Oracle databases is using data pump (expdp/impdp). In general works fine, it allows an easy way to bring the database even different OS. It is always good to monitor the progress, to know where we are and estimate how long we are from the end. In this post, I am sharing some queries to help with database monitoring progress. The queries can be easily tailed to various scenarios. Starting with a simple one - the track the number of objects loaded during an import operation. When there is a massive amount of errors during the import. Drop and run the import again. The bellow query can be useful also to monitor the number of objects if we are dropping the users. Here, I’m making the assumption there were no other database activity in progress on the last 24 hours. select owner, count(0) from dba_objects where owner in ( select username from dba_users where created...
Post a Comment
Read more

VM - Partilhar Pastas Windows - Linux

Neste post escrevo como partilhar pastas entre Windows (Host) e uma VM Guest, neste caso Linux. Ha algumas formas de fazer isto, esta parece me a mais facil. Seleccionar a Pasta Windows Na consola Virtual Box > Devices > Shared Folder Seleccionar a pasta windows para partilhar no Linux   O   Montar a pasta Windows na VM Ha duas opcoes : 1) Reiniciar a VM (Auto-mount) 2) Linha de comando [root@host ~]# mkdir -p /u01/stage/win_ebs_sw [root@host ~]# chmod 777 /u01/stage/win_ebs_sw [root@host ~]# mount -t vboxsf Oracle_EBS /u01/stage/win_ebs_sw/ [root@host ~]# ls /u01/stage/win_ebs_sw ebs_weblogic_webtier [root@host ~]# df -h /u01/stage/win_ebs_sw Filesystem Size Used Avail Use% Mounted on Oracle_EBS 895G 494G 401G 56% /u01/stage/win_ebs_sw Guardar a Configuracao no /etc/fstab para tornar as alteracoes permanentes. [root@host ~]# echo "Oracle_EBS /u01/stage/win_ebs_sw vboxsf defaults 0 0" >> /etc/fstab [root@host ~]# cat /etc/fstab # /etc/...
Post a Comment
Read more

DB – How to monitor Oracle database long ops ?

As DBAs, some questions we are often asked and to be fair we ask ourselfs when we are doing massive operations, are : Is the database doing something? How long the database takes to complete the task? There a data dictionary view, GV$SESSION_LONGOPS whom is really usefull for monitoring and to provide estimated time to get the task done. Starting with a first example, a query for general propose . set lines 240 col message form a100 col opname form a50 select * from ( select round(l.sofar/l.totalwork*100,2) as complete, --l.* l.sid, --l.opname, l.message, l.start_time, l.time_remaining/60 "minuts remaining", l.elapsed_seconds from gv$session_longops l where totalwork !=0 ) where complete < 100; The view is also usefull on specific operations such as Oracle Recovery Manager (RMAN) jobs monitoring, this query returns information about backup,restore and recovery. select sid, serial#,opname, context, sofar, totalwork, round(sofar/totalwork*100,2) "%_complet...
Post a Comment
Read more