Web Link:
https://docs.oracle.com/cd/E26401_01/doc.122/e22952/T156458T659606.htm
FNDCPASS apps/devapps 0 Y system/furqmanager06 ALLORACLE Goodday09
--------------------------------------------------------------
####################### Category-1 (A) #######################
--------------------------------------------------------------
alter user sys identified by Admin_6677 account unlock;
alter user system identified by furqmanager06 account unlock;
--------------------------------------------------------------
####################### Category-1 (B) #######################
--------------------------------------------------------------
##### EM Back-End Users if you are use EM so you should chnaged the password only #####
alter user dbsnmp identified by furqdbsnmp06 account unlock;
alter user sysman identified by furqsysman06 account unlock;
alter user MGMT_VIEW identified by furqMGMT_VIEW06 account unlock;
--------------------------------------------------------------
####################### Category-2 ( ) #######################
--------------------------------------------------------------
alter user SSOSDK identified by furqssosdk06 ;
alter user scott account lock;
ERROR at line 1:
ORA-01918: user 'SCOTT' does not exist
select username from dba_users where username='SCOTT';
no rows selected
--------------------------------------------------------------
####################### Category-3 (A) #######################
--------------------------------------------------------------
select username from dba_users where username
in ('JUNK_PS','MDSYS','ODM_MTR','OLAPSYS','ORDPLUGINS','ORDSYS','OUTLN','OWAPUB','MGDSYS');
USERNAME
------------------------------
OWAPUB
OLAPSYS
ODM_MTR
OUTLN
ORDSYS
MDSYS
ORDPLUGINS
7 rows selected.
1 ---- JUNK_PS ( User does not exist)
2 ---- MGDSYS ( User does not exist)
select 'alter user '||username||' identified by'||' furq'||username||'06 ;' from dba_users where username
in ('JUNK_PS','MDSYS','ODM_MTR','OLAPSYS','ORDPLUGINS','ORDSYS','OUTLN','OWAPUB','MGDSYS');
'ALTERUSER'||USERNAME||'IDENTIFIEDBY'||'furq'||USERNAME||'06;'
--------------------------------------------------------------------------------
alter user OWAPUB identified by furqOWAPUB06 ;
alter user OLAPSYS identified by furqOLAPSYS06 ;
alter user ODM_MTR identified by furqODM_MTR06 ;
alter user OUTLN identified by furqOUTLN06 ;
alter user ORDSYS identified by furqORDSYS06 ;
alter user MDSYS identified by furqMDSYS06 ;
alter user ORDPLUGINS identified by furqORDPLUGINS06 ;
## Run on sqlplus Command prompt
--------------------------------------------------------------
####################### Category-3 (B) #######################
--------------------------------------------------------------
select username from dba_users where username in ('PORTAL30_DEMO','PORTAL30_PUBLIC','PORTAL30_SSO_PS','PORTAL30_SSO_PUBLIC')
no rows selected
This Category is not Applicable.
--------------------------------------------------------------
####################### Category-4 (A) #######################
--------------------------------------------------------------
select username from dba_users where username in ('PORTAL30','PORTAL30_SSO');
no rows selected
SQL> show user
USER is "SYS"
SQL>
1- ----- PORTAL30
(User does not exist in Database)
2- ----- PORTAL30_SSO
(User does not exist in Database)
###### User inactive via application UI ######
col USER_NAME format a20
set lines 250 pages 250
select USER_NAME,CREATION_DATE,START_DATE,END_DATE from fnd_user where user_name in ('PORTAL30','PORTAL30_SSO');
USER_NAME CREATION_ START_DAT END_DATE
-------------------- --------- --------- ----------
PORTAL30 26-JUN-03 26-JUN-03 06-APR-18
PORTAL30_SSO 26-JUN-03 26-JUN-03 06-APR-18
--------------------------------------------------------------
####################### Category-4 (B) #######################
--------------------------------------------------------------
1- ODM
------- User exist on Database its not register in Application.
2- EDWREP ------- User dose not exist on Database its not register in Application.
### Not in Application User ###
-------------------------------
SQL> select USER_NAME ,CREATION_DATE from fnd_user where USER_NAME in ('ODM');
no rows selected
SQL> select USER_NAME ,CREATION_DATE from fnd_user where USER_NAME in ('EDWREP');
no rows selected
#################################################################################
### ODM Database User ###
###
### --------------------------
###
### SQL> select USERNAME,CREATED ,ACCOUNT_STATUS from dba_users where USERNAME in ('ODM','EDWREP');
###
###
###
### USERNAME CREATED ACCOUNT_STATUS
###
### ------------------------------ --------- --------------------------------
###
### ODM 14-NOV-10 OPEN
###
###
###
### SQL> alter user odm account lock;
###
###
###
### User altered.
###
#################################################################################
--------------------------------------------------------------
####################### Category-4 (C) #######################
--------------------------------------------------------------
SQL> select USERNAME,CREATED ,ACCOUNT_STATUS from dba_users where USERNAME in ('CTXSYS');
USERNAME CREATED ACCOUNT_STATUS
------------------------------ --------- --------------------------------
CTXSYS 12-NOV-10 OPEN
SQL> CONN CTXSYS/CTXSYS
Connected.
SQL> SELECT * FROM CAT;
130 rows selected.
FNDCPASS apps/furqapps 0 Y system/furqmanager06 ORACLE CTXSYS furqctxsys06
SQL> conn ctxsys/furqctxsys06
Connected.
--------------------------------------------------------------
####################### Category-5 (A) #######################
--------------------------------------------------------------
1- APPS
2- APPLSYS
3- APPLSYSPUB
4- APPS_NE
5- APPS_MRC
--------------------------------------------------------------
####################### Category-5 (B) #######################
--------------------------------------------------------------
1- AD_MONITOR
--------------------------------------------------------------
####################### Category-6 (A) #######################
--------------------------------------------------------------
CONN IBA/IBA -OA
CONN IMT/IMT -OA
CONN IPD/IPD -OA
CONN OKB/OKB -L
CONN OKO/OKO -OA
CONN OKR/OKR -OA
CONN ABMAHM/ABMAHM ---NA
CONN VEH/VEH -OA
CONN XNC/XNC -OA
CONN XNI/XNI -OA
CONN XNM/XNM -OA
CONN XNS/XNS -OA
CONN RHX/RHX -OA
CONN RLA/RLA -OA
SELECT USERNAME,CREATED FROM DBA_USERS WHERE USERNAME
IN ('IBA','IMT','IPD','OKB','OKO','OKR','ABMAHM','VEH','XNC','XNI','XNM','XNS','RHX','RLA');
USERNAME CREATED
------------------------------ ---------
OKB 14-NOV-10
RLA 14-NOV-10
OKR 14-NOV-10
IBA 14-NOV-10
XNS 14-NOV-10
XNM 14-NOV-10
IMT 14-NOV-10
IPD 14-NOV-10
XNI 14-NOV-10
VEH 14-NOV-10
RHX 14-NOV-10
XNC 14-NOV-10
OKO 14-NOV-10
13 rows selected.
SELECT USER_NAME,CREATION_DATE,START_DATE, END_DATE FROM FND_USER WHERE USER_NAME IN ('IBA','IMT','IPD','OKB','OKO','OKR','ABMAHM','VEH','XNC','XNI','XNM','XNS','RHX','RLA');
no rows selected
SELECT 'ALTER USER '||USERNAME||' IDENTIFIED BY furq'||USERNAME||'06 ACCOUNT LOCK;' FROM DBA_USERS WHERE USERNAME IN ('IBA','IMT','IPD','OKB','OKO','OKR','ABMAHM','VEH','XNC','XNI','XNM','XNS','RHX','RLA'); 2
'ALTERUSER'||USERNAME||'IDENTIFIEDBYfurq'||USERNAME||'06ACCOUNTLOCK;'
----------------------------------------------------------------------------------------------------------
ALTER USER OKB IDENTIFIED BY furqOKB06 ACCOUNT LOCK;
ALTER USER RLA IDENTIFIED BY furqRLA06 ACCOUNT LOCK;
ALTER USER OKR IDENTIFIED BY furqOKR06 ACCOUNT LOCK;
ALTER USER IBA IDENTIFIED BY furqIBA06 ACCOUNT LOCK;
ALTER USER XNS IDENTIFIED BY furqXNS06 ACCOUNT LOCK;
ALTER USER XNM IDENTIFIED BY furqXNM06 ACCOUNT LOCK;
ALTER USER IMT IDENTIFIED BY furqIMT06 ACCOUNT LOCK;
ALTER USER IPD IDENTIFIED BY furqIPD06 ACCOUNT LOCK;
ALTER USER XNI IDENTIFIED BY furqXNI06 ACCOUNT LOCK;
ALTER USER VEH IDENTIFIED BY furqVEH06 ACCOUNT LOCK;
ALTER USER RHX IDENTIFIED BY furqRHX06 ACCOUNT LOCK;
ALTER USER XNC IDENTIFIED BY furqXNC06 ACCOUNT LOCK;
ALTER USER OKO IDENTIFIED BY furqOKO06 ACCOUNT LOCK;
13 rows selected.
########################### Data Base #################################
login as: oracle
oracle@140.1.20.16's password:
Last login: Wed Sep 19 19:50:22 2018 from 140.1.25.65
[oracle@ebstest ~]$
[oracle@ebstest ~]$
[oracle@ebstest ~]$
[oracle@ebstest ~]$
[oracle@ebstest ~]$ db
[oracle@ebstest ~]$ sdb
-bash: sdb: command not found
[oracle@ebstest ~]$
[oracle@ebstest ~]$
[oracle@ebstest ~]$
[oracle@ebstest ~]$
[oracle@ebstest ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 26 10:17:33 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL>
SQL>
SQL>
SQL> alter user sys identified by Admin_6677 account unlock;
User altered.
SQL> alter user system identified by furqmanager06 account unlock;
User altered.
SQL> alter user dbsnmp identified by furqdbsnmp06 account unlock;
alter user sysman identified by furqsysman06 account unlock;
alter user MGMT_VIEW identified by furqMGMT_VIEW06 account unlock;
User altered.
SQL>
User altered.
SQL>
User altered.
SQL> alter user SSOSDK identified by furqssosdk06 ;
User altered.
SQL> alter user OWAPUB identified by furqOWAPUB06 ;
alter user OLAPSYS identified by furqOLAPSYS06 ;
alter user ODM_MTR identified by furqODM_MTR06 ;
alter user OUTLN identified by furqOUTLN06 ;
alter user ORDSYS identified by furqORDSYS06 ;
alter user MDSYS identified by furqMDSYS06 ;
alter user ORDPLUGINS identified by furqORDPLUGINS06 ;
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
SQL>
SQL>
SQL>
SQL> select username from dba_users where username in ('PORTAL30_DEMO','PORTAL30_PUBLIC','PORTAL30_SSO_PS','PORTAL30_SSO_PUBLIC')
2 /
no rows selected
SQL> ALTER USER OKB IDENTIFIED BY furqOKB06 ACCOUNT LOCK;
ALTER USER RLA IDENTIFIED BY furqRLA06 ACCOUNT LOCK;
ALTER USER OKR IDENTIFIED BY furqOKR06 ACCOUNT LOCK;
ALTER USER IBA IDENTIFIED BY furqIBA06 ACCOUNT LOCK;
ALTER USER XNS IDENTIFIED BY furqXNS06 ACCOUNT LOCK;
ALTER USER XNM IDENTIFIED BY furqXNM06 ACCOUNT LOCK;
ALTER USER IMT IDENTIFIED BY furqIMT06 ACCOUNT LOCK;
ALTER USER IPD IDENTIFIED BY furqIPD06 ACCOUNT LOCK;
ALTER USER XNI IDENTIFIED BY furqXNI06 ACCOUNT LOCK;
ALTER USER VEH IDENTIFIED BY furqVEH06 ACCOUNT LOCK;
ALTER USER RHX IDENTIFIED BY furqRHX06 ACCOUNT LOCK;
ALTER USER XNC IDENTIFIED BY furqXNC06 ACCOUNT LOCK;
ALTER USER OKO IDENTIFIED BY furqOKO06 ACCOUNT LOCK;
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ebstest ~]$
[oracle@ebstest ~]$
[oracle@ebstest ~]$
[oracle@ebstest ~]$
[oracle@ebstest ~]$ cd $ORACLE_HOME
[oracle@ebstest 11.2.0]$ cd appsutil/scripts/
[oracle@ebstest scripts]$ ls
PROD_dbs TEST_ebstest
[oracle@ebstest scripts]$ cd TEST_ebstest/
[oracle@ebstest TEST_ebstest]$ ls
adautocfg.sh adchknls.pl addbctl.sh addlnctl.sh adexecsql.pl adlsnodes.sh adpreclone.pl adstopdb.sql adstrtdb.sql
[oracle@ebstest TEST_ebstest]$ sh adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/oracle/proddb/11.2.0/appsutil/log/TEST_ebstest/09261029/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/oracle/proddb/11.2.0
Classpath : :/u01/oracle/proddb/11.2.0/jdbc/lib/ojdbc5.jar:/u01/oracle/proddb/11.2.0/appsutil/java/xmlparserv2.jar:/u01/oracle/proddb/11.2.0/appsutil/java:/u01/oracle/proddb/11.2.0/jlib/netcfg.jar:/u01/oracle/proddb/11.2.0/jlib/ldapjclnt11.jar
Using Context file : /u01/oracle/proddb/11.2.0/appsutil/TEST_ebstest.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
[oracle@ebstest TEST_ebstest]$
[oracle@ebstest TEST_ebstest]$
############################# Application ##############################
login as: applmgr
applmgr@140.1.20.16's password:
Last login: Fri Sep 7 17:10:51 2018 from 140.1.25.65
[applmgr@ebstest ~]$
[applmgr@ebstest ~]$
[applmgr@ebstest ~]$
[applmgr@ebstest ~]$
[applmgr@ebstest ~]$ apps
[applmgr@ebstest ~]$
[applmgr@ebstest ~]$
[applmgr@ebstest ~]$ FNDCPASS apps/devapps 0 Y system/furqmanager06 ORACLE CTXSYS furqctxsys06
APP-FND-01564: ORACLE error 1017 in AFPCOA
Cause: AFPCOA failed due to ORA-01017: invalid username/password; logon denied
.
The SQL statement being executed at the time of the error was: and was executed from the file.
[applmgr@ebstest ~]$ FNDCPASS apps/furqapps 0 Y system/furqmanager06 ORACLE CTXSYS furqctxsys06
Log filename : L5720624.log
Report filename : O5720624.out
[applmgr@ebstest ~]$ vi L5720624.log
[applmgr@ebstest ~]$
[applmgr@ebstest ~]$
[applmgr@ebstest ~]$
[applmgr@ebstest ~]$ sqlplus ctxsys/furqctxsys06
SQL*Plus: Release 10.1.0.5.0 - Production on Wed Sep 26 10:25:11 2018
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL>
SQL>
SQL>
SQL> exit
Source: Oracle Support/R&D
