- How to Solve the Error ORA-10458: Standby Database Requires Recovery?
Hello DBA Experts,Can anyone help me to solve the following query faced me:SQL> startup mount;ORACLE instance started.Total System Global Area 1140850688 bytesFixed Size 2923584 bytesVariable Size ...
- Difference between Oracle 10g and 11g and 12c Database
Oracle 10g vs 11g vs 12cHello Oracle Experts,What are the differences between oracle 10g and 11g and 12c?Answer will be appreciable. ...
- How does Update Statement Works in Architecture Level?
Hello Experts, I have this query How does update statement works in architecture level? please share your valuable thoughts. ...
- Configuring Content Server to use a File System or Alternative Database Technologies
With Kpro, the opportunity exists to manage electronic documents of different formats within a content repository, using the content server functionality. After installing and configuring content serv ...
- Importing Multiple Schema to Another User using IMPDP
Oracle IMPDP remap_schemaHello Experts,May I know that How to import multiple schemas to another user using impdp.I have tried like impdp directory = dtpdir dumpfile=schema.dmp logfile=schema.log ...
- PLS-00352: Unable to Access another Database 'DB_LINK_NAME'
Hello all, Please check procedure and suggest how to resolve it? Procedure: create or REPLACE PROCEDURE hostname (host_name in varchar2,user_name in VARCHAR2, pass_word in VARCHAR2,table_space ...
- How to Sum Salary Department Wise?
Hello Experts, Please tell me the solution that how to sum salary department wise as per image: Thanks in Advance! ...
- Any Script to Check the Status of Gather stats of a Table/Schema in Percentage (%).
Hello Experts,Please update me if anybody have any script to check the status of gather stats of a table/schema in percentage (%).Kindly share your valuable views as soon as possible. This is very urg ...
- ORA-02021: DDL Operations Are Not Allowed On a Remote Database
Hi, I am getting following error when I try to create a table in remote database. ORA-02021: DDL operations are not allowed on a remote database What privileges do we have to provide to the loc ...
- How to apply Oracle Archive file on a Open Database
Dear SAP Gurus, Could any one tell me that how can I apply oracle archived files on a opened database The whole scanario is as follows 1. A complete offline OS level backup of System SID (R/ ...
- Difference between Primary Index, Secondary Index and Clustered Index
Hello Experts,Is there any one who can tell me what is the exact difference between Primary index & Secondary index and clustered index?Please share your answers and help me out.Thanks in advance. ...
- How to Find ORACLE_BASE and ORACLE_HOME
I am new to Oracle; I'm learning the Oracle DBA stuffs. I would like to know how to find the $ORACLE_BASE and $ORACLE_HOME is any OS. Is there any command or script in Oracle which will tell these par ...
- Difference between TNS Connection and LDAP Connection.
Hello Experts, My Query is about What is difference between TNS Connection and LDAP Connections? Need a proper answer for the above. thanks in advance. ...
- Oracle in No Mount, Mount and Open state
kindly explain the difference between oracle in nomount mount and open state what is the difference between the abov ...
- Impdp Multiple Dump Files in Oracle 11G Standard Edition
Hi friends, I am facing issue while importing multiple dump files in Oracle 11G Standard Edition. I did export using expdp with parameter filesize and 5 files of 10Gb are created. But when I ...
- Configuration of Single Sign On (SSO) from SAP CE 7.01 Portal to Oracle E-Business Suite
Hi Team, Can anybody help me for the below requirement: Requirement : Configuration of Single Sign On (SSO) from SAP CE 7.01 Portal to Oracle E-Business Suite 12.1.1 which is having a Web ...
- How to solve Tablespace Full Issue?
Hi All, I have a tablespace full issue in my environment. Some are saying adding datafiles is good, some are saying resizing datafiles is good. I am totally got stucked and not able to choose which ...
- Difference between CRSCTL and SRVCTL
CRSCTL vs. SRVCTLHello Experts,May I know What is difference between CRSCTL and SRVCTL ?Please share your views.Thanks in advance. ...
- Oracle DBA Interviews Question Asked By WIPRO
Hello Experts,1) In DG stand_file_management=manual what is the meaning of this parameter?2) We can restore the backup in the same mount point by using RMAN,but my backup is in another MOUNT point how ...
- Warning:You are no longer connected to ORACLE.
Hello Experts,How to fix this problemSQL> conn sys/sys@db11g as sysdbaERROR:ORA-12154: TNS:could not resolve the connect identifier specifiedWarning: You are no longer connected to ORACLE.SQL> c ...
Oracle » | By: Abhijeet Mudgal | 17 Mar 2015 | Comments (20)
Oracle » | By: Sugandh | 07 Oct 2014 | Comments (2)
Oracle » | By: Sugandh | 03 Mar 2015 | Comments (4)
Oracle » | By: Rob Aaldijk | 08 May 2009 | Comments (1)
Oracle » | By: Sugandh | 01 Oct 2015 | Comments (1)
Oracle » | By: Abhijeet Mudgal | 15 Jan 2015 | Comments (1)
Oracle » | By: Abhijeet Mudgal | 17 Mar 2015 | Comments (10)
Oracle » | By: Sugandh | 07 Sep 2015 | Comments (3)
Oracle » | By: amit butola | 25 Jun 2013 | Comments (2)
Oracle » | By: | 13 Apr 2009 | Comments (6)
Oracle » | By: Sugandh | 23 Apr 2015 | Comments (1)
Oracle » | By: amit butola | 01 Jul 2013 | Comments (7)
Oracle » | By: Sugandh | 27 Feb 2015 | Comments (1)
Oracle » | By: Shalesh Singh Visen | 20 Aug 2009 | Comments (1)
Oracle » | By: amit butola | 27 Aug 2013 | Comments (2)
Oracle » | By: Shalesh Singh Visen | 27 Nov 2009 | Comments (0)
Oracle » | By: Sugandh | 17 Mar 2015 | Comments (14)
Oracle » | By: Abhijeet Mudgal | 11 May 2015 | Comments (2)
Oracle » | By: Sugandh | 30 Oct 2015 | Comments (1)
Oracle » | By: Sugandh | 26 Mar 2015 | Comments (1)