- 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 ...
- 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 ...
- Difference Between Oracle 10g and 11g and 12c
Oracle 10g vs 11g vs 12cHello Oracle Experts,What are 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. ...
- 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 ...
- 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 ...
- 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/ ...
- 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 ...
- 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! ...
- 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 ...
- 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 ...
- 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 ...
- 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. ...
- 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. ...
- 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 ...
- 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 ...
- 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 ...
- What is Difference between CRSCTL and SRVCTL ?
Hello Experts, May I know What is difference between CRSCTL and SRVCTL ? Please share your views. Thanks in advance. ...
- 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 ...
Oracle » | By: Abhijeet Mudgal | 17 Mar 2015 | 10024 viewed | Comments (20)
Oracle » | By: Rob Aaldijk | 08 May 2009 | 6359 viewed | Comments (1)
Oracle » | By: Sugandh | 07 Oct 2014 | 6337 viewed | Comments (2)
Oracle » | By: Sugandh | 03 Mar 2015 | 6155 viewed | Comments (4)
Oracle » | By: Abhijeet Mudgal | 15 Jan 2015 | 5581 viewed | Comments (1)
Oracle » | By: Sugandh | 01 Oct 2015 | 5267 viewed | Comments (1)
Oracle » | By: amit butola | 25 Jun 2013 | 3989 viewed | Comments (2)
Oracle » | By: | 13 Apr 2009 | 3798 viewed | Comments (6)
Oracle » | By: Sugandh | 07 Sep 2015 | 3654 viewed | Comments (3)
Oracle » | By: Abhijeet Mudgal | 17 Mar 2015 | 3621 viewed | Comments (10)
Oracle » | By: amit butola | 01 Jul 2013 | 3183 viewed | Comments (7)
Oracle » | By: Shalesh Singh Visen | 20 Aug 2009 | 3130 viewed | Comments (1)
Oracle » | By: Shalesh Singh Visen | 27 Nov 2009 | 3055 viewed | Comments (0)
Oracle » | By: Sugandh | 27 Feb 2015 | 2901 viewed | Comments (1)
Oracle » | By: Sugandh | 23 Apr 2015 | 2853 viewed | Comments (1)
Oracle » | By: Sugandh | 30 Oct 2015 | 2762 viewed | Comments (1)
Oracle » | By: amit butola | 27 Aug 2013 | 2761 viewed | Comments (2)
Oracle » | By: Sugandh | 26 Mar 2015 | 2582 viewed | Comments (1)
Oracle » | By: Abhijeet Mudgal | 11 May 2015 | 2579 viewed | Comments (2)
Oracle » | By: Sugandh | 17 Mar 2015 | 2520 viewed | Comments (14)