Skip to content
Advertisements

ORA-01017: invalid username/password ora_dba group

C:\Users\mazar>sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun Jan 7 14:15:59 2018

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

ERROR:
ORA-01017: invalid username/password; logon denied

 

Solution: added ora_dba group to user

C:\Windows\system32>net localgroup

C:\Windows\system32>net localgroup ora_dba mazar /add
The command completed successfully.

 

C:\Users\mazar>sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun Jan 7 14:21:45 2018

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

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production

SQL>

 

Advertisements

DATA MASKING on EBS 12.1.3 with Enterprise Manager 12.1.0.5

Please follow the step by step document of Data masking on EBS 12.1.3

DATA MASKING on EBS 12

find the files older than 30 days in linux

cd /u01/app/12c/oracle/trace

find *.trc -maxdepth 1 -mtime +30 -type f -exec ls -l {} \;

 

 

Data pump command import exclude

impdp system/Admin123 directory=exp_dir dumpfile=exp_dump.dmp logfile=exp_dump.log schemas=scott exclude=TABLE:\”IN \(\’EMP\’,\’DEPT\’\)\”

Trigger for open all pdb

create trigger open_all_pdbs
after startup on database
begin
execute immediate ‘alter pluggable database all open’;
end open_all_pdbs;
/

Drop database link using sys

Step 1:

select * from dba_db_links

Step 2:  create a procedure

Create or replace procedure Drop_DbLink(schemaName varchar2, dbLink varchar2 ) is
plsql varchar2(1000);
cur number;
uid number;
rc number;
begin
select
u.user_id into uid
from dba_users u
where u.username = schemaName;
plsql := ‘drop database link “‘||dbLink||'”‘;
cur := SYS.DBMS_SYS_SQL.open_cursor;
SYS.DBMS_SYS_SQL.parse_as_user(
c => cur,
statement => plsql,
language_flag => DBMS_SQL.native,
userID => uid
);
rc := SYS.DBMS_SYS_SQL.execute(cur);

SYS.DBMS_SYS_SQL.close_cursor(cur);
end;
/

 

Step 3: Drop database link using sys

 

exec Drop_DbLink(‘owner’,’dblinkname’);

Maintenance Mode enabled in obiee

Maintenance Mode enabled in obiee using runcat.sh

[oracle@obidev catalogmanager]$ ./runcat.sh -cmd maintenanceMode -on -online http://10.1.x.xxx:9704/analytics/saw.dll -credentials /u01/oracle/MiddlewareHome/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalogmanager/login.txt
BIFNDN_LABEL =BIFNDN_11.1.1.7.0_LINUX.X64_130303.2025
Maintenance Mode is now ON

 

 

user not able to view responsibility in oracle apps

As a system administrator, you please submit the below request

Workflow Directory Services User/Role Validation

optional
yes
yes
yes

Optional run If it does not work after done above steps

Synchronize WF LOCAL tables

Find out completed concurrent request of SID

Script for find out completed concurrent request of particular SID

SELECT ( select USER_CONCURRENT_PROGRAM_NAME from Fnd_Concurrent_Programs_tl where LANGUAGE=’US’ and CONCURRENT_PROGRAM_ID=a.CONCURRENT_PROGRAM_ID)prog_name
,a.phase_code,a.status_code,a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID
FROM apps.fnd_concurrent_requests a, apps.fnd_concurrent_processes b, v$process c, v$session d
WHERE a.controlling_manager = b.concurrent_process_id AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid and d.sid= 242
order by a.REQUEST_DATE

Datapump command exclude table

Datapump Command exclude table :

expdp system/Admin123 directory=exp_dir dumpfile=exp_dump.dmp logfile=exp_dump.log schemas=scott exclude=TABLE:\”IN \(\’EMP\’\)\”

 

For two table exclude

expdp system/Admin123 directory=exp_dir dumpfile=exp_dump.dmp logfile=exp_dump.log schemas=scott exclude=TABLE:\”IN \(\’EMP\’,\’DEPT\’\)\”