HelloI'm writing to share some hard-won lessons about this installation process that are specific to Windows 7 64-bit. First of all, it should be known that the port of Oracle from 32-bit to 64-bit is not, in my opinion, complete.
The installation comes with its own version of Java which apparently has bugs in it. The installation script will not work as it is. It will mysteriously fail without any meaningful log messages. The window just disappears. Even clicking on buttons in the dialog box will make it inexplicably vanish. See other discussions on this forum which are now archived (which is why I'm not simply responding to one of those). To get around this, you will need to use a more recent version of Java. I used the 64-bit version of jdk1.8.0_05. To get the shortened DOS version of this path, I issued the following cygwin command:
I don't personally have a "My Oracle Support", so on Step 1 of 9, I unchecked the "I wish to receive security updates via My Oracle Support", and clicked on next. An intimidating window will pop up requiring you to check a check box labeled, "I want to remain uninformed of critical security issues in my configuration". Click on Continue.
On step 2 of 9, check the radio button for "Create and configure database". Step 3 of 9, I selected Desktop Class. On step 4 of 9, I changed the Oracle base to "C:\cygwin\home\lylez\oracle", and accepted the other defaults (such as "Enterprise Edition"). You may wish to accept all the defaults; that's up to you. Select an administrative password (and write it down) and click on Next. Then click on Finish.
A window entitled, "Database Configuration Assistant" will pop up. It is imperative that you click on the oval-shaped "Password Management" button on the lower right to select passwords for the various sample accounts, and to unlock them. Otherwise, there's no way (that I know of) to set the passwords, and you'll have a big useless installation, at least as far as experimenting with existing databases goes. I recommend that all of the accounts be unlocked, and I personally used the same password for all of them (this is only for practice on my own desktop - you may wish to be more secure if it's being done for a corporation). I copied the password to the clipboard in notepad so that I wouldn't have to type it over and over again. Then click on OK, and then Close. The database should now be successfully installed. All of this takes a long time, so don't be discouraged.
Now, when you attempt to launch PL SQL Developer, it will ask you for a JDK. This is another source of misery. If you give it the 64-bit JDK, it will reject it, without telling you why, and it will stay in rejection mode until you give it a different path, even if the contents of the folder you gave it have since changed. You must instead give it a 32-bit JDK version, but it's not enough to simply provide it with a 32-bit java.exe file, you must provide the entire JDK directory and all contents. I copied my 32-bit JDK directory from my other computer, that is, the jdk.1.8.0_05 directory and contents, and gave that path (C:\Program Files\Java\jdk1.8.0_05_32bit is what I named it) to the PL SQL dialog box. Then it will work. At least, it did for me.
To create connections in PL SQL Developer,click on the add connection button (the paper symbol with the green plus sign on it), and give it a name. To create a connection to the sample hr database, give the username as hr, and give it the password you typed in for it in the Password Management window mentioned two paragraphs above in this posting. For the SID, you must change it from xe to orcl. You may also want to create a connection to sys. Do the same things as before, but this time, select "SYSDBA" in the drop-down box next to Role. For a sysman connection, I used the default role. Same with system.
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.
Step 2. In step 2, the Oracle installer asks you whether you want to create and configure a database, install database software only, or just upgrade an existing database. Because you install the Oracle database for the first time, choose option 1 and click the Next button.
Step 3. The installer allows you to choose the system class. Because you install Oracle on your computer, not a server, therefore, you choose the first option: desktop class and click the Next button.
Step 7. The installer shows you the summary of the information such as global settings, database information, etc. You need to review the information and click the install button if everything is fine.
Copyright 2017 - Present Oracle Tutorial. All Rights Reserved.
The tutorials on
oracletutorial.com are not sponsored by the Oracle Corp and this website has no relationship with the Oracle Corp.
You have to format your drive into NTFS format to install oracle on XP.
Else, you have to install on win2k.
This is the only way to install on XP.
I have tried all other ways.
Only this will help you
Hi,
If you are not running the Production database, then uninstall the Oracle
Database. Try to Install Forms6i and Reports 6i first. And install the
Oracle Database.
Regards,
BALU,
ORACLE DBA
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.
3a8082e126