Oracle Db Installation On Windows

0 views

Skip to first unread message

Leontina Heidgerken

unread,

Aug 5, 2024, 2:09:51 PM8/5/24

to schoolapreskey

Hellotoday i tried to install the new 18c XE on my windows 10 computer. After a while the installation froze and the dilemma began. Windows told mit XE was installed, but i couldnt find it in my programms/apps and the setup.exe just told me i already had installed a XE version.

As it didnt show up in my programm/apps and the exe didnt give me the uninstall feature i tried to delete all parts and registry edits manually. The result is, that i still cant reininstall XE because it shows : There is already a XE installation on your computer. Are there any suggestions or solutions? I was really happy to start with the new XE, but now it seems kinda hopeless. Excuse my bad english Im not a native speaker.

I downloaded oracle 12c on a windows 7 64 bit professional machine. And after the installation, when I look into the windows services, i can only see the "OracleRemExecServiceV2" . I don't see any other services , like "OracleServicexxx" or "OracleTNSListener" etc. Am I missing something ?

If you put -nowait then it means that docker will skip this line and go to next one since it does not know that it was completed. You probably shall remove that line at the minimum.

If I were you I would switch to powershell and CMD processor and use similar construct to below to launch installation executable

Oracle setup installer and response files ready, I run the setup command with my response file on my own PC from an elevated cmd window and Oracle is installed, no problems found and oracledb installs according to my reponsefile

I have a very similar problem installing Oracle SQLPlus and VS Redistributable on a container on MS Server 2016. Looks like it is a dead end for those who are trying to (a) Get a reasonable installation of any non-Microsoft software installed on the container (b) Run/Switch-to Linux containers on Windows 2016.

That it is not entirely true, you can create an answer file and start a total silent install, is well documented in Oracle and I managed to start the install on the container, but fails after few seconds with access denied, even that the

account is created on my docker file and member of the local admin group

For anyone looking for how to get an Oracle client running in a Docker Windows container, I can confirm the approach proposed here works. I used both instantclient_19_17 and instantclient_18_5 and both worked for me.

The cx_Oracle module loads Oracle Client libraries which communicateover Oracle Net to an existing database. Oracle Net is not a separateproduct: it is how the Oracle Client and Oracle Database communicate.

Add Oracle 21, 19, 18, 12 or 11.2 client libraries to your operating systemlibrary search path such as PATH on Windows or LD_LIBRARY_PATH onLinux. On macOS use init_oracle_client() in yourapplication to pass the Oracle Client directory name, seeUsing cx_Oracle.init_oracle_client() to set the Oracle Client directory. This is also usable on Windows.

Instant Client on Windows requires an appropriate Microsoft WindowsRedistributables, see Installing cx_Oracle on Windows. On Linux, the libaio(sometimes called libaio1) package is needed. Oracle Linux 8 alsoneeds the libnsl package.

Version 21 client libraries can connect to Oracle Database 12.1 or greater.Version 19, 18 and 12.2 client libraries can connect to Oracle Database 11.2or greater. Version 12.1 client libraries can connect to Oracle Database 10.2or greater. Version 11.2 client libraries can connect to Oracle Database 9.2or greater.

Locate your Oracle Database username and password, and the databaseconnection string. The connection string is commonly of the formathostname/servicename, using the hostname where the database isrunning, and using the service name of the Oracle Database instance.

cx_Oracle requires Oracle Client libraries. The libraries provide thenecessary network connectivity to access an Oracle Database instance.They also provide basic and advanced connection management and datafeatures to cx_Oracle.

cx_Oracle uses the shared library loading mechanism available on eachsupported platform to load the Oracle Client libraries at runtime. Itdoes not need to be rebuilt for different versions of the libraries.Since a single cx_Oracle binary can use different client versions andalso access multiple database versions, it is important yourapplication is tested in your intended release environments. NewerOracle clients support new features, such as the oraaccess.xml external configurationfile available with 12.1 or later clients, session pool improvements,improved high availability features, call timeouts, and other enhancements.

The cx_Oracle function clientversion() can be used todetermine which Oracle Client version is in use. The attributeConnection.version can be used to determine which Oracle Databaseversion a connection is accessing. These can then be used to adjust applicationbehavior accordingly. Attempts to use Oracle features that are not supported bya particular client/server library combination will result in runtime errors.

This will download and install a pre-compiled binary if one isavailable for yourarchitecture. If a pre-compiled binary is not available, the sourcewill be downloaded, compiled, and the resulting binary installed.Compiling cx_Oracle requires the Python.h header file. If you areusing the default python package, this file is in the python-develpackage or equivalent.

If you use optional Oracle configuration files such as tnsnames.ora,sqlnet.ora or oraaccess.xml with Instant Client, then put the filesin an accessible directory, for example in/opt/oracle/your_config_dir. Then use:

Alternatively, put the files in the network/admin subdirectory of InstantClient, for example in /opt/oracle/instantclient_21_1/network/admin.This is the default Oracle configuration directory for executables linkedwith this Instant Client.

Alternatively, for version 18 and earlier, every shell runningPython will need to have the environment variableLD_LIBRARY_PATH set to the appropriate directory for theInstant Client version. For example:

Alternatively, put the files in the network/admin subdirectory of InstantClient, for example in /usr/lib/oracle/21/client64/lib/network/admin.This is the default Oracle configuration directory for executables linkedwith this Instant Client.

Using cx_Oracle requires Oracle Client libraries to be installed.These provide the necessary network connectivity allowing cx_Oracleto access an Oracle Database instance. Oracle Client versions 19, 18,12 and 11.2 are supported.

Alternatively, put the files in a network\admin subdirectory ofInstant Client, for example inC:\oracle\instantclient_19_11\network\admin. This is the defaultOracle configuration directory for executables linked with thisInstant Client.

If you use optional Oracle configuration files such as tnsnames.ora,sqlnet.ora or oraaccess.xml with Oracle Instant Client, then put thefiles in an accessible directory, for example in/Users/your_username/oracle/your_config_dir. Then use:

Alternatively, put the files in the network/admin subdirectory of OracleInstant Client, for example in/Users/your_username/Downloads/instantclient_19_8/network/admin. This is thedefault Oracle configuration directory for executables linked with thisInstant Client.

For other installation options such as installing through a proxy, seeinstructions above. Make sure the Oracle Client libraries are in the systemlibrary search path because cx_Oracle 7 does not support thecx_Oracle.init_oracle_client() method and does not support loading theOracle Client libraries from the directory containing the cx_Oracle modulebinary.

On Windows, if you are not usinginit_oracle_client(), then restart your command promptand use set PATH to check the environment variable has the correctOracle Client listed before any other Oracle directories.

On Linux, check the LD_LIBRARY_PATH environment variable containsthe Oracle Client library directory. If you are using Oracle InstantClient, a preferred alternative is to ensure a file in the/etc/ld.so.conf.d directory contains the path to the Instant Clientdirectory, and then run ldconfig.

3. Go to your windows start program again and type Services. This will take you to the Windows Services. Verify Oracle services and make sure they are running. You can modify these services to start automatic (when you restart your laptop) or manual. Anytime you have a problem connecting to your database, check the services.

In the command prompt window, type the following command to logon as user system with password oca. I created this administrative password during installation. If you used a different password, then use your password.

The sample Scott schema is good for learning Oracle but it does not come as default with Oracle installation. We need to install it separately. It is available to the user Scott. In this blog, we will see how to unlock sample Scott user so that we can access the sample schema.

Once you have successfully installed Oracle database 19c, its time to unlock the sample schemas so that you can start learning Oracle SQL. In this article, we will see how to unlock HR user in Oracle 19c.

All the sample databases are stored under the pluggable database (in our installation, it is orclpdb) and not in the root container database. By default, oracle connects us to the root container database. In order for us to unlock the sample database, we need to first switch from the root container to the pluggable database.