ORA-25153: Temp Tablespace error on adconfig.sh
July 24th, 2022, posted in Oracle, Oracle EBS Application========================================================================
If This Error Facing on Adconfig.sh or autoconfig.sh
=======================================================================
Atempting upload of Context file and templates to database...ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -1187: ORA-01187: cannot read from file 515 because it failed verification tests ORA-01110: data file 515: '/oradata/proddb/data/temp03.dbf' has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT. oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -1187: ORA-01187: cannot read from file 515 because it failed verification tests ORA-01110: data file 515: '/oradata/proddb/data/temp03.dbf' has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT. at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:220) at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:328) at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:678) at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:222) at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1688) at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:763) FAILED COMPLETED ======================================================================================================================================================= Solution Apply ============================================================================================================================================
login as: dgdb dgdb@192.168.1.80's password: Last login: Mon May 2 15:54:08 2016 from 192.168.81.61 [dgdb@b6dgdb ~]$ cd /oradb/proddb/PROD/db/tech_st/11.1.0/ [dgdb@b6dgdb 11.1.0]$ . ./T2_b6dgdb.env [dgdb@b6dgdb 11.1.0]$ sqlplus / as sysdba SQL*Plus: Release 11.1.0.7.0 - Production on Mon May 2 16:46:14 2016 Copyright (c) 1982, 2008, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> sql> select bytes/1024/1024 from dba_temp_files; select bytes/1024/1024 from dba_temp_files * ERROR at line 1: ORA-01187: cannot read from file 513 because it failed verification tests ORA-01110: data file 513: '/oradata/proddb/data/temp01.dbf' SQL> col name format a50 SQL> run 1* select file#,status,name from v$tempfile FILE# STATUS NAME ---------- ------- -------------------------------------------------- 1 ONLINE /oradata/proddb/data/temp01.dbf 2 ONLINE /oradata/proddb/data/temp02.dbf 3 ONLINE /oradata/proddb/data/temp03.dbf SQL> col DESCRIPTION format a40 SQL> SQL> SELECT * FROM database_properties WHERE property_name like '%TABLESPACE' PROPERTY_NAME PROPERTY_VALUE DESCRIPTION ------------------------------ ---------------------------------------- ---------------------------------------- DEFAULT_TEMP_TABLESPACE TEMP ID of default temporary tablespace DEFAULT_PERMANENT_TABLESPACE SYSTEM Default Permanent Tablespace ID CREATE TEMPORARY TABLESPACE temp3 TEMPFILE '/oradata/proddb/data/temp_01' SIZE 1024M TABLESPACE GROUP temp; alter tablespace temp3 add tempfile '/oradata/proddb/data/temp_02' SIZE 1024M; ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp3; SQL> SELECT * FROM dba_tablespace_groups; GROUP_NAME TABLESPACE_NAME ------------------------------ ------------------------------ TEMP TEMP1 TEMP TEMP2 DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES; DROP TABLESPACE temp2 INCLUDING CONTENTS AND DATAFILES; sql> select TABLESPACE_NAME,FILE_NAME from dba_temp_files TABLESPACE_NAME FILE_NAME ------------------------------ ---------------------------------------- TEMP3 /oradata/proddb/data/temp_02 TEMP3 /oradata/proddb/data/temp_01 ======================================================================================================================================== Then Run Adconfig.sh ======================================================================================================================================== login as: dgapps dgapps@192.168.1.81's password: Last login: Mon May 2 16:24:32 2016 from 192.168.81.61 [dgapps@c6dgapps ~]$ cd /oraapps/prodapps/ oraInventory/ PROD/ [dgapps@c6dgapps ~]$ cd /oraapps/prodapps/PROD/apps/apps_st/appl/ [dgapps@c6dgapps appl]$ cd ad/12.0.0/bin [dgapps@c6dgapps bin]$ [dgapps@c6dgapps bin]$ sh adconfig.sh Enter the full path to the Context file:/oraapps/prodapps/PROD/inst/apps/T2_c6dgapps/appl/admin/T2_c6dgapps.xml
DBCA fails with errors: [FATAL] [DBT-50000] Unable to check for available memory
July 10th, 2022, posted in Oracle QueriesRecently I have installed Oracle 19c Database binary to windows machine. And after that I started DBCA to create database.
In “Configuration options” steps I got memory error. i.e. [DBT-50000] Unable to check for available memory
Earlier I selected 6GB for my SGA but after this error I had selected 1GB only. But still was facing this issue.
Here is the screenshot for the same.
![[DBT-50000] Unable to check for available memory,Unable to check for available memory,DBT-50000,Oracle database,dba database](http://aliimmam.com/wp-content/uploads/sites/2/2022/01/DBT-50000_avilable_memeory.jpg)
After searching oracle docs for known issue, I found, it’s a bug. One can find details about this bug on following oracle notes.
DBCA fails with errors: [FATAL] [DBT-50000] Unable to check for available memory in “Specify configuration option” (Doc ID 2631718.1)
Workaround for this issue is,
Run dbca with “-J-Doracle.assistants.dbca.validate.ConfigurationParams=false” like a bellow command,
$> dbca -J-Doracle.assistants.dbca.validate.ConfigurationParams=false
This will solve your issue and DBCA will run smooth, no issues than !!
ServiceAliasException: Could not initialize Service Alias: TNS-04404: no error
June 21st, 2022, posted in Oracle QueriesI was getting this TNS error while creating Listner with “netca”, here is the screenshot for the same.
D:\app\db193\bin>netca Oracle Net Services Configuration: Configuring Listener:LISTENERCBT ServiceAliasException: Could not initialize Service Alias: TNS-04404: no error caused by: oracle.net.config.ConfigException: TNS-04414: File error caused by: TNS-04605: Invalid syntax error: Unexpected char or LITERAL "IEPDB1" before or at IEPDB1 = ( Error in file D:\TNS_ADMIN\tnsnames.ora
This is my windows machine and creating new listner for my newly created CDB. DB version is 19.3
As above error shows that I have some issue with my tnsnames.ora with some of my TNS Entry with IEPDB1.
In my environment TNS_ADMIN environment variable is set and it is pointing to my D:\TNS_ADMIN\tnsnames.ora
Here I found some junk characters near IEPDB1 TNS entry, I removed it and save the file and ran netca again…
Now, all went good..
It solved my problem !!!
Change Solaris Zones Configurations Online
May 29th, 2022, posted in SolarisI assume you are aware that Solaris Zones are one of the most valuable features of Solaris since years. In this post I focus on the “Live Zone Reconfiguration” feature available since
Solaris 11.2 for Solaris Zones and since Solaris 11.3 for Kernel Zones. CPU pools, filesystems, network and disk configurations can be changed while Solaris Zones are running.
1. Limit CPU usage of a Solaris Zone using dedicated-cpu
By default Solaris Zones share the CPUs with the global and all other local Zones.
Our sample Zone currently uses 16 virtual CPUs.
# zlogin v0131 psrinfo | wc -l 16
We can now assign 4 dedicated virtual CPUs to be used by this Zone only.
# zonecfg -z v0131 -r "add dedicated-cpu; set ncpus=4; end" zone 'v0131': Checking: Adding dedicated-cpu zone 'v0131': Applying the changes # zlogin v0131 psrinfo | wc -l 4
The “zonecfg -r” changes the configuration of the running Zone only.
Make sure to run the command once again to make the configuration persistent for the next Zone reboot.
Make sure to run the command once again to make the configuration persistent for the next Zone reboot.
# zonecfg -z v0131 "add dedicated-cpu; set ncpus=4; end"
2. Create and mount an additional ZFS filesystem
# zfs create v0131_data/myapp # zonecfg -z v0131 -r "add fs; set type=zfs; set dir=/myapp; set special=v0131_data/myapp; end" zone 'v0131': Checking: Mounting fs dir=/myapp zone 'v0131': Applying the changes # zlogin v0131 mount | grep myapp /myapp on /myapp read/write/setuid/devices/rstchown/nonbmand/exec/xattr/atime/zone=v0131/nozonemod/sharezone=4/dev=d50045 on Fri Jun 10 11:56:19 2016
And make it persistent
# zonecfg -z v0131 "add fs; set type=zfs; set dir=/myapp; set special=v0131_data/myapp; end"
Adding network interfaces and disk devices are similar to the samples above.