Get last 500 lines from a file on windows powershell
Get last 500 lines from a file on windows power shell
Get-Content <File location> -Wait -Tail 500
Oct 1
Upgrade Oracle Application Express (APEX) manually before the database upgrade
While doing upgrade database from 12c to 19c
Upgrade Oracle Application Express (APEX) manually before the database upgrade.
The database contains APEX version 5.0.4.00.12. Upgrade APEX to at least version 18.2.0.00.12.
Starting with Oracle Database Release 18, APEX is not upgraded automatically as part of the database upgrade. Refer to My Oracle Support Note 1088970.1 for information about APEX installation and upgrades.
Solution :
Download APEX 18.2
https://www.oracle.com/tools/downloads/apex-v182-archive-downloads.html
Install & Upgrade’
move the OLD apex to different location or renam apex to apex_old
Extract the apex and copy to oracle home path.
as administrator
@apexins.sql SYSAUX SYSAUX TEMP /i/
Aug 31
Best Practices for Minimizing Oracle E-Business Suite Release 12.2.n Upgrade Downtime
refer
Best Practices for Minimizing Oracle E-Business Suite Release 12.2.n Upgrade Downtime (Doc ID 1581549.1)
Jul 21
Oracle Linux 7.4 harddisk partition
You have two HDD and need to make two partition with separate during installation
REST ISG_SERVICE_EXECUTION_ERROR getting error
When we’re trying to post the data using REST service after we add some parameter in existing package, we’re getting the error while post
{
“ISGServiceFault”: {
“Code”: “ISG_SERVICE_EXECUTION_ERROR”,
“Message”: “Error while executing service”,
“Resolution”: “System error, please see service log trace for details”,
“ServiceDetails”: {
“ServiceName”: “XXACE_AP_INV_CMS_SOA_PKG”,
“OperationName”: “xxace_main”,
“InstanceId”: “0”
}
}
}
Log in error while deploy REST service
PLS-00306: wrong number or types of arguments in call to ‘HAS_DEFAULT’
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Solution :
Functional Administrator –> clear cache
restart service
undeploy and deploy the service again
Now we can able to post data
EBS 12.2 Only Allow Access to Oracle WebLogic Server Administration Ports from Trusted Hosts
When i am trying to access the weblogic server console from one of client machine, I am getting the below error
Solution :
If you have applied the Critical Patch Update (CPU) released in April 2019, then you can use the context variable s_wls_admin_console_access_nodes to specify the trusted hosts used by administrators that require access to the Oracle WebLogic Server Administration Console and Fusion Middleware Control. Set this context variable to a list of trusted hosts that are allowed to access the consoles using the Oracle WebLogic Server Administration ports.
Run file system, we need to add the client ip or hostname lists in context file
<s_wls_admin_console_access_nodes oa_var=”s_wls_admin_console_access_nodes”>10.0.XX.XX</s_wls_admin_console_access_nodes>
run autoconfig
stop and start service
Now we can able to reach the weblogic server console URL
adop phase=fs_clone
yum install package compilation issue
I created a local repository in redhat 7.6 and then i am trying to install the package but i am getting the dependency issue.
Error :
[root@ebs-117-41 Packages]# yum install glibc-2.17-222.el7.i686
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered with an entitlement server. You can use subscription-manager to register.
Resolving Dependencies
–> Running transaction check
—> Package glibc.i686 0:2.17-222.el7 will be installed
–> Processing Dependency: glibc-common = 2.17-222.el7 for package: glibc-2.17-222.el7.i686
–> Processing Dependency: libfreebl3.so(NSSRAWHASH_3.12.3) for package: glibc-2.17-222.el7.i686
–> Processing Dependency: libfreebl3.so for package: glibc-2.17-222.el7.i686
–> Running transaction check
—> Package glibc.i686 0:2.17-222.el7 will be installed
–> Processing Dependency: glibc-common = 2.17-222.el7 for package: glibc-2.17-222.el7.i686
—> Package nss-softokn-freebl.i686 0:3.34.0-2.el7 will be installed
–> Finished Dependency Resolution
Error: Package: glibc-2.17-222.el7.i686 (customrepo)
Requires: glibc-common = 2.17-222.el7
Installed: glibc-common-2.17-260.el7.x86_64 (@anaconda/7.6)
glibc-common = 2.17-260.el7
Available: glibc-common-2.17-222.el7.x86_64 (customrepo)
glibc-common = 2.17-222.el7
You could try using –skip-broken to work around the problem
You could try running: rpm -Va –nofiles –nodigest
Solution :
By mistake I created a local repository with lower version of redhat. so that it’s not compatible when i try to install rpm packages. After i corrected the repository version, it’s okay to install.
In case, If you still continue to see the error after you created the repository with correct version, you need to clean.
yum clean all
then execute
yum repolist
Now We can able to install rpm packages on the server using local repository.
DBA 