Recriar arquivo DBC no $FND_TOP/secure

Perguntas relacionadas a questões técnicas do Oracle EBS. Criação de Concorrentes, Value Sets, Alerts, Forms Personalizations, Configurações, etc
Responder
Avatar do usuário
dr_gori
Moderador
Moderador
Mensagens: 5024
Registrado em: Seg, 03 Mai 2004 3:08 pm
Localização: Portland, OR USA
Contato:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

Afim de criar (ou recriar) o arquivo DBC no diret[orio $FND_TOP/secure, basta executar o comando abaixo:

Eu utilizei o usuário APPLMGR:

Selecionar tudo

java oracle.apps.fnd.security.AdminAppServer apps/apps ADD FNDNAM=APPS GWYUID=applsyspub/pub TWO_TASK=VIS SECURE_PATH=$FND_TOP/secure GUEST_USER_PWD=guest/oracle APPS_JDBC_DRIVER_TYPE=THIN DB_HOST=192.168.10.192 DB_PORT=1521
'

Lembrando que você precisa alterar
  • A senha (no meu caso apps/apps)
  • Senhas padrão para APPLSYSPUB e GUEST
  • TWO_TASK .
  • DB_HOST, DB_HOST
Também tem alguns parâmetros que são opcionais que devem ser editados manualmente.
Abaixo vou deixar o template:

Selecionar tudo

# $Header: template.dbc 120.0 2005/05/07 16:45:30 appldev ship $
# TEMPLATE.dbc
#   Template database configuration file.
#
#   Create one copy of this file for each database instance this
#   Applications Server will connect to.  Each file should have the name
#       <database_instance_name>.dbc
#   and be located in this directory ($FND_TOP/secure).
#   Change each of the parameters below to values appropriate for
#   the database instance.  Do not change the syntax.
#
#   This file can be gererated using the AdminAppServer tool.
#   This is a java utility that can be run from the command line.
#   Instructions to use this tool are documented in the Applications
#   Sysadmin Manual.

#
# TWO_TASK
#   SQL*Net name of database.
#
TWO_TASK=database

#
# FNDNAM
#   Oracle User to be used for Oracle Applications connection.
#   The FNDNAM Oracle User must have Oracle Applications privilege level
#   'Universal'.
#
FNDNAM=APPS

#
# GWYUID
#   Oracle User/Password of the public account to be used for initial
#   Oracle Applications connection.
#   The GWYUID Oracle User must have Oracle Applications privilege level
#   'Public'.
#
GWYUID=APPLSYSPUB/PUB

#
# GUEST_USER_PWD
#   Applications User/Password of the Guest user.
#   The Guest Applications User is a public Applications user
#   with no responsibilities assigned.  If no such user exists,
#   create one in the 'Define User' form.  Do not use a user with
#   any active responsibilities. Note: This parameter is for
#   an applications user NOT an Oracle user. The Guest user
#   is seeded with 11i.

GUEST_USER_PWD=GUEST/GUEST

# THE FOLLOWING PARAMETERS ARE RELEVANT ONLY
# IF JDBC IS BEING USED. IF THEY ARE NOT SUPPLIED, DEFAULTS
# WILL BE USED.

# APPS_JDBC_DRIVER_TYPE
#   The type of JDBC driver being used. If no value is supplied,
#   the thick (OCI) driver will be used. Give a value of THIN
#   or THICK depending on the type of JDBC driver to be used.
#   For a detailed discussion on the THIN vs the THICK driver,
#   refer to the JDBC documentation. For Release 11i , this
#   should be set to a value of THIN.


APPS_JDBC_DRIVER_TYPE=THIN

# DB_HOST
#   The host machine on which the database resides. This parameter
#   is required only if the THIN DRIVER is being used.

DB_HOST=host_name

# DB_PORT
#   The port of the host machine on which the database resides.
#   This is required only if the THIN driver is being used.

DB_PORT=port_number

# DB_NAME
# Database instance name.
# This is required only if the THIN driver is being used.
# If no value is provided, the TWO_TASK is used.

# DB_NAME=db_name

:-o
Avatar do usuário
dr_gori
Moderador
Moderador
Mensagens: 5024
Registrado em: Seg, 03 Mai 2004 3:08 pm
Localização: Portland, OR USA
Contato:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

Fica para registro
Responder
  • Informação
  • Quem está online

    Usuários navegando neste fórum: Nenhum usuário registrado e 7 visitantes