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 |
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 ~]$ |
[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 |
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? |
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]$ |
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 |
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 |
Administrator
|
Send me the lsnrctl status and lsnrctl service output from the db node.
|
[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 |
SQL> Select name from v$active_services;
NAME ---------------------------------------------------------------- r1227cdbXDB r1227 ebs_R1227 SYS$BACKGROUND SYS$USERS R1227_ebs_patch r1227cdb 7 rows selected. |
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:
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 -- “You only live once, but if you do it right, once is enough.” -- |
Administrator
|
Cool :)
I couldn't take care of your problem yesterday. A little busy. But you got the point and solved the incident. |
Free forum by Nabble | Edit this page |