Home » Infrastructure » Windows » Installing Oracle 12c (Windows 8)
icon5.gif  Installing Oracle 12c [message #652666] Wed, 15 June 2016 21:39 Go to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
hi friend, good day.
i am a beginner in this field and installed Oracle 12c in my laptop for self study.
unfortunately i have encountered some errors along the installation. i just click "Continue"
for me to push through, but i was stuck at 69% of the installation process its been 5 hours
and no movement from the 69% of progress. yo may view the image here: http://imgur.com/rMOa6yx
looking forward for some help
thanks a lot
/forum/fa/13166/0/


[mod-edit: image inserted into message body by bb]

[Updated on: Wed, 15 June 2016 21:49] by Moderator

Report message to a moderator

Re: Installing Oracle 12c [message #652667 is a reply to message #652666] Wed, 15 June 2016 22:08 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
Are you using Windows 8 Home Edition? Oracle requires Professional or Enterprise Edition.

Did you run the installation using an operating system user that has administrator privileges, as required?

Did you encounter any other errors other than the file not found errors shown?

Can you locate and post the installation log?

Please click on the link below for a section of the Oracle online documentation on Troubleshooting the Oracle Database Installation.

https://docs.oracle.com/database/121/NTDBI/ts.htm#NTDBI012

[Updated on: Wed, 15 June 2016 22:11]

Report message to a moderator

Re: Installing Oracle 12c [message #652668 is a reply to message #652667] Wed, 15 June 2016 22:28 Go to previous messageGo to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
hi Barbara,

Thanks for your response,

I am using windows 8.1 single language, only the errors that was in screenshot was the
only issue i encountered,

below is the db.rsp that I got from the installation:

####################################################################
## Copyright(c) Oracle Corporation 1998,2014. All rights reserved.##
##                                                                ##
## Specify values for the variables listed below to customize     ##
## your installation.                                             ##
##                                                                ##
## Each variable is associated with a comment. The comment        ##
## can help to populate the variables with the appropriate        ##
## values.                                                        ##
##                                                                ##
## IMPORTANT NOTE: This file contains plain text passwords and    ##
## should be secured to have read permission only by oracle user  ##
## or db administrator who owns this installation.                ##
##                                                                ##
####################################################################


#-------------------------------------------------------------------------------
# Do not change the following system generated value. 
#-------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0

#-------------------------------------------------------------------------------
# Specify the installation option.
# It can be one of the following:
#   - INSTALL_DB_SWONLY
#   - INSTALL_DB_AND_CONFIG
#   - UPGRADE_DB
#-------------------------------------------------------------------------------
oracle.install.option=INSTALL_DB_SWONLY

#-------------------------------------------------------------------------------
# Specify the hostname of the system as set during the install. It can be used
# to force the installation to use an alternative hostname rather than using the
# first hostname found on the system. (e.g., for systems with multiple hostnames 
# and network interfaces)
#-------------------------------------------------------------------------------
ORACLE_HOSTNAME=EPLDT-PC

#-------------------------------------------------------------------------------
# Specify the Unix group to be set for the inventory directory.  
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=
#-------------------------------------------------------------------------------
# Specify the languages in which the components will be installed.             
# 
# en   : English                  ja   : Japanese                  
# fr   : French                   ko   : Korean                    
# ar   : Arabic                   es   : Latin American Spanish    
# bn   : Bengali                  lv   : Latvian                   
# pt_BR: Brazilian Portuguese     lt   : Lithuanian                
# bg   : Bulgarian                ms   : Malay                     
# fr_CA: Canadian French          es_MX: Mexican Spanish           
# ca   : Catalan                  no   : Norwegian                 
# hr   : Croatian                 pl   : Polish                    
# cs   : Czech                    pt   : Portuguese                
# da   : Danish                   ro   : Romanian                  
# nl   : Dutch                    ru   : Russian                   
# ar_EG: Egyptian                 zh_CN: Simplified Chinese        
# en_GB: English (Great Britain)  sk   : Slovak                    
# et   : Estonian                 sl   : Slovenian                 
# fi   : Finnish                  es_ES: Spanish                   
# de   : German                   sv   : Swedish                   
# el   : Greek                    th   : Thai                      
# iw   : Hebrew                   zh_TW: Traditional Chinese       
# hu   : Hungarian                tr   : Turkish                   
# is   : Icelandic                uk   : Ukrainian                 
# in   : Indonesian               vi   : Vietnamese                
# it   : Italian                                                   
#
# all_langs   : All languages
#
# Specify value as the following to select any of the languages.
# Example : SELECTED_LANGUAGES=en,fr,ja
#
# Specify value as the following to select all the languages.
# Example : SELECTED_LANGUAGES=all_langs  
#-------------------------------------------------------------------------------
SELECTED_LANGUAGES=en

#-------------------------------------------------------------------------------
# Specify the complete path of the Oracle Home. 
#-------------------------------------------------------------------------------
ORACLE_HOME=C:\app\EPLDT\product\12.1.0\dbhome_2

#-------------------------------------------------------------------------------
# Specify the complete path of the Oracle Base. 
#-------------------------------------------------------------------------------
ORACLE_BASE=C:\app\EPLDT

#-------------------------------------------------------------------------------
# Specify the installation edition of the component.                     
#                                                             
# The value should contain only one of these choices.  
      
#   - EE     : Enterprise Edition 

#-------------------------------------------------------------------------------
oracle.install.db.InstallEdition=EE

###############################################################################
#                                                                             #
# PRIVILEGED OPERATING SYSTEM GROUPS                                          #
# ------------------------------------------                                  #
# Provide values for the OS groups to which OSDBA and OSOPER privileges       #
# needs to be granted. If the install is being performed as a member of the   #
# group "dba", then that will be used unless specified otherwise below.       #
#                                                                             #
# The value to be specified for OSDBA and OSOPER group is only for UNIX based #
# Operating System.                                                           #
#                                                                             #
###############################################################################

#------------------------------------------------------------------------------
# The DBA_GROUP is the OS group which is to be granted OSDBA privileges.
#-------------------------------------------------------------------------------
oracle.install.db.DBA_GROUP=

#------------------------------------------------------------------------------
# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.
# The value to be specified for OSOPER group is optional.
#------------------------------------------------------------------------------
oracle.install.db.OPER_GROUP=

#------------------------------------------------------------------------------
# The BACKUPDBA_GROUP is the OS group which is to be granted OSBACKUPDBA privileges.
#------------------------------------------------------------------------------
oracle.install.db.BACKUPDBA_GROUP=

#------------------------------------------------------------------------------
# The DGDBA_GROUP is the OS group which is to be granted OSDGDBA privileges.
#------------------------------------------------------------------------------
oracle.install.db.DGDBA_GROUP=

#------------------------------------------------------------------------------
# The KMDBA_GROUP is the OS group which is to be granted OSKMDBA privileges.
#------------------------------------------------------------------------------
oracle.install.db.KMDBA_GROUP=

###############################################################################
#                                                                             #
#                               Grid Options                                  #
#                                                                             #
###############################################################################
#------------------------------------------------------------------------------
# Specify the type of Real Application Cluster Database
# 
#   - ADMIN_MANAGED: Admin-Managed
#   - POLICY_MANAGED: Policy-Managed
# 
# If left unspecified, default will be ADMIN_MANAGED 
#------------------------------------------------------------------------------
oracle.install.db.rac.configurationType=

#------------------------------------------------------------------------------
# Value is required only if RAC database type is ADMIN_MANAGED
# 
# Specify the cluster node names selected during the installation.
# Leaving it blank will result in install on local server only (Single Instance)
# 
# Example : oracle.install.db.CLUSTER_NODES=node1,node2
#------------------------------------------------------------------------------
oracle.install.db.CLUSTER_NODES=

#------------------------------------------------------------------------------
# This variable is used to enable or disable RAC One Node install.
#
#   - true  : Value of RAC One Node service name is used.
#   - false : Value of RAC One Node service name is not used.
#
# If left blank, it will be assumed to be false.
#------------------------------------------------------------------------------
oracle.install.db.isRACOneInstall=false

#------------------------------------------------------------------------------
# Value is required only if oracle.install.db.isRACOneInstall is true.
# 
# Specify the name for RAC One Node Service
#------------------------------------------------------------------------------
oracle.install.db.racOneServiceName=

#------------------------------------------------------------------------------
# Value is required only if RAC database type is POLICY_MANAGED
# 
# Specify a name for the new Server pool that will be configured
# Example : oracle.install.db.rac.serverpoolName=pool1
#------------------------------------------------------------------------------
oracle.install.db.rac.serverpoolName=

#------------------------------------------------------------------------------
# Value is required only if RAC database type is POLICY_MANAGED
# 
# Specify a number as cardinality for the new Server pool that will be configured
# Example : oracle.install.db.rac.serverpoolCardinality=2
#------------------------------------------------------------------------------
oracle.install.db.rac.serverpoolCardinality=0

###############################################################################
#                                                                             #
#                        Database Configuration Options                       #
#                                                                             #
###############################################################################

#-------------------------------------------------------------------------------
# Specify the type of database to create.
# It can be one of the following:
#   - GENERAL_PURPOSE                       
#   - DATA_WAREHOUSE 
# GENERAL_PURPOSE: A starter database designed for general purpose use or transaction-heavy applications.
# DATA_WAREHOUSE : A starter database optimized for data warehousing applications.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE

#-------------------------------------------------------------------------------
# Specify the Starter Database Global Database Name. 
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.globalDBName=

#-------------------------------------------------------------------------------
# Specify the Starter Database SID.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.SID=

#-------------------------------------------------------------------------------
# Specify whether the database should be configured as a Container database.
# The value can be either "true" or "false". If left blank it will be assumed
# to be "false".
#-------------------------------------------------------------------------------
oracle.install.db.ConfigureAsContainerDB=false

#-------------------------------------------------------------------------------
# Specify the  Pluggable Database name for the pluggable database in Container Database.
#-------------------------------------------------------------------------------
oracle.install.db.config.PDBName=

#-------------------------------------------------------------------------------
# Specify the Starter Database character set.
#                                               
#  One of the following
#  AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,
#  EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,
#  BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,
#  AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,
#  IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,
#  KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,
#  ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.characterSet=

#------------------------------------------------------------------------------
# This variable should be set to true if Automatic Memory Management 
# in Database is desired.
# If Automatic Memory Management is not desired, and memory allocation
# is to be done manually, then set it to false.
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.memoryOption=false

#-------------------------------------------------------------------------------
# Specify the total memory allocation for the database. Value(in MB) should be
# at least 256 MB, and should not exceed the total physical memory available 
# on the system.
# Example: oracle.install.db.config.starterdb.memoryLimit=512
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.memoryLimit=

#-------------------------------------------------------------------------------
# This variable controls whether to load Example Schemas onto
# the starter database or not.
# The value can be either "true" or "false". If left blank it will be assumed
# to be "false".
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.installExampleSchemas=false

###############################################################################
#                                                                             #
# Passwords can be supplied for the following four schemas in the	      #
# starter database:      						      #
#   SYS                                                                       #
#   SYSTEM                                                                    #
#   DBSNMP (used by Enterprise Manager)                                       #
#                                                                             #
# Same password can be used for all accounts (not recommended) 		      #
# or different passwords for each account can be provided (recommended)       #
#                                                                             #
###############################################################################

#------------------------------------------------------------------------------
# This variable holds the password that is to be used for all schemas in the
# starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.ALL=

#-------------------------------------------------------------------------------
# Specify the SYS password for the starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.SYS=

#-------------------------------------------------------------------------------
# Specify the SYSTEM password for the starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.SYSTEM=

#-------------------------------------------------------------------------------
# Specify the DBSNMP password for the starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.DBSNMP=

#-------------------------------------------------------------------------------
# Specify the PDBADMIN password required for creation of Pluggable Database in the Container Database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.PDBADMIN=

#-------------------------------------------------------------------------------
# Specify the management option to use for managing the database.
# Options are:
# 1. CLOUD_CONTROL - If you want to manage your database with Enterprise Manager Cloud Control along with Database Express.
# 2. DEFAULT   -If you want to manage your database using the default Database Express option.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.managementOption=DEFAULT

#-------------------------------------------------------------------------------
# Specify the OMS host to connect to Cloud Control.
# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.omsHost=

#-------------------------------------------------------------------------------
# Specify the OMS port to connect to Cloud Control.
# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.omsPort=0

#-------------------------------------------------------------------------------
# Specify the EM Admin user name to use to connect to Cloud Control.
# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.emAdminUser=

#-------------------------------------------------------------------------------
# Specify the EM Admin password to use to connect to Cloud Control.
# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.emAdminPassword=

###############################################################################
#                                                                             #
# SPECIFY RECOVERY OPTIONS                                 	              #
# ------------------------------------		                              #
# Recovery options for the database can be mentioned using the entries below  #
#                                                                             #
###############################################################################

#------------------------------------------------------------------------------
# This variable is to be set to false if database recovery is not required. Else 
# this can be set to true.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.enableRecovery=false

#-------------------------------------------------------------------------------
# Specify the type of storage to use for the database.
# It can be one of the following:
#   - FILE_SYSTEM_STORAGE
#   - ASM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.storageType=

#-------------------------------------------------------------------------------
# Specify the database file location which is a directory for datafiles, control
# files, redo logs.         
#
# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE 
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=

#-------------------------------------------------------------------------------
# Specify the recovery location.
#
# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE 
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=

#-------------------------------------------------------------------------------
# Specify the existing ASM disk groups to be used for storage.
#
# Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.db.config.asm.diskGroup=

#-------------------------------------------------------------------------------
# Specify the password for ASMSNMP user of the ASM instance.                 
#
# Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE 
#-------------------------------------------------------------------------------
oracle.install.db.config.asm.ASMSNMPPassword= 

#----------------------------------------------------------------------------------------------
# Specify the Oracle Home user.                 
#
# Oracle recommends that you specify a Windows User Account with limited privilege to install 
# and configure a secure Oracle home. Set oracle.install.IsBuiltInAccount to true 
# if you want to use BuiltIn Account.
#
# Set oracle.install.IsBuiltInAccount to false if you want to use Windows Account user 
# as Oracle Home user. 
#------------------------------------------------------------------------------------------------
oracle.install.IsBuiltInAccount=true
oracle.install.OracleHomeUserName=
oracle.install.OracleHomeUserPassword=

#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username.
#
#  Example   : MYORACLESUPPORT_USERNAME=[email]abc@oracle.com[/email]
#------------------------------------------------------------------------------
MYORACLESUPPORT_USERNAME=[email]svmayol@gmail.com[/email]

#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username password.
#
# Example    : MYORACLESUPPORT_PASSWORD=password
#------------------------------------------------------------------------------
MYORACLESUPPORT_PASSWORD=

#------------------------------------------------------------------------------
# Specify whether to enable the user to set the password for
# My Oracle Support credentials. The value can be either true or false.
# If left blank it will be assumed to be false.
#
# Example    : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true
#------------------------------------------------------------------------------
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

#------------------------------------------------------------------------------
# Specify whether user doesn't want to configure Security Updates.
# The value for this variable should be true if you don't want to configure
# Security Updates, false otherwise.
#
# The value can be either true or false. If left blank it will be assumed
# to be false.
#
# Example    : DECLINE_SECURITY_UPDATES=false
#------------------------------------------------------------------------------
DECLINE_SECURITY_UPDATES=false

#------------------------------------------------------------------------------
# Specify the Proxy server name. Length should be greater than zero.
#
# Example    : PROXY_HOST=proxy.domain.com 
#------------------------------------------------------------------------------
PROXY_HOST=

#------------------------------------------------------------------------------
# Specify the proxy port number. Should be Numeric and at least 2 chars.
#
# Example    : PROXY_PORT=25
#------------------------------------------------------------------------------
PROXY_PORT=

#------------------------------------------------------------------------------
# Specify the proxy user name. Leave PROXY_USER and PROXY_PWD
# blank if your proxy server requires no authentication.
#
# Example    : PROXY_USER=username
#------------------------------------------------------------------------------
PROXY_USER=

#------------------------------------------------------------------------------
# Specify the proxy password. Leave PROXY_USER and PROXY_PWD  
# blank if your proxy server requires no authentication.
#
# Example    : PROXY_PWD=password
#------------------------------------------------------------------------------
PROXY_PWD=

#------------------------------------------------------------------------------
# Specify the Oracle Support Hub URL. 
# 
# Example    : COLLECTOR_SUPPORTHUB_URL=[url]https://orasupporthub.company.com:8080/[/url]
#------------------------------------------------------------------------------
COLLECTOR_SUPPORTHUB_URL=
Re: Installing Oracle 12c [message #652669 is a reply to message #652668] Wed, 15 June 2016 22:41 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
Are you using Windows 8 Home or Windows 8 Professional or what?

From your operating system control panel:

Control Panel\System and Security\System

Under Windows Edition, does it say Windows 8 Home or Windows 8 Professional or what?

[Updated on: Wed, 15 June 2016 22:43]

Report message to a moderator

Re: Installing Oracle 12c [message #652670 is a reply to message #652669] Wed, 15 June 2016 22:56 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
Please see the following thread where another person had the same file not found error during installation and see if the advice there helps.

http://www.orafaq.com/forum/t/199368/
Re: Installing Oracle 12c [message #652671 is a reply to message #652670] Wed, 15 June 2016 22:58 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
Here is a similar thread on another forum that may help.

https://g7schools.wordpress.com/2014/04/11/oracle-installation-stopped-at-59-fixing-missing-files/
Re: Installing Oracle 12c [message #652672 is a reply to message #652671] Wed, 15 June 2016 23:06 Go to previous messageGo to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
http://imgur.com/E2M5X3qhttp



[mod-edit: image link fixed by bb]

[Updated on: Wed, 15 June 2016 23:22] by Moderator

Report message to a moderator

Re: Installing Oracle 12c [message #652674 is a reply to message #652672] Wed, 15 June 2016 23:25 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
I had to fix your image link. I can now see the image.

I see what you mean about single language. I would have expected home or professional or some such thing to be there instead.

I think the last link that I posted has your problem and a solution. It has both the installation stopped at 59% and the missing files error
and the explanation and workaround makes sense.

https://g7schools.wordpress.com/2014/04/11/oracle-installation-stopped-at-59-fixing-missing-files/
Re: Installing Oracle 12c [message #652675 is a reply to message #652674] Wed, 15 June 2016 23:34 Go to previous messageGo to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
hi barbara,
i followed the solution on the link that you provided, now i encounter new error.

http://imgur.com/SJVqI9Y
Re: Installing Oracle 12c [message #652676 is a reply to message #652675] Wed, 15 June 2016 23:53 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
That error implies that your previous attempted installation is still running and both cannot run at the same time.

At this point, you might want to try uninstalling, re-starting your computer, and starting over fresh.

Aborted installations can leave a half-finished mess behind that can be hard to work around.
Re: Installing Oracle 12c [message #652692 is a reply to message #652666] Thu, 16 June 2016 06:45 Go to previous messageGo to next message
EdStevens
Messages: 863
Registered: September 2013
Senior Member
I have not followed all the links posted by Barbara, but let me ask the obvious ...
This error (file not found during installation) usually comes because you didn't unzip the two downloaded zip files into the same directory ...
So ... after you downloaded two zip files, did you unzip them into the SAME directory? By default, Windows doesn't like to do that, and throws up a warning so that you have to tell windows "yes, I know what I'm doing."
Re: Installing Oracle 12c [message #652715 is a reply to message #652692] Thu, 16 June 2016 19:50 Go to previous messageGo to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
hi all,

i have now successfully install the single instance (database software). i unzip both installer and copy some contents from folder 2
and paste it in folder 1. i followed the link given to barbara (https://g7schools.wordpress.com/2014/04/11/oracle-installation-stopped-at-59-fixing-missing-files/)

now i encountered another issue when i tried to create a database ( posted in this link: http://imgur.com/hC0eQlC )
plus my sql cannot be access the moment i click it. it wont show up.

thanks
Re: Installing Oracle 12c [message #652716 is a reply to message #652715] Thu, 16 June 2016 20:16 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
Did you use the default options to create a database during the installation or do a custom installation?

If you just did a standard installation, then there should be a database.
You may be able to access such a database through SQL*Plus and may have a separate issue with the configuration assistant.
I am using Windows 10 nowadays. It has been a long time since I used Windows 8, so I don't remember exactly how things were back then.
You should be able to click on start or something like that in the lower left corner of your screen.
Then scroll through your applications, find Oracle, find SQL*Plus and click on that. From there try:

CONNECT SYS AS SYSDBA

SELECT banner FROM v$version;

Please try those and post the results, then we can go from there, based on what you get.
If you can, please post a copy and paste into your reply here, instead of an image or a link to an image.
That makes it easier for everybody to read.


Re: Installing Oracle 12c [message #652717 is a reply to message #652716] Thu, 16 June 2016 20:39 Go to previous messageGo to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
hi barbara,

yes i use the default option to create a data base during installation.
i was just following the video tutorial entitle: infinite skills: learning oracle 12c by steve reis.

ihave created a shortcut of sqldeveloper.exe in my desktop but i cant open it.
i also have JRE installed so this has nothing to do with java problems
i checked in my control panel in the programs to see if there were orace and sql installed
but they are non existent in the running programs from control panel.

how do i check if i had the oracle Db installed?

thanks
Re: Installing Oracle 12c [message #652718 is a reply to message #652717] Thu, 16 June 2016 20:47 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
Don't use SQL Developer. Don't use the control panel.

Left click, not right, on the lower left Start, and find something like programs or all apps, look for Oracle,
then under that look for SQL*Plus. SQL*Plus might be under application development or something like that.

Click on SQL*Plus. It should open up a new window, then type:

CONNECT SYS AS SYSDBA

SELECT banner FROM v$version;

and copy and paste the results into your response in this thread.

The results should tell us if there is a database.
There may be other issues as to whether it is started and so forth.
There are other things that can be run from an operating system prompt,
but I think it is better to start with this.


[Updated on: Thu, 16 June 2016 20:48]

Report message to a moderator

Re: Installing Oracle 12c [message #652719 is a reply to message #652718] Thu, 16 June 2016 21:12 Go to previous messageGo to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
got it.

however . it requires user name and pw,
does the user name and pw is the one i was using during the installation?
or the one from my laptop?
what is protocol adapter error?

( http://imgur.com/jRoo5L9 )

thanks
Re: Installing Oracle 12c [message #652720 is a reply to message #652719] Thu, 16 June 2016 21:23 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
For user-name type:

SYS AS SYSDBA

Leave the password blank and just hit the enter key.

We need to see if you can get that far. If so, then we can see about connecting as another
user, such as the scott account. But first, we need to see if you can get that far.
You may need to start the listener and database and unlock the scott account.
Please see the brief demonstration below. Your prompt will probably just say

SQL>

as I have customized mine.

SQL*Plus: Release 12.1.0.2.0 Production on Thu Jun 16 19:17:27 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Enter user-name: SYS AS SYSDBA
Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SYS@orcl_12.1.0.2.0> SELECT banner FROM v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE    12.1.0.2.0      Production
TNS for 64-bit Windows: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production

5 rows selected.

SYS@orcl_12.1.0.2.0> ALTER USER scott IDENTIFIED BY tiger ACCOUNT UNLOCK;

User altered.

SYS@orcl_12.1.0.2.0> CONNECT scott/tiger
Connected.
SCOTT@orcl_12.1.0.2.0>
Re: Installing Oracle 12c [message #652721 is a reply to message #652720] Thu, 16 June 2016 21:38 Go to previous messageGo to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
im still hook on the error

http://imgur.com/2uNQYcn
Re: Installing Oracle 12c [message #652722 is a reply to message #652720] Thu, 16 June 2016 21:39 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
Since you got the protocol adapter error, I suspect that your database is not started.

For instructions on how to start the database see:

https://docs.oracle.com/database/121/NTQRF/admin.htm#NTQRF214

In the above instructions, they say to do this from the operating system command prompt, not from a SQL*Plus window.

So, you will need to find where the sqlplus.exe file is on your system. For example, here it is on my system:

C:\app\baboehme\product\12.1.0\dbhome_2\BIN>dir sqlplus.exe
 Volume in drive C is TI10716100D
 Volume Serial Number is 30B9-619B

 Directory of C:\app\baboehme\product\12.1.0\dbhome_2\BIN

08/01/2014  08:08 AM           941,056 sqlplus.exe
               1 File(s)        941,056 bytes
               0 Dir(s)  929,733,115,904 bytes free

C:\app\baboehme\product\12.1.0\dbhome_2\BIN>

The prompt above is where you need to start typing what the instructions say.
However, this assumes that you have an instance and the listener is started.
If you get some other error, such as the listener not being started,
then we will need to deal with that first.

[Updated on: Thu, 16 June 2016 21:43]

Report message to a moderator

Re: Installing Oracle 12c [message #652723 is a reply to message #652722] Thu, 16 June 2016 21:51 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
If you still get the error, then try starting the listener. Go to the same directory where you found sqlplus.exe and search for lsnrctl.exe.
At the operating system prompt, type:

lsnrctl

After that, type

start

C:\app\baboehme\product\12.1.0\dbhome_2\BIN>lsnrctl

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 16-JUN-2016 19:48:53

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL>start

Then try to start the database again.

Then try to use SQL*Plus again and connect as SYSDBA.

Then try to unlock the scott account and connect as scott.

[Updated on: Thu, 16 June 2016 21:54]

Report message to a moderator

Re: Installing Oracle 12c [message #652724 is a reply to message #652722] Thu, 16 June 2016 22:02 Go to previous messageGo to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
i am now going back in creating the DB.

while in the process. i notice that my Listener is down.
which gives me a hard time continuing. how can this be up?
it says failed to start listener when i click continue

http://imgur.com/VUJI9pk

Re: Installing Oracle 12c [message #652725 is a reply to message #652724] Thu, 16 June 2016 22:11 Go to previous messageGo to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
i tried this: C:\app\baboehme\product\12.1.0\dbhome_2\BIN>lsnrctl

but i was denied

http://imgur.com/BP3sdtH

thanks
Re: Installing Oracle 12c [message #652726 is a reply to message #652724] Thu, 16 June 2016 22:11 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
WAIT! DON'T DO THAT! YOU ALREADY HAD A DATABASE. YOU JUST NEEDED TO START THE LISTENER AND START THE DATABASE.

IF YOU START ALL OVER, YOU WILL BE CREATING A MESS.

I WAS JUST ABOUT TO POST AN EASIER METHOD OF STARTING THE LISTENER AND DATABASE AND MAKING THEM START AUTOMATICALLY,
WHEN YOU START YOUR COMPUTER. IN FACT, IF YOU HAD JUST RE-STARTED YOUR COMPUTER, THAT MIGHT HAVE HAPPENED.
Re: Installing Oracle 12c [message #652727 is a reply to message #652726] Thu, 16 June 2016 22:19 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
From

control panel -> system and security -> administrative tools -> services

You should see a bunch of things that start with Oracle.

You need to find OracleOraDB12Home1TNSListener or something similar that starts with Oracle and ends with Listener, click on it, then click start.
You can also set it to automatic.

Then you need to do the same thing with OracleServiceORCL or whatever yours is named.

Then you should be able to use SQL*Plus and connect as SYSDBA.

I hope you have not already re-started the database creation process.

I am going to dinner now and will be back later.. There should be others coming online shortly who can continue to help you in the meanwhile.
Re: Installing Oracle 12c [message #652728 is a reply to message #652727] Thu, 16 June 2016 23:04 Go to previous messageGo to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
hi barbara,

so far. i did not see any Listerner from the services of the administrative tools

only 1 Oracle service is present

http://imgur.com/bxoNLWK

i think im in a mess right now Smile
thanks
Re: Installing Oracle 12c [message #652729 is a reply to message #652728] Thu, 16 June 2016 23:49 Go to previous messageGo to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
hi barbara,
i dont know what happened but when i tired to double click sqldeveloper.exe from the database home directory it open up

http://imgur.com/g3gikFN

am i on the right path?

thanks
Re: Installing Oracle 12c [message #652730 is a reply to message #652728] Thu, 16 June 2016 23:52 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
That's definitely not good. At this point, I don't know what to tell you.
I am just a retired developer, not a DBA. There are other moderators and users
on this forum who are DBA's and some of them use Windows. Hopefully one of them
will be along to help you shortly. We have people in various time zones in
various parts of the world, so as soon as some of us go to bed, others are
just starting.

If you do start over, you should try to uninstall everything, so there won't be conflicts, then re-start your computer.

The following is the usual process for a normal installation:

Download the zip files for the database for your operating system.
Unzip the files in the same directory. As you have found, if you didn't do this,
then you can copy from one directory to the other.
Run the setup that uses the Oracle installer, responding to the prompts and noting any error messages.
In general use the defaults, installing the database, not just the client.
If it gives the option for automatic startup, select that.
When done, you may need to restart your computer.
Older versions of Windows make take a few minutes to start the listener and database.
Check through the services whether they are both started. The listener must be started first.
Start SQL*Plus. Connect as sysdba. Unlock and/or create accounts and set passwords.
Connect as scott or whatever user you have created.
Re: Installing Oracle 12c [message #652731 is a reply to message #652729] Fri, 17 June 2016 00:01 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
All that shows is that you can start SQL Developer, just like you can start SQL*Plus.
However, you can't do anything from either unless your listener and database are started.
Re: Installing Oracle 12c [message #652732 is a reply to message #652729] Fri, 17 June 2016 00:15 Go to previous messageGo to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
this is where i am now:

http://imgur.com/J6G6Fcb

but sadly i cant establish a connection.
it says network adapter cant establish connection

thanks
Re: Installing Oracle 12c [message #652734 is a reply to message #652732] Fri, 17 June 2016 00:51 Go to previous messageGo to next message
John Watson
Messages: 7187
Registered: January 2010
Location: Global Village
Senior Member
OK, I'll try to help. Though I really don't know that I can do better than Barbera.

First, some pre-requisites:

1. You need to learn how to use Windows. In this screenshot, http://imgur.com/BP3sdtH you have typed a directory path without a leading "\" and terminated by a ">" and followed by "lsnrctl". Windows is interpreting that as trying to execute a directory, which is impossible.
2. You need to follow the installation instructions provided by Oracle. It seems that you did not unzip both zip files into one directory. You unzipped them into separate directories, and then followed some advice here https://g7schools.wordpress.com/2014/04/11/oracle-installation-stopped-at-59-fixing-missing-files/ to copy just one directory.You may be missing lots of other files.
3. To create a database, you need to follow the instructions provided by Oracle, not whatever you found in "following the video tutorial entitle: infinite skills: learning oracle 12c by steve reis."


Second, if you want to create a listener, from a command prompt do this to create and start the service:
set ORACLE_HOME=c:\app\epldt\product\12.1.0\dbhome_3
set PATH=%ORACLE_HOME%\bin;%PATH%
lsnrctl start

Third, to create a database, in that same command prompt session, do this:
dbca
and go through the dialogue accepting defaults for everything.

If this does not work, it is because your installation is not complete, and you will have to start again.
Re: Installing Oracle 12c [message #652793 is a reply to message #652734] Mon, 20 June 2016 02:54 Go to previous messageGo to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
hi, '

i think i will start from the start. but knowing that my installation is
successful i know that it has no issue. the database is the only issue.
how can i uninstall oracle 12c that i've installed? i have read
from oracle document by using deinstallation tool but how can i access it?

thanks
Re: Installing Oracle 12c [message #652794 is a reply to message #652793] Mon, 20 June 2016 02:58 Go to previous messageGo to next message
John Watson
Messages: 7187
Registered: January 2010
Location: Global Village
Senior Member
Quote:
i have read
from oracle document by using deinstallation tool but how can i access it?
Which Oracle docuement did you read? The Installation Guide gives full instructions.
Re: Installing Oracle 12c [message #652795 is a reply to message #652794] Mon, 20 June 2016 02:59 Go to previous messageGo to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
https://docs.oracle.com/database/121/LADBI/remove_oracle_sw.htm#LADBI7824
Re: Installing Oracle 12c [message #652798 is a reply to message #652795] Mon, 20 June 2016 03:03 Go to previous messageGo to next message
John Watson
Messages: 7187
Registered: January 2010
Location: Global Village
Senior Member
You need the Windows guide, not the Linux guide.
Re: Installing Oracle 12c [message #652803 is a reply to message #652798] Mon, 20 June 2016 03:49 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
Windows guide:

https://docs.oracle.com/database/121/NTDBI/deinstall.htm#NTDBI7446
Re: Installing Oracle 12c [message #652849 is a reply to message #652803] Tue, 21 June 2016 01:18 Go to previous messageGo to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
hi,

i have performed deintall. my question is. have i done it right? what is the indication that i did remove oracle12c?

below is the command prompt result:

Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.

C:\Users\EPLDT>dinstall
'dinstall' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\EPLDT>cd ..

C:\Users>cd..

C:\>
C:\>cd app

C:\app>cd EPLDT

C:\app\EPLDT>cd product

C:\app\EPLDT\product>cd 12.1.0

C:\app\EPLDT\product\12.1.0>cd dbhome_1

C:\app\EPLDT\product\12.1.0\dbhome_1>cd deinstall

C:\app\EPLDT\product\12.1.0\dbhome_1\deinstall>
C:\app\EPLDT\product\12.1.0\dbhome_1\deinstall>deinstall.bat
Checking for required files and bootstrapping ...
Please wait ...
File not found - bin
File not found - jlib
1 file(s) copied.
1 file(s) copied.
1 file(s) copied.
1 file(s) copied.
Location of logs C:\Users\EPLDT\logs\

############ ORACLE DECONFIG TOOL START ############

The product version number of the specified home cannot be determined. Is the pr
oduct version 12.1.0.2.0 (y - yes, n - no)? [n] y

######################### DECONFIG CHECK OPERATION START #######################
##
## [START] Install check configuration ##
The deinstall tool cannot determine the home type needed to deconfigure the sele
cted home. Please select the type of Oracle home you are trying to deinstall.
Single Instance database - Enter 1
Real Application Cluster database - Enter 2
Grid Infrastructure for a cluster - Enter 3
Grid Infrastructure for a stand-alone server - Enter 4
Client Oracle Home - Enter 5
Transparent Gateways Oracle Home - Enter 6
GSM Oracle Home - Enter 7
1
The product version number of the specified home cannot be determined. Is the pr
oduct version at least 11.2.0.1.0 (y - yes, n - no)? [n]
n
ERROR: The deinstall tool supports only homes with version number of '11.2.0.1.0
' or greater. The specified home does not meet this requirement.
Location of logs C:\Users\EPLDT\logs\

############ ORACLE DECONFIG TOOL START ############

The product version number of the specified home cannot be determined. Is the pr
oduct version 12.1.0.2.0 (y - yes, n - no)? [n]y

######################### DECONFIG CHECK OPERATION START #######################
##
## [START] Install check configuration ##
The deinstall tool cannot determine the home type needed to deconfigure the sele
cted home. Please select the type of Oracle home you are trying to deinstall.
Single Instance database - Enter 1
Real Application Cluster database - Enter 2
Grid Infrastructure for a cluster - Enter 3
Grid Infrastructure for a stand-alone server - Enter 4
Client Oracle Home - Enter 5
Transparent Gateways Oracle Home - Enter 6
GSM Oracle Home - Enter 7
1
The product version number of the specified home cannot be determined. Is the pr
oduct version at least 11.2.0.1.0 (y - yes, n - no)? [n]
y


Checking for existence of the Oracle home location C:\app\EPLDT\product\12.1.0\d
bhome_1
Oracle Home type selected for deinstall is: Oracle Single Instance Database
Oracle Base selected for deinstall is:
Checking for existence of central inventory location C:\Program Files\Oracle\Inv
entory

## [END] Install check configuration ##

## [START] Checking Windows and .NET products configuration ##


The following Windows and .NET products will be deconfigured from the Oracle hom
e : null

## [END] Checking Windows and .NET products configuration ##


Network Configuration check config START

Network de-configuration trace file location: C:\Users\EPLDT\logs\netdc_check201
6-06-21_02-09-41-PM.log

Network Configuration check config END

Database Check Configuration START

Database de-configuration trace file location: C:\Users\EPLDT\logs\databasedc_ch
eck2016-06-21_02-09-52-PM.log

Use comma as separator when specifying list of values as input

Specify the list of database names that are configured in this Oracle home []:
Database Check Configuration END
Oracle Configuration Manager check START
OCM check log file location : C:\Users\EPLDT\logs\\ocm_check526.log
Oracle Configuration Manager check END

######################### DECONFIG CHECK OPERATION END #########################



####################### DECONFIG CHECK OPERATION SUMMARY #######################

Oracle Home selected for deinstall is: C:\app\EPLDT\product\12.1.0\dbhome_1
Inventory Location where the Oracle home registered is: C:\Program Files\Oracle\
Inventory
The following Windows and .NET products will be deconfigured from the Oracle hom
e : null
Checking the config status for CCR
Oracle Home exists with CCR directory, but CCR is not configured
CCR check is finished
Do you want to continue (y - yes, n - no)? [n]: y
A log of this session will be written to: 'C:\Users\EPLDT\logs\deinstall_deconfi
g2016-06-21_01-59-30-PM.out'
Any error messages from this session will be written to: 'C:\Users\EPLDT\logs\de
install_deconfig2016-06-21_01-59-30-PM.err'

######################## DECONFIG CLEAN OPERATION START ########################

Database de-configuration trace file location: C:\Users\EPLDT\logs\databasedc_cl
ean2016-06-21_02-10-09-PM.log

Network Configuration clean config START

Network de-configuration trace file location: C:\Users\EPLDT\logs\netdc_clean201
6-06-21_02-10-09-PM.log

De-configuring Naming Methods configuration file...
Naming Methods configuration file de-configured successfully.

De-configuring backup files...
Backup files de-configured successfully.

The network configuration has been cleaned up successfully.

Network Configuration clean config END

Oracle Configuration Manager clean START
OCM clean log file location : C:\Users\EPLDT\logs\\ocm_clean526.log
Oracle Configuration Manager clean END
## [START] Removing Windows and .NET products configuration ##

ERROR: null
Exited from program.

############# ORACLE DECONFIG TOOL END #############

Using properties file C:\Users\EPLDT\AppData\Local\Temp\deinstall2016-06-21_01-5
4-19PM\response\deinstall_2016-06-21_01-59-30-PM.rsp
Location of logs C:\Users\EPLDT\logs\

############ ORACLE DEINSTALL TOOL START ############





####################### DEINSTALL CHECK OPERATION SUMMARY ######################
#
A log of this session will be written to: 'C:\Users\EPLDT\logs\deinstall_deconfi
g2016-06-21_01-59-30-PM.out'
Any error messages from this session will be written to: 'C:\Users\EPLDT\logs\de
install_deconfig2016-06-21_01-59-30-PM.err'

######################## DEINSTALL CLEAN OPERATION START #######################
#
## [START] Preparing for Deinstall ##
Setting LOCAL_NODE to EPLDT-PC
Setting CRS_HOME to false
Setting oracle.installer.local to false

## [END] Preparing for Deinstall ##

Setting the force flag to false
Setting the force flag to cleanup the Oracle Base
Oracle Universal Installer clean START

Oracle Universal Installer cleanup completed with errors.

Oracle Universal Installer clean END


## [START] Oracle install clean ##


## [END] Oracle install clean ##


######################### DEINSTALL CLEAN OPERATION END ########################
#


####################### DEINSTALL CLEAN OPERATION SUMMARY ######################
#
Oracle Universal Installer cleanup completed with errors.

Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################


############# ORACLE DEINSTALL TOOL END #############


C:\app\EPLDT\product\12.1.0\dbhome_1\deinstall>
Re: Installing Oracle 12c [message #652850 is a reply to message #652849] Tue, 21 June 2016 01:25 Go to previous messageGo to next message
John Watson
Messages: 7187
Registered: January 2010
Location: Global Village
Senior Member
When you copy/paste from SQL*Plus, please use [code] tags to format the result as described here,
How to use [code] tags and make your code easier to read

Also, please think a little bit. Your earlier posts have referred to directories ...\dbhome_2 and ...\dbhome_3.
You have deinstalled from ...\dbhome_1.
You could also try looking at the registry to see what keys still exist and you could look at the file system to see what direftories exist.

[Updated on: Tue, 21 June 2016 01:25]

Report message to a moderator

Re: Installing Oracle 12c [message #652853 is a reply to message #652850] Tue, 21 June 2016 01:40 Go to previous messageGo to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
wel,

to make sure, i did deinstalled in all dbhome folder

C:\app\EPLDT\product\12.1.0\dbhome_1\deinstall>deinstall.bat

C:\app\EPLDT\product\12.1.0\dbhome_2\deinstall>deinstall.bat

C:\app\EPLDT\product\12.1.0\dbhome_3\deinstall>deinstall.bat
Re: Installing Oracle 12c [message #652856 is a reply to message #652853] Tue, 21 June 2016 02:04 Go to previous messageGo to next message
juanmapalad
Messages: 21
Registered: June 2016
Junior Member
i have deinstalled oracl 12c

but why there still exist in my app?

http://imgur.com/eQLZmgy

the OracleRemExecServiceV2 is still running in the services.

did i not successfully remove it?

thanks
Re: Installing Oracle 12c [message #652858 is a reply to message #652856] Tue, 21 June 2016 02:15 Go to previous messageGo to previous message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
Did you shut down and re-start your computer? Some things require that in order to complete.

Previous Topic: Installing example Schemas...Help
Next Topic: oracle writes a lot to c:\windows\temp
Goto Forum:
  


Current Time: Sun Dec 17 06:21:24 CST 2017

Total time taken to generate the page: 0.01936 seconds