Online Tutorials & Training Materials | STechies.com
Register Login

Home » Oracle

Oracle

In the past few years, SAP and Oracle have worked in a coordinated way to provide their customers with the popular SAP Oracle environment, with SAP applications sitting atop the Oracle database. With many reliable tools and techniques in place, Oracle has been providing long term and dedicated support to SAP users in the contemporary scenario and in many more ways than one.

SAP Oracle Course

Scope and Opportunity of a Career in SAP Oracle

Become a Certified SAP Oracle Professional

Basic Qualifications Required for the Course

    Tutorials

    • Difference between Oracle 10g and 11g and 12c DatabaseDifference between Oracle 10g and 11g and 12c Database
      What is Oracle 10g? Oracle 10g is a computing product group belonging to Oracle's grid. Along with other tools and features, Oracle 10g provides an application server and a database management ...

    • Error ORA-28001: the password has expired, during System StartupError ORA-28001: the password has expired, during System Startup
      you are getting this error because of resource PASSWORD_LIFE_TIME from the profile which is generally set to 180 days.To resolve the error please do as following:Check the database owner with the foll ...

    • Difference between Primary Index, Secondary Index and Clustered IndexDifference between Primary Index, Secondary Index and Clustered Index
      Primary Index vs. Secondary Index vs. Clustered IndexHello Experts,Is there any one who can tell me what is the exact difference between Primary index & Secondary index and clustered index?Please ...

    • Parameter Recommendations for Oracle 10g Optimal Configuration of the Oracle Database
      The following information contains SAP's recommendations for the optimal configuration of the Oracle database.For Oracle 9i or lower, refer to 124361 which referenced there.that the recommendations gi ...

    • BR*TOOLS and SAP DBA
      1. What are BR*TOOLS and SAPDBA?BR*TOOLS and SAPDBA are utility programs for Oracle administration that are developed by SAP. BR*TOOLS are increasingly replacing SAPDBA functions.2. What BR*TOOLS are ...

    • Difference between Oracle SIDs and SERVICE NAMES
      Oracle SIDs vs. Oracle SERVICE NAMESOracle SID is the unique name that uniquely identifies your instance/database where as Service name is the TNS alias that you give when you remotely connect to your ...

    • Oracle National Language Support (NLS)
      1. What is National Language Support? National Language Support (NLS) is necessary for the following tasks: Converting character sets between client and server Supporting different langua ...

    • List of Oracle Database 10g Patch Set
      10.2.0.2You must install at least Oracle patch set 10.2.0.2 if you want to use Oracle 10.2 in the SAP environment. In addition, apply the patches specified in this description. All patches currently r ...

    • SAP System under Microsoft Cluster Server (MSCS)
      This note contains a collection of the most frequently asked questions and problems during the installation and the operation of an SAP System under Microsoft Cluster Server (MSCS). 1. Message: T ...

    • ORA-01455: converting column overflows integer datatypeORA-01455: converting column overflows integer datatype
      ORA-01455 error in program SMIGR_CREATE_DDOn oracle database, while running the program SMIGR_CREATE_DD we get an error likes Error while creating DDSTORAGE entries for table <TABLE_NAME> Failed ...

    • Oracle Common MisConceptionsOracle Common MisConceptions
      Some widely accepted information about the Oracle database is shown not to be entirely correct upon closer examination.1. The Oracle cost-based optimizer always selects the access with the lowest calc ...

    • What is SAP Oracle, Course, Career and Certification?
      Definition - What is SAP Oracle?In the past few years, SAP and Oracle have worked in a coordinated way to provide their customers with the popular SAP/ Oracle environment, with SAP applications s ...

    • Difference Between Hot Backup and Cold BackupDifference Between Hot Backup and Cold Backup
      Hot Backup vs Cold BackupCold Backup Cold backup needs to shut down your system which makes your system unavailable Therefore It is recommended to schedule cold backups during off-peak hours. All the ...

    • JDBC Channel Characterset: How to Set Characterset Field?
       Suppose! You are using JDBC Channel in SAP to make a better communication. You are trying to insert Chinese characters in the table. You are using ECC to Oracle DB (Data Base). The chacterset on ...

    • What does 'SNIPED' status in v$session mean?
      When IDLE_TIME is set in the users' profiles or the default profile. This will kill the sessions in the database (status in v$session now becomes SNIPED) and they will eventually disconnect. It does n ...

    • How to find the datafile which contains a particular table?
      If you query DBA_EXTENTS based on segment_name equal to your table name you will see that the column FILE_ID will show you the database file where each extent is located. You can then use FILE_ID to q ...

    • Upgrade the Database Using the Database Upgrade Assistant (DBUA).Upgrade the Database Using the Database Upgrade Assistant (DBUA).
      Upgrade the Database Using the Database Upgrade Assistant (DBUA). 1) Set the ORACLE_HOME, ORACLE_BASE, PATH environmental variable to Oracle10g accordingly. 2) Start the Database Upgrade Assistant f ...

    • SAP data archiving and GDPdU
      Solution 1. Definition of the term: How is the term "archiving" used in the context of the GDPdU? The term "archiving" is very frequently used with different meanings in discussio ...

    • Deleting duplicate rows in the table
      I am searching for a way to delete the duplicate records in a table.. Is anybody having efficient way to do it..? The command is: DELETE <duplicate_col_name> dv FROM <table_ ...

    • Perform Consistency check of ORACLE database
      How to Perform Consistency check of ORACLE database?Consistency check is used from time to time for a complete confirmation that there is no corruption in a complete database and also to discover any ...