Oracle 12c Installation – Troubleshooting on Windows 8

database-designerrorsoracle

I'm currently trying to install Oracle 12C on a Windows 8 machine.

When I am executing the Data Base Configuration Assistant, I get to the Progress Page step where the the Installation Steps are running, and I get an error thrown on the Creating Pluggable Databases step:

Below are the settings I have used so far:

Launch setup.exe file

The Configure Security Updates window opens. Leave the Email and Password empty then click [Next].
Select, Yes to the pop-up "Do you wish to remain uninformed of critical security issues in your configuration"
The Select Installation Option window opens. Select Install database software only, and then click [Next].
The Grid Installation Options window opens. Select Single instance database installation, and then click [Next].
The Select Database Edition window opens. Select Enterprise Edition, and then click [Next].
In the Specify Oracle Home User window, select the windows account to run the Oracle services. Oracle recommends using a non-Administrator Windows user. Click [Next].
The Specify Installation Location window opens. Modify the Oracle Base to match the Oracle Base specified for the Live database in Step 1: Pre-Installation Planning on page 14, and then
click [Next].
The Prerequisite Checks window opens, followed by the Summary window.
a. Verify that the requirements are met, as shown in the Summary window.
b. Click [Install]. The installation progress is shown in the Install Product window.
Note: The installation process might take several minutes or more, depending on your system
resources.
The Finish window opens. Click [Close].

Configure the Live Database Home Net Configuration

Start the Net Configuration Assistant from the database Oracle Home.
The Net Configuration Assistant Welcome window opens.
a. Confirm that the Listener configuration radio button is selected.
b. Click [Next].
The Listener window opens.
a. Select the Add radio button.
b. Click [Next].
The Listener Name window opens.
a. Confirm that the Listener name is LISTENER.
b. If using a non-Windows Built-in user, then enter the Oracle Home User password.
c. Click [Next].
The Select Protocols window opens.
a. Confirm that TCP is a selected protocol.
b. Click [Next].
The TCP/IP Protocol window opens.
a. Select the Use the standard port number of 1521 radio option.
b. Click [Next].
The More Listeners window opens.
a. Confirm that the No radio button is selected.
b. Click [Next].
The Listener Configuration Done window opens. Click [Next].
The Oracle Net Configuration Assistant: Welcome window opens.
a. Select the Naming Methods configuration radio button.
b. Click [Next].
The Select Naming Methods window opens.
a. In the Available Naming Methods list, select Easy Connect Naming.
b. Click the right arrow button.
c. Repeat steps a and b for Local Naming.
d. Click [Next].
The Naming Methods Configuration Done window opens. Click [Next].
Click [Finish].

Configuring the Live Database

Start the Database Configuration Assistant from the database Oracle Home.
For more information, refer to “Using OnGuard on Supported Operating Systems” in the
Installation Guide.
The Database Operations window opens.
a. Verify the Create Database radio button is selected.
b. Click [Next].
Installing and Configuring Oracle 12c Release 1 Server Software
18 Advanced Installation Topics
Note: The Configure Database Options, Manage Pluggable Databases, and Delete
Database options are enabled only if you have an existing database.
The Creation Mode window opens.
a. Select the Advanced Mode radio button.
b. Click [Next].
The Database Template window opens.
a. Select the Custom Database radio button.
b. Click [Next]
Note: Selecting a template that does not include datafiles gives you full control to specify and
change additional database parameters.
In the Database Identification window, specify the Global Database Name.
a. Type LnlLive. or just LnlLive (depending on
whether your database server is in a domain or part of a workgroup) in the Global Database
Name field.
b. Click [Next].
Note: The Oracle System Identifier (SID) populates automatically with the first 12
alphanumeric characters.
The Management Options window opens. Select the Configure Enterprise Manager (EM)
Database Express check box and then click [Next].
The Database Credentials window opens. Type the administrative password(s) you would like for
the different accounts, enter the Oracle Home User Password, and then click [Next].
On the Network Configuration window, select the Listener configured previously and then click
[Next].
The Storage Locations window opens. Choose the storage, recovery, and file locations, and then
click [Next].
Note: The Enable Archiving recovery option is not related to the new OnGuard database
archiving feature.
The Database Options window opens.
a. Deselect all database components.
b. Click [Next].
The Initialization Parameters window opens. Leave the default settings on the Memory, Sizing,
Character Sets, and Connection Mode tabs, and then click [Next].
The Creation Options window opens. Ensure the Create Database check box is selected, then
select the Customize Storage Locations button.
a. In the Customize Storage window, rename the following tablespaces per the following table.
b. Select the tablespace to rename.
c. Enter the new tablespace name in the Name field.
d. Update the Size field, entering the new size.
e. Click [Apply] before selecting the next tablespace to modify.
f. Click [OK] when done with all modifications.
Advanced Installation Topics 19
Oracle 12c Release 1 Server Software Installation and Configuration
The following table identifies the necessary tablespace names and recommended minimum sizes.
Note: You can specify other names in the Name field. If you do, you must set the
defDataSpace variable to the new Name. For more information, refer to Step 9:
Prepare the User Scripts on page 21.
After Create Options configuration is complete, click [Next].
The Pre Requisite Checks window opens. If the checks pass, then it automatically transitions to
the Summary window. Confirm the configuration, and then click [Finish].
The Progress Page is shown. This might take over 5 minutes depending on system resources.

It is at this final step that the installation stops, and throws the error below:

Any information,resources, or websites as to why I may be having this error would be greatly appreciated. I am currently stuck on this for the past 2 days and no one seems to be able to give me assistance.

Best Answer

Is this DBCA 12.2, and are you creating a new CDB in which you've changed a tablespace name? If so, this is a known issue:

When creating a new CDB database with PDB by using DBCA, "Index: 0, Size: 0" or "datafile size : 0" is caused and creating DB is failed.

For more info click here: DBCA 12.2 is failed by "Index: 0, Size: 0" (Doc ID 2307680.1)

Solution:

Please change the name of tablespace after creating a database by dbca.

Related Solutions

Linux – Add Oracle Label Security to an existing Oracle installation

Just guesswork, but do you select "Upgrade an existing database" early on:

upgrade

and "advanced install" later on:

enter image description here

The docs do look as if they are referring to the 10g installer.

Linux – Oracle Database 12c on Oracle Linux 7 – autostart, enabling connection as sysdba

Based on my own research, google results and ansible's answer, I was able to come up with complete solution for Oracle Linux 7. Everytime you read Kitet - this is my Oracle Instance SID.

To start or stop database, dbstart and dbshut scripts are used respectively. They are located in $ORACLE_HOME/bin. Both of them need a parameter, which is $ORACLE_HOME. If there's no $ORACLE_HOME environment variable, first there's a need to set it (and some more) by running

. /usr/local/bin/oraenv

(note the preceding period, and it's not $ORACLE_HOME/bin/oraenv). Oraenv script will ask for a SID, which is needed to set correct $ORACLE_BASE. With this, using simply

dbstart $ORACLE_HOME

dbshut $ORACLE_HOME

will start and stop the listener and database.

To start listener using lsnrctl or start SQL*Plus using sqlplus / as sysdba, running . oraenv beforehand is also required, unless user wants to set manually some environment variables. If our linux box has only one instance, there's a possibility of automating running of . oraenv by editing user's bash profile. Enter

nano ~/.bash_profile

and type following lines (there's probably already umask 022 entry in this file, as per Oracle Database Installation Guide 12c Release 1 for Linux E41491-10):

export ORACLE_SID=Kitet
export ORAENV_ASK=NO
. /usr/local/bin/oraenv
export NLS_LANG=POLISH_POLAND.AL32UTF8
unicode_start

Line one and three are self explanatory. Line two will make oraenv not ask for database SID and use exported variable. Line four is optional and will set your language preference for client connections (e.g. SQL*Plus or lsnrctl will speak in your native language, if available). Line five is needed for console to display accented characters, and is also optional.

Automating startup and shutdown of Listener and Database

1) Once the instance is created, edit the /etc/oratab file setting the restart flag for each instance to 'Y'. My line is as follows:

Kitet:/home/oracle/app/oracle/product/12.1.0/dbhome_1:Y

2) Next, create a file called /etc/init.d/dbora as the root user, containing the following:

#!/bin/sh
# chkconfig: 345 99 10
# description: Oracle auto start-stop script.
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the 
# Oracle database in ORA_HOME.

# path to oracle home (needed only to check if dbstart exists)
ORA_HOME=/home/oracle/app/oracle/product/12.1.0/dbhome_1
# this is the user who installed oracle
ORA_OWNER=oracle

if [ ! -f $ORA_HOME/bin/dbstart ]
then
    echo "Oracle startup: cannot start"
    exit
fi

case "$1" in
    'start')
        # Start the Oracle database and listener:
        # Remove "&" if you don't want startup as a background process.
        export ORACLE_SID=Kitet
        export ORAENV_ASK=NO
        . /usr/local/bin/oraenv
        # at this point we have $ORACLE_HOME env variable set
        su $ORA_OWNER -c "dbstart $ORACLE_HOME" &
        touch /var/lock/subsys/dbora
        ;;
    'stop')
        # Stop the Oracle database and listener:
        export ORACLE_SID=Kitet
        export ORAENV_ASK=NO
        . /usr/local/bin/oraenv
        su $ORA_OWNER -c "dbshut $ORACLE_HOME"
        rm -f /var/lock/subsys/dbora
        ;;
esac

3) Use the chmod command to set the privileges to 750:

chmod 750 /etc/init.d/dbora

4) Associate the dbora service with the appropriate run levels and set it to auto-start using the following command:

chkconfig --add dbora

That's all. dbstart and dbshut should write to their respective logs at $ORACLE_HOME/startup.log and $ORACLE_HOME/shutdown.log. There also is $ORACLE_HOME/listener.log. There we can verify if and how instance and listener started and stopped. We could also use ps -ax | grep ora or ps -ax | grep lsnr to see if listener / oracle are running.

Best Answer

Related Solutions

Linux – Add Oracle Label Security to an existing Oracle installation

Linux – Oracle Database 12c on Oracle Linux 7 – autostart, enabling connection as sysdba

Related Question