• Home
  • Privacy Policy
Top Menu
  • Home
  • C#
  • .Net
  • ADO.NET
  • LINQ .Net
  • Windows Form
  • Python

Compitionpoint

C# Tutorial easy to learn

  • Home
  • C#
  • .Net
  • ADO.NET
  • LINQ .Net
  • Windows Form
  • Python

Create New Application user from existing user in EBS R12

compitionpoint November 24, 2020 Create New Application user from existing user in EBS R122020-09-12T11:35:05+00:00 Oracle Apps DBA No Comment
We can create new application user from existing user with same responsibility, Which can be achieved from FNDLOAD utility. Here I would like to create new user with name ‘APPADMIN’…
Continue Reading

REP-0004: Warning: Unable to open user preference file

compitionpoint November 20, 2020 REP-0004: Warning: Unable to open user preference file2020-09-12T11:32:26+00:00 Oracle Apps DBA No Comment
Symptoms: All concurrent requests that run REPORTS are printing the following warning in the request log. “REP-0004: Warning: Unable to open user preference file” Your local (customized) Oracle Reports preference…
Continue Reading

Oracle ORA-21561 : OID generation failed

compitionpoint November 19, 2020 Oracle ORA-21561 : OID generation failed2020-09-12T11:32:29+00:00 Oracle database No Comment
Giving below error when trying to connect from Oracle client “ORA-21561 : OID generation failed” ERROR: sqlplus <test_user>/<test_user_password>@<database_name> xxxxx xxxx xxxx xxxx ERROR: ORA-21561 : OID generation failed Enter user-name:…
Continue Reading

ORA-12537: TNS:connection closed

compitionpoint November 17, 2020 ORA-12537: TNS:connection closed2020-09-12T11:32:37+00:00 Oracle database No Comment
Giving below error when trying to connect oracle user ERROR: Sqlplus scott/[email protected] SQL*Plus: Release – Production on Thu Oct 16 15:06:46 2008 Copyright (c) 1982, 2005, Oracle.  All rights reserved.…
Continue Reading

CHECK TABLESPACE SIZE, FREE AND USED SPACE

compitionpoint November 16, 2020 CHECK TABLESPACE SIZE, FREE AND USED SPACE2020-09-12T11:32:41+00:00 Oracle database No Comment
Below query is used for finding total tablespace size and free, used space. select tablespace_name, ROUND(bytes_free,2) free,ROUND(bytes_total-bytes_free,2) used, ROUND(bytes_total,2) total,perused from (select , ,, ROUND((100-(100*)),2) perused from (Select tablespace_name,sum(bytes)/1024/1024 bytes_free…
Continue Reading

DROP DATABASE THROUGH RMAN

compitionpoint November 15, 2020 DROP DATABASE THROUGH RMAN2020-09-12T11:32:44+00:00 Oracle database No Comment
In Oracle Database 10gR1 Oracle introduced the RMAN command DROP DATABSE. This one simple statement has the ability to completely remove a database including all RMAN backups with the optional…
Continue Reading

How to compile forms in R12

compitionpoint November 14, 2020 How to compile forms in R122020-09-12T11:32:48+00:00 Oracle Apps DBA No Comment
we have to use frmcmp(Form Compiler) for compiling forms and libraries in Oracle Applications Version R12, But in 11i we need to use f60gen to compile forms and libraries which…
Continue Reading

How to compile forms in 11i

compitionpoint November 12, 2020 How to compile forms in 11i2020-09-12T11:32:57+00:00 Oracle Apps DBA No Comment
we have to use f60gen for compiling forms and libraries in Oracle Applications Version 11i, But this is deprecated in R12 and we need to use frmcmp(Form Compiler)  to compile…
Continue Reading

Drop temp tablespace taking long time

compitionpoint November 11, 2020 Drop temp tablespace taking long time2020-09-12T11:33:02+00:00 Oracle database No Comment
Created new temporary tablespace: CREATE TEMPORARY TABLESPACE TEMP01 TEMPFILE ‘/u01/oracle/#8217; SIZE 2g; Make new temporary tablespace as default: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP01; Dropping old temporary tablespace, Which is…
Continue Reading

Find size of Table,Index and USER/SCHEMA in Oracle

compitionpoint November 9, 2020 Find size of Table,Index and USER/SCHEMA in Oracle2020-09-12T11:33:13+00:00 Oracle database No Comment
How to find size of Table or Index or User/Schema in Oracle Database. SIZE OF TABLE: Select segment_name,sum(bytes)/1024/1024/1024 as “SIZE in GB” from user_segments where segment_name=’TABLE_NAME’ group by segment_name; OR…
Continue Reading
«‹23456›»

Categories

  • .Net framework
  • ADO.NET
  • Basic UNIX
  • Blog
  • C#
  • DataGuard
  • LINQ .Net
  • Oracle Apps DBA
  • Oracle Cloud ICS / OIC
  • Oracle database
  • ORACLE DBA
  • Python
  • R12.2
  • React.js
  • RMAN
  • Windows Form

Tags

Arrays Assignment Operators C# Iterators Command Line Arguments Comparison Operators Constant Variables Delegates Escape Sequences Explicit Conversion Exploring Visual Studio Failed to connect to the Server FRM-92050 Getting Input From User Implicit Conversion Jagged Arrays java.io.IOException Logical Operators Looping Mathematical Operators Method Overloading Named Arguments Nesting if Statements null Coalescing Operator Object Oriented Programming Operator Overloading Operator Precedence Optional Parameters Passing Arguments by Reference Recursion strings and regular expressions The DateTimePicker Control The ListView Control Using Variables Variables Virtual Methods Visual Studio
Copyright ©2023. Compitionpoint
  • Home
  • C#
  • .Net
  • ADO.NET
  • LINQ .Net
  • Windows Form
  • Python

Mesocolumn Theme by Dezzain