Invalid APPS password

classic Classic list List threaded Threaded
12 messages Options
Reply | Threaded
Open this post in threaded view
|

Invalid APPS password

karthikmca.bhc
Hi Support,

I recently upgraded my 12.2.7 EBS database to 19c. Upgrade was successful. when i connect to apps schema as oracle user im getting below error. The same when iam trying as applmgr user the apps schema connects with its password. Please provide fix for this issue.

[root@demo rman_backup]# su - applmgr
[applmgr@1227demo ~]$ sqlplus apps/apps
SQL*Plus: Release 10.1.0.5.0 - Production on Wed Sep 9 18:36:13 2020
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
SQL>exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

[applmgr@demo ~]$ sqlplus apps/APPS
SQL*Plus: Release 10.1.0.5.0 - Production on Wed Sep 9 18:36:26 2020
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
SQL>exit


[root@demo ]# su - oracle

[oracle@demo ~]$
[oracle@demo ~]$
[oracle@demo ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 9 18:45:04 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> alter session set container=CDB$ROOT;
Session altered.

SQL> set lines 200 pages 200
col NAME format a20
SQL> select con_id,name,open_mode from v$containers;

    CON_ID NAME                 OPEN_MODE
---------- -------------------- ----------
         1 CDB$ROOT             READ WRITE
         2 PDB$SEED             READ ONLY
         3 R1227                   READ WRITE

SQL> select username,account_status from dba_users where username in('APPS','APPLSYS','APPLSYSPUB');
no rows selected

SQL> alter session set container=R1227;
Session altered.

SQL> select username,account_status from dba_users where username in('APPS','APPLSYS','APPLSYSPUB');

USERNAME        ACCOUNT_STATUS
------------- ---------------
APPLSYSPUB      OPEN
APPS                 OPEN
APPLSYS            OPEN        
                                                                                                                 
SQL> conn apps/apps
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.

SQL> conn / as sysdba
Connected.

SQL> conn apps/APPS
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL>

[oracle@1227demo ~]$ sqlplus apps/apps
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 9 18:54:06 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:

[oracle@1227demo ~]$ sqlplus apps/APPS
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 9 18:54:20 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:


Please provide workaround/fix.

Thanks,
Karthik
Reply | Threaded
Open this post in threaded view
|

Re: Invalid APPS password

karthikmca.bhc
due to the apps password issue im not able to run the below on the cloned instance.

[oracle@1227demostby ~]$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/u01/oracle/db/tech_st/19.3.0.0/appsutil/testpdb_1227demostby.xml -oraclehome=/u01/oracle/db/tech_st/19.3.0.0 -outdir=/u01/oracle/db/tech_st/19.3.0.0/appsutil/log -mode=getUtlFileDir
Enter the APPS Password:

Script Name    : txkCfgUtlfileDir.pl
Script Version : 120.0.12020000.11
Started        : Wed Sep  9 18:17:48 +04 2020

Log File       : /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_UTIL_DIR_Wed_Sep_9_18_17_44_2020/txkCfgUtlfileDir.log

Context file: /u01/oracle/db/tech_st/19.3.0.0/appsutil/testpdb_1227demostby.xml exists.

Completed        : Wed Sep  9 18:17:50 +04 2020

ERROR DESCRIPTION:
(*******FATAL ERROR*******
PROGRAM : (/u01/oracle/db/tech_st/19.3.0.0/appsutil/bin/txkCfgUtlfileDir.pl)
TIME    : Wed Sep  9 18:17:50 2020
FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ]
ERRORMSG: Invalid APPS database user credentials.
)
ERRORCODE = 1 ERRORCODE_END
[oracle@1227demostby ~]$
Reply | Threaded
Open this post in threaded view
|

Re: Invalid APPS password

karthikmca.bhc
[oracle@1227demostby ~]$ vi /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_UTIL_DIR_Wed_Sep_9_18_17_55_2020/validate_apps_password.log

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 9 18:17:57 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Warning: You are no longer connected to ORACLE.
~

[oracle@1227demostby ~]$ vi /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_UTIL_DIR_Wed_Sep_9_18_17_55_2020/txkCfgUtlfileDir.log
==========================


Executing the SQL...

Removing the file: /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_UTIL_DIR_Wed_Sep_9_18_17_55_2020/validate_apps_password.sql

==============================
Inside searchFileContents()...
==============================

log_file: /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_UTIL_DIR_Wed_Sep_9_18_17_55_2020/validate_apps_password.log
pattern: ERROR
================
Pattern found...
================
EXIT STATUS: 1
Invalid APPS database user credentials.
LOG FILE: /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_UTIL_DIR_Wed_Sep_9_18_17_55_2020/validate_apps_password.log.
*******FATAL ERROR*******
PROGRAM : (/u01/oracle/db/tech_st/19.3.0.0/appsutil/bin/txkCfgUtlfileDir.pl)
TIME    : Wed Sep  9 18:17:58 2020
FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ]
ERRORMSG: Invalid APPS database user credentials.

Completed        : Wed Sep  9 18:17:58 +04 2020

ERROR DESCRIPTION:
(*******FATAL ERROR*******
PROGRAM : (/u01/oracle/db/tech_st/19.3.0.0/appsutil/bin/txkCfgUtlfileDir.pl)
TIME    : Wed Sep  9 18:17:58 2020
FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ]
ERRORMSG: Invalid APPS database user credentials.
)

ERRORCODE = 1 ERRORCODE_END

                                                                     
Reply | Threaded
Open this post in threaded view
|

Re: Invalid APPS password

ErmanArslansOracleBlog
Administrator
probably a parameter mismatch. Maybe a tns problem as well.(we have ORA-12514 in validation) Did you compare the tnsnames of apps tier and db tier? Because it seems you can connect from apps tier without any problems..

Ref: 19c Database with Oracle E-Business Suite R12 Known Issues & Solutions (Doc ID 2662860.1)

Also , what is the value of database parameter instance_name?  Is it set to CDB or PDB name?
Reply | Threaded
Open this post in threaded view
|

Re: Invalid APPS password

karthikmca.bhc
Please review my current tns setup and pls advice me for fixing this issue. Due to this issue the adpreclone.pl in dbtier runs win invalid APPS password and when i try to perform clone in target that fails with invalid APPS password. We need to fix this apps issue in dbtier so that in target the clone doesnt fail with this invalid password issue.

[oracle@demo ~]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=/u01/oracle/db/tech_st/19.3.0.0
export ORACLE_SID=r1227cdb
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$ORACLE_HOME/OPatch:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PERL5LIB=$ORACLE_HOME/perl/lib/5.14.1:$ORACLE_HOME/perl/lib/site_perl/5.14.1
export ORA_NLS10=$ORACLE_HOME/nls/data/9idata
. /u01/oracle/db/tech_st/19.3.0.0/r1227cdb_demo.env
export LOG_HOME=/u01/oracle/diag/rdbms/r1227cdb/r1227cdb/trace
alias sysdba='sqlplus "/ as sysdba"'

[oracle@demo ~]$ echo $ORACLE_SID
r1227cdb
[oracle@demo ~]$ cd $ORACLE_HOME
[oracle@demo 19.3.0.0]$ ls -ltrh *.env
-rw-r--r-- 1 oracle oinstall 2.1K Aug 30 19:46 r1227cdb_demo.env    ---> cdb env file
-rw-r--r-- 1 oracle oinstall 4.9K Sep 10 00:19 R1227_demo.env        ---> pdb env file
[oracle@demo 19.3.0.0]$
[oracle@demo 19.3.0.0]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 10 12:46:08 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> show parameter case
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
_pdb_name_case_sensitive             boolean     TRUE
sec_case_sensitive_logon             boolean     FALSE
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

[oracle@demo 19.3.0.0]$ echo $USER
oracle
[oracle@demo 19.3.0.0]$ cd $TNS_ADMIN
[oracle@demo admin]$ ls
listener.ora  R1227_demo  samples  shrept.lst  sqlnet.ora  sqlnet.ora.bkp.org  tnsnames.ora
[oracle@demo admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/oracle/db/tech_st/19.3.0.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
R1227 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = demo.energy-esi-dubai.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = R1227)
    )
  )
##############
# Intermedia
##############
# $Header: tnsnames_ora_cdb_db121.tmp 120.0.12020000.2 2019/05/10 09:09:22 lmanda noship $
#+===========================================================================+
# |  Copyright (c) 2016, 2019 Oracle Corporation, Redwood Shores, California, USA   |
# |                        All rights reserved                                |
# |                       Applications  Division                              |
# +===========================================================================+
#
# $AutoConfig$
#
###########################
# Definition for database
###########################
R1227CDB_REMOTE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = tcp)(HOST = demo.energy-esi-dubai.com)(PORT = 1521))
  )

demo:1521 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = tcp)(HOST = demo.energy-esi-dubai.com)(PORT = 1521))
  )

R1227CDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = tcp)(HOST = demo.energy-esi-dubai.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = r1227cdb)
      (INSTANCE_NAME = r1227cdb)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCr1227cdb))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

[oracle@demo admin]$
[oracle@demo admin]$ su - applmgr
Password:
Last login: Thu Sep 10 00:03:28 +04 2020 on pts/1
  E-Business Suite Environment Information
  ----------------------------------------
  RUN File System           : /u02/applmgr/fs2/EBSapps/appl
  PATCH File System         : /u02/applmgr/fs1/EBSapps/appl
  Non-Editioned File System : /u02/applmgr/fs_ne
  DB Host: demo.energy-esi-dubai.com  Service/SID: R1227
  Sourcing the RUN File System ...

[applmgr@demo ~]$ cd $TNS_ADMIN
[applmgr@demo admin]$ ls
listener.ora  sqlnet_ifile.ora  sqlnet.ora  tnsnames.ora  tnsnames.ora.bak.org
[applmgr@demo admin]$
[applmgr@demo admin]$ cat tnsnames.ora
###############################################################
# Do not edit settings in this file manually. They are managed
# automatically and will be overwritten when AutoConfig runs.
# For more information about AutoConfig, refer to the Oracle
# E-Business Suite Setup Guide.
#$Header: NetServiceHandler.java 120.28.12020000.18 2020/04/09 09:53:55 rdamodar ship $
################################################################

R1227=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=demo.energy-esi-dubai.com)(PORT=1521))
            (CONNECT_DATA=
                (SERVICE_NAME=ebs_R1227)
                (INSTANCE_NAME=r1227cdb)
            )
        )

R1227_FO=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=demo.energy-esi-dubai.com)(PORT=1521))
            (CONNECT_DATA=
                (SERVICE_NAME=ebs_R1227)
                (INSTANCE_NAME=r1227cdb)
            )
        )

R1227_BALANCE=
        (DESCRIPTION=
            (ADDRESS_LIST=
                (LOAD_BALANCE=YES)
                (FAILOVER=YES)
                (ADDRESS=(PROTOCOL=tcp)(HOST=demo.energy-esi-dubai.com)(PORT=1521))
            )
            (CONNECT_DATA=
                (SERVICE_NAME=ebs_R1227)
            )
        )

FNDFS_demo=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=demo.energy-esi-dubai.com)(PORT=1626))
            (CONNECT_DATA=
                (SID=FNDFS)
            )
        )

FNDFS_demo.energy-esi-dubai.com=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=demo.energy-esi-dubai.com)(PORT=1626))
            (CONNECT_DATA=
                (SID=FNDFS)
            )
        )

FNDFS_R1227_demo=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=demo.energy-esi-dubai.com)(PORT=1626))
            (CONNECT_DATA=
                (SID=FNDFS)
            )
        )

FNDFS_R1227_demo.energy-esi-dubai.com=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=demo.energy-esi-dubai.com)(PORT=1626))
            (CONNECT_DATA=
                (SID=FNDFS)
            )
        )


FNDSM_demo_R1227=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=demo.energy-esi-dubai.com)(PORT=1626))
            (CONNECT_DATA=
                (SID=FNDSM)
            )
        )

FNDSM_demo.energy-esi-dubai.com_R1227=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=demo.energy-esi-dubai.com)(PORT=1626))
            (CONNECT_DATA=
                (SID=FNDSM)
            )
        )

FNDFS_APPLTOP_AT_demo=
        (DESCRIPTION=
            (ADDRESS_LIST=
                (ADDRESS=(PROTOCOL=tcp)(HOST=demo.energy-esi-dubai.com)(PORT=1626))
            )
            (CONNECT_DATA=
                (SID=FNDFS)
            )
        )

R1227_patch=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=demo.energy-esi-dubai.com)(PORT=1521))
            (CONNECT_DATA=
                (SERVICE_NAME=R1227_ebs_patch)
                (INSTANCE_NAME=r1227cdb)
            )
        )

R1227_FO_patch=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=demo.energy-esi-dubai.com)(PORT=1521))
            (CONNECT_DATA=
                (SERVICE_NAME=R1227_ebs_patch)
                (INSTANCE_NAME=r1227cdb)
            )
        )

IFILE=/u02/applmgr/fs2/inst/apps/R1227_demo/ora/10.1.2/network/admin/R1227_demo_ifile.ora[applmgr@demo admin]$
[applmgr@demo admin]$

[oracle@demo ~]$ cd  $ORACLE_HOME/dbs
[oracle@demo dbs]$
[oracle@demo dbs]$ grep -i instance_name initr1227cdb.ora
[oracle@demo dbs]$  grep -i db_name initr1227cdb.ora
*._pdb_name_case_sensitive=TRUE
*.db_name='r1227cdb'
[oracle@demo dbs]$ grep -i case initr1227cdb.ora
*._pdb_name_case_sensitive=TRUE
*.sec_case_sensitive_logon=FALSE
[oracle@demo dbs]$

Reply | Threaded
Open this post in threaded view
|

Re: Invalid APPS password

karthikmca.bhc
In reply to this post by ErmanArslansOracleBlog
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> show parameter instance_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
instance_name                        string      r1227cdb
SQL>

SQL> select instance_number, instance_name,host_name,status from v$instance;

INSTANCE_NUMBER INSTANCE_NAME    HOST_NAME                      STATUS
--------------- ---------------- ------------------------------ ------------
              1 r1227cdb         1227demo.energy-esi-dubai.com  OPEN
Reply | Threaded
Open this post in threaded view
|

Re: Invalid APPS password

karthikmca.bhc
sorry the hostname is demo.energy-esi-dubai.com on the problematic instance

SQL> select instance_number, instance_name,host_name,status from v$instance;

INSTANCE_NUMBER INSTANCE_NAME    HOST_NAME                      STATUS
--------------- ---------------- ------------------------------ ------------
              1 r1227cdb                           demo.energy-esi-dubai.com  OPEN


Reply | Threaded
Open this post in threaded view
|

Re: Invalid APPS password

ErmanArslansOracleBlog
Administrator
Send me the lsnrctl status and lsnrctl service output from the db node.
Reply | Threaded
Open this post in threaded view
|

Re: Invalid APPS password

karthikmca.bhc
[oracle@demo dbs]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 10-SEP-2020 14:19:09

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     r1227cdb
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                07-SEP-2020 20:07:51
Uptime                    2 days 18 hr. 11 min. 18 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/oracle/db/tech_st/19.3.0.0/network/admin/listener.ora
Listener Log File         /u01/oracle/db/tech_st/19.3.0.0/log/diag/tnslsnr/demo/r1227cdb/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=demo.energy-esi-dubai.com)(PORT=1521)))
Services Summary...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
  Instance "r1227cdb", status READY, has 1 handler(s) for this service...
Service "R1227_ebs_patch" has 1 instance(s).
  Instance "r1227cdb", status READY, has 1 handler(s) for this service...
Service "ebs_R1227" has 1 instance(s).
  Instance "r1227cdb", status READY, has 1 handler(s) for this service...
Service "f9b287895d4855cde0438758d20adc41" has 1 instance(s).
  Instance "r1227cdb", status READY, has 1 handler(s) for this service...
Service "r1227" has 1 instance(s).
  Instance "r1227cdb", status READY, has 1 handler(s) for this service...
Service "r1227cdb" has 1 instance(s).
  Instance "r1227cdb", status READY, has 1 handler(s) for this service...
Service "r1227cdbXDB" has 1 instance(s).
  Instance "r1227cdb", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@demo dbs]$

[oracle@demo dbs]$ lsnrctl service

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 10-SEP-2020 14:19:27

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
  Instance "r1227cdb", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:274 refused:0 state:ready
         LOCAL SERVER
Service "R1227_ebs_patch" has 1 instance(s).
  Instance "r1227cdb", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:274 refused:0 state:ready
         LOCAL SERVER
Service "ebs_R1227" has 1 instance(s).
  Instance "r1227cdb", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:274 refused:0 state:ready
         LOCAL SERVER
Service "f9b287895d4855cde0438758d20adc41" has 1 instance(s).
  Instance "r1227cdb", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:274 refused:0 state:ready
         LOCAL SERVER
Service "r1227" has 1 instance(s).
  Instance "r1227cdb", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:274 refused:0 state:ready
         LOCAL SERVER
Service "r1227cdb" has 1 instance(s).
  Instance "r1227cdb", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:274 refused:0 state:ready
         LOCAL SERVER
Service "r1227cdbXDB" has 1 instance(s).
  Instance "r1227cdb", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: demo.energy-esi-dubai.com, pid: 28102>
         (ADDRESS=(PROTOCOL=tcp)(HOST=demo.energy-esi-dubai.com)(PORT=18724))
The command completed successfully
Reply | Threaded
Open this post in threaded view
|

Re: Invalid APPS password

karthikmca.bhc
SQL> Select name from v$active_services;

NAME
----------------------------------------------------------------
r1227cdbXDB
r1227
ebs_R1227
SYS$BACKGROUND
SYS$USERS
R1227_ebs_patch
r1227cdb

7 rows selected.

Reply | Threaded
Open this post in threaded view
|

Re: Invalid APPS password

karthikmca.bhc
Hi Erman,

 resolved this issue by initiating clone again from beginning and used proper cdb and pdb names. Then the db clone was successful.

it was cdb and pdb names mismatch and that’s why those services was not properly set Properly. 

Regards,
Karthik

On Thu, 10 Sep 2020 at 2:29 PM karthikmca.bhc [via Erman Arslan's Oracle Forum] <[hidden email]> wrote:




SQL> Select name from v$active_services;



NAME


----------------------------------------------------------------


r1227cdbXDB


r1227


ebs_R1227


SYS$BACKGROUND


SYS$USERS


R1227_ebs_patch


r1227cdb



7 rows selected.
























If you reply to this email, your message will be added to the discussion below:


http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Invalid-APPS-password-tp8756p8768.html







To unsubscribe from Invalid APPS password, click here.


NAML

--

Kind Regards... ?


Karthik Rao | Oracle Database Administrator

Pharmatrade LLC 

P.O.Box 11397 Plot No.598-1177

Dubai Investment Park 1 | Jebel Ali|Dubai, UAE

E-Mail:  [hidden email] 

Tel. +971 4 8991189

Fax. +971 4 8849234

Mob: +971 525826640

Web:  www.pharmatradeuae.com

 -- You only live once, but if you do it right, once is enough. --

Reply | Threaded
Open this post in threaded view
|

Re: Invalid APPS password

ErmanArslansOracleBlog
Administrator
Cool :)
I couldn't take care of your problem yesterday. A little busy. But you got the point and solved the incident.