Jan 22
While doing restore controlfile to new host in windows server, getting below issue
ORA-19963: error getting logical block size of file F:\BACKUP\O1_MF_S_966071800_
F6C0G8CF_.BKP
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
Solution :
Windows, you need to give full permission of directory to users which contents of backup files.
Jan 22
I am trying to restore the database to new host, While doing the first step, I try to start the database,
SQL> startup nomount pfile=’F:\backup\init.ORA’;
ORA-32006: SEC_CASE_SENSITIVE_LOGON initialization parameter has been deprecated
ORA-00600: internal error code, arguments: [kmgs_component_init_5], [15], [], []
, [], [], [], [], [], [], [], []
Solution :
The below error message appeared in the alert log file.
ORA-27102: out of memory
OSD-00026: additional error information
O/S-Error: (OS 1455) The paging file is too small for this operation to complete.
Mon Jan 22 14:21:37 2018
Error: Failed to allocate SGA start_addr 00000007D0000000 size 134217728
It seems to be a Memory issue on the server. I have crosschecked the server RAM and init.ora file Memory target size. The Server RAM size is lesser than memory target size. so I have adjusted the memory target size in init.ora file according to the Server RAM and tried to start the database as a nomount stage, its okay.
Or you need to increase RAM on the server if you need more.
Jan 18
Please find the document here
Check the status
[root@ezylebuat ~]# systemctl status firewalld
● firewalld.service – firewalld – dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
Active: active (running) since Wed 2018-01-17 06:37:59 EST; 24min ago
Stop the firewall
[root@ezylebuat ~]# systemctl stop firewalld
[root@ezylebuat ~]# systemctl status firewalld
● firewalld.service – firewalld – dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
Active: inactive (dead) since Wed 2018-01-17 07:04:09 EST; 3s ago
Docs: man:firewalld(1)
Disable the firewall( After reboot,It will not enable automatically)
[root@ezylebuat ~]# systemctl disable firewalld
Enable the firewall
[root@ezylebuat ~]# systemctl enable firewalld
Start the firewall
[root@ezylebuat ~]# systemctl firewalld start
Client received SOAP Fault from server: The security token could not be authenticated or authorized Please see the server log to find more detail regarding the exact cause of the failure.Error while calling Oracle web service.
Solution:
SOAP Wsdl granted user password might be changed. Please check
Jan 15
In Oracle Database12c, SQL*Loader has a new feature called express mode that makes loading CSV files faster and easier. With express mode, there is no need to write a control file for most CSV files you load. Instead, you can load the CSV file with just a few parameters on the SQL*Loader command line.
Example :
SQL> create table dept(deptno number,deptname varchar2(20),deptlocation varchar2(20));
Table created.
SQL> desc dept;
Name Null? Type
—————————————– ——– —————————-
DEPTNO NUMBER
DEPTNAME VARCHAR2(20)
DEPTLOCATION VARCHAR2(20)
oracle:oradb]$ cat testload.dat
001,IT Dept,Riyadh
002,Accounting,Riyadh
003,HR Dept,Bahrain
[premiadb:oracle:testdb]$ sqlldr userid=testme data=testload.dat table=dept
Password:
SQL*Loader: Release 12.1.0.2.0 – Production on Mon Jan 15 09:28:42 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Express Mode Load, Table: DEPT
Path used: External Table, DEGREE_OF_PARALLELISM=AUTO
Table DEPT:
3 Rows successfully loaded.
Check the log files:
dept.log
dept_%p.log_xt
for more information about the load.
[premiadb:oracle:testdb]$ sqlplus testme
SQL*Plus: Release 12.1.0.2.0 Production on Mon Jan 15 09:28:58 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
Last Successful login time: Mon Jan 15 2018 09:28:45 +03:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select * from dept;
DEPTNO DEPTNAME DEPTLOCATION
———- ——————– ——————–
1 IT Dept Riyadh
2 Accounting Riyadh
3 HR Dept Bahrain
For more detail, Please refer
Click to access sqlldr-express-mode-wp-1991038.pdf
If your developer asked you to migrate concurrent program from dev or UAT to production, As a system administrator you need to do follow steps
Example :
Concurrent Program :
Concurrent program name : XX Report for Statement
Shortcut : xx_rep_stat
Application : XX Custom Application
XML Publisher :
Data definition code : xx_rep_stat
Template (rtf) : XX Report for Statement.rtf
rdf file on the custom top
Report File (rdf): xx_rep_stat.rdf
Step 1:
On development
System Administrator — > Concurrent –> Program –> define
Query — > “XX Report for Statement”
Download the ldt file on application tier :
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct xx_rep_stat.ldt PROGRAM CONCURRENT_PROGRAM_NAME=’XX_REP_STAT’ APPLICATION_SHORT_NAME=’XXREP’
How to find out application short name :
SELECT fa.application_id “Application ID”,
fat.application_name “Application Name”,
fa.application_short_name “Application Short Name”,
fa.basepath “Basepath”
FROM fnd_application fa,
fnd_application_tl fat
WHERE fa.application_id = fat.application_id
AND fat.language = USERENV(‘LANG’) and fat.application_name =’XX Custom Application’
— AND fat.application_name = ‘Payables’ — <change it>
ORDER BY fat.application_name;
The output — > “XXREP”
Once downloaded ldt file, you please copy to production application server which is concurrent program running server. If its linux, you please use SCP to transfer the file or winscp
Step 2:
On development,
Download the Template
XML Publisher Administrator — >
Query code –> ” xx_rep_stat”
Download the rtf and save it on your desktop
Step 3:
On Production,
Upload the ldt file on production server which you’re copied ldt file.
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct xx_rep_stat.ldt
Once uploaded, you please check on your application whether its uploaded or not
System Administrator — > Concurrent –> Program –> define
Query — > “XX Report for Statement”
Step 4:
Transfer the “xx_rep_stat.rdf” file from development custom top report to production custom top report location
Step 5:
On production application,
Create data definition and template as same as development
–> create data definition
Once Done Data definition,
–> create Template
Here you please upload that Template file which you’re downloaded from development.
Example :
Create Data Definition :
Create Template
Step 6:
Please check with your developer any Objects you need to migrate to production which is related to this report.
If yes, please migrate those objects also from development to production
Step 7:
Add your report file to related request group
A user was tried to select the legal entity list of values in the bank account, It does not appear in LOV.
Solution :
you can review the below support document
R12: CE: Unable to See the Legal Entity List of Values in the Bank Account Owner Field (Doc ID 415529.1)
Note: I selected “Payable Role” instead of Cash Management
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>
Database Administrator, Blogger, Contributor
 | S Marguerite on bsu.sh Exception in thread… |
 | Altaf on Disaster Recovery:Restore data… |
 | Calvin on Flashback Data Archive |
 | vaibhav hemanshu kan… on ORA-28056: Writing audit recor… |
| Wallet open failed on How to Configure Clients to Us… |
DBA 