Oracle Database Setup/Configuration Issues and Resolutions

By February 28, 2019 7 min read Oracle - ERP

1) Error No: INS-30131 Initial Setup for Oracle 12C in Windows 10

While performing setup of DB, we may face above error-INS-30131, please find the below screenshot for the same.

control M

Solution:

  • Go to Start, Type CMD
  • Get the exact path where the setup.exe present and run the below command to install the DB.

            setup.exe -ignorePrereq -J”-Doracle.install.db. validate.supportedOSCheck=false”

2) Oracle Data base configuration Error

  • Error due to Improper ZIP File Extraction – Error is INS – 20802 oracle database configuration assistant failed.
control M

Note: Click on details Option then It will Show Some Zip Files Are Missing.we need to Re Extract All the Files in Oracle DB Software(Source File).

  • If you are not Extracting in Proper way will face errors in Data Base Configuration as Shown in Below Screen Shot
control M
  • We have 2 extract files in the source we have to download the 2 extract files. Then we need to extract the 2 files in 1 Folder

          Please find the below-extracted files

  • winx64_12c_database_1of2
  • winx64_12c_database_2of2

3) DB details missing in TNSora file
Edit the TNS file which is located in the path ..\app\Oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN\SAMPLE, we need to add the missing DB details in The TNSNames.ora file as mentioned in below format.
            ORCLPDB =
          (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
         (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = orclpdb)
       )
       )