- Linux oracle database installation
- Oracle Database XE Quick Start
- Installing Oracle Database XE
- Oracle Linux
- Red Hat compatible Linux distribution
- Windows
- Docker
- VirtualBox
- Connecting to Oracle Database XE
- SQL
- Java
- Python
- Node.js
- C# / .NET
- PHP
- Ruby
- Go
- Linux oracle database installation
- Linux oracle database installation
Linux oracle database installation
Oracle Database XE Quick Start
If you are experienced at installing software then use the steps provided below.
For more information and full step-by-step instructions please review the installation guides for Linux or Windows.
Installing Oracle Database XE
Oracle Linux
- Download oracle-database-xe-21c-1.0-1.ol8.x86_64.rpm
- Run “yum -y localinstall oracle-database-xe*”
- Run “/etc/init.d/oracle-xe-21c configure”
Red Hat compatible Linux distribution
- Download oracle-database-preinstall-21c-1.0-1.el8.x86_64.rpm
- Download oracle-database-xe-21c-1.0-1.ol8.x86_64.rpm
- Run “yum -y localinstall oracle-database-xe*”
- Run “/etc/init.d/oracle-xe-21c configure”
Windows
- Log into Windows with a user that is a direct member of the Administrators group.
- If the ORACLE_HOME or TNS_ADMIN environment variable has been set, unset it first.
- Download OracleXE213_Win64.zip
- Extract zip file to a local temporary directory and run setup.exe.
- When prompted by the installer, provide the install location, the database password, and begin the installation.
- When the installation is complete, note the provided connection strings on the final screen.
Docker
- Docker images can be downloaded at https://container-registry.oracle.com
- Linux Docker images can also be built using the Dockerfiles provided under https://github.com/oracle/docker-images
VirtualBox
A Linux VirtualBox VM can be built using the Vagrant scripts provided under https://github.com/oracle/vagrant-boxes. You can also install into a Windows VirtualBox VM providing the version of Windows is supported. See the Oracle Database XE Windows Installation Guide.
Connecting to Oracle Database XE
SQL
- — Connect string format: [username]/[password]@//[hostname]:[port]/[DB service name] [AS SYSDBA]
- — To connect to the Container Database (CDB) use:
- sqlplus sys/[Password]@//localhost:1521/XE as sysdba
- — To connect to the first Pluggable Database (PDB) use:
- sqlplus sys/[Password]@//localhost:1521/XEPDB1 as sysdba
Java
- OracleDataSource ods = new OracleDataSource();
- ods.setURL(«jdbc:oracle:thin:@//localhost:1521/XEPDB1»); // jdbc:oracle:thin@//[hostname]:[port]/[DB service name]
- ods.setUser(«[Username]»);
- ods.setPassword(«[Password]»);
- Connection conn = ods.getConnection();
- PreparedStatement stmt = conn.prepareStatement(«SELECT ‘Hello World!’ FROM dual»);
- ResultSet rslt = stmt.executeQuery();
- while (rslt.next()) System.out.println(rslt.getString(1));
>
Python
- import cx_Oracle
- # Connect string format: [username]/[password]@//[hostname]:[port]/[DB service name]
- conn = cx_Oracle.connect(«[Username]/[Password]@//localhost:1521/XEPDB1»)
- cur = conn.cursor()
- cur.execute(«SELECT ‘Hello World!’ FROM dual»)
- res = cur.fetchall()
- print(res)
Node.js
- var oracledb = require(‘oracledb’);
- async function run()
- let connection = await oracledb.getConnection(
- user : «[Username]»,
- password : «[Password]»,
- connectString : «localhost:1521/XEPDB1» // [hostname]:[port]/[DB service name]
- >);
- let result = await connection.execute( «SELECT ‘Hello World!’ FROM dual»);
- console.log(result.rows[0]);
- >
- run();
C# / .NET
- // Connection string format: User Source=[hostname]:[port]/[DB service name];
- OracleConnection con = new OracleConnection(«User cmd = con.CreateCommand();
- cmd.CommandText = «SELECT \’Hello World!\’ FROM dual»;
- OracleDataReader reader = cmd.ExecuteReader();
- reader.Read();
- Console.WriteLine(reader.GetString(0));
PHP
- // [username], [password], //[hostname]:[port]/[DB service name]
- $c = oci_pconnect(«[Username]», «[Password]», «//localhost:1521/XEPDB1»);
- $s = oci_parse($c, «SELECT ‘Hello World!’ FROM dual»);
- oci_execute($s);
- oci_fetch_all($s, $res);
- echo «
\n"
- var_dump($res);
- echo "
\n»;
Ruby
- require ‘oci8’
- // «[username]/[password]@//[hostname]:[port]/[DB service name]»
- con = OCI8.new(«[Username]/[Password]@//localhost:1521/XEPDB1»)
- statement = «SELECT ‘Hello World!’ FROM dual»
- cursor = con.parse(statement)
- cursor.exec
- cursor.fetch do |row|
- print row
- end
Go
- package main
- import (
- «fmt»
- «log»
- «database/sql»
- _ «github.com/godror/godror»
- )
- func main() <
- // connectString format: [hostname]:[port]/[DB service name]
- dsn := `user=»[Username]»
- password=»[Password]»
- connectString=»localhost:1521/XEPDB1″`
- db, err := sql.Open(«godror», dsn)
- if err != nil
- panic(err)
- >
- defer db.Close()
- rows, err := db.Query(«SELECT ‘Hello World!’ FROM dual»)
- if err != nil
- panic(err)
- >
- defer rows.Close()
- var strVal string
- for rows.Next()
- err := rows.Scan(&strVal)
- if err != nil
- log.Fatal(err)
- >
- fmt.Println(strVal)
- >
- err = rows.Err()
- if err != nil
- log.Fatal(err)
- >
- >
Linux oracle database installation
Database Installation Guide
Oracle Database Database Installation Guide, 19c for Linux
Copyright © 2015, 2023, Oracle and/or its affiliates.
Primary Authors: Prakash Jashnani, Subhash Chandra
Contributing Author: Douglas Williams
Contributors: Ranjit Noronha, Jean-Francois Verrier, Richard Roddy, Rajesh Dasari, Smitha Viswanathan, Neha Avasthy, Sampath Ravindhran, Prasad Bagal, Subhranshu Banerjee, Gerald Venzl, Tammy Bednar, Avi Miller, Jean-Marc Thayer, Alok Sahu, Gavin Bowe, Gia-Khanh Nguyen, Darcy Christensen, Kiran Chamala, Jonathan Creighton, Benoit Dageville, Logeshwaran Rajan, Angad Gokakkar , Anu Natarajan, Girdhari Ghantiyala, Mani Mannampalli, Bernard Clouse, Chandrasekharan Iyer, Anil Nair, Sivaram Soma, Lisa Vaz, Vasu Venkatasubramanian, Sumanta Chatterjee, Margaret Susairaj, Malai Stalin, Markus Michalewicz, Subrahmanyam Kodavaluru, Sudip Datta, Madhu Hunasigi, Jim Erickson, Marcus Fallen, Joseph Francis, Allan Graves, Barbara Glover, Asad Hasan, Thirumaleshwara Hasandka, Putta Ramesh, Sergio Leunissen, Aneesh Khandelwal, Joel Kallman, Eugene Karichkin, Jai Krishnani, Prasad K Kulkarni, Ranjith Kundapur, Balaji Pagadala, Christopher Jones, Tak Wang, Bryn Llewellyn, Saar Maoz, Chao Liang, Gopal Mulagund, Pushkar Punit, Sivaselvam Narayanasamy, Ankur Kemkar, Sue Lee, Rich Long, Ricardo Alonso Gonzalez Acuna, Barb Lundhild, Sangeeth Jose, Rudregowda Mallegowda, Prasad Kuruvadi Nagaraj, Mughees Minhas, Krishna Mohan, Matthew McKerley, John McHugh, Gurudas Pai, Satish Panchumarthy , Rajesh Prasad, Rajendra Pingte, Ramesh Chakravarthula, Srinivas Poovala, David Price, Hanlin Qian, Michael Coulter, Hema Ramamurthy, Sunil Ravindrachar, Mark Richwine, Dipak Saggi, Alan Tam, Ian Cookson, David Schreiner, Ara Shakian, Naveen Ramamurthy, Mohit Singhal, Dharma Sirnapalli, Akshay Shah, James Spiller, Roy Swonger, Binoy Sukumaran, Jagvir Yadav, Ravi Thammaiah, Shekhar Vaggu, Pablo Sainz Albanez, Hector Vieyra, Peter Wahl, John Haxby, Sergiusz Wolicki, Sivakumar Yarlagadda, Nagendra Kumar Ym
Linux oracle database installation
Database Installation Guide
Oracle Database Database Installation Guide, 21c for Linux
Copyright © 2019, 2022, Oracle and/or its affiliates.
Primary Author: Prakash Jashnani
Contributing Authors: Douglas Williams, Subhash Chandra
Contributors: Jean-Francois Verrier, David Austin, Neha Avasthy, Sampath Ravindhran, Prasad Bagal, Subhranshu Banerjee, Gerald Venzl, Tammy Bednar, Sivaselvam Narayanasamy, Sangeeth Jose, Pushkar Punit, Peter Fusek, Darcy Christensen, Kiran Chamala, Jonathan Creighton, Benoit Dageville, Ranjit Noronha, Mani Mannampalli, Sumanta Chatterjee, Margaret Susairaj, Rajesh Dasari, Ricardo Gonzalez, Angad Gokakkar , Anu Natarajan, Girdhari Ghantiyala, Bernard Clouse, Chandrasekharan Iyer, David Jimenez, Sivaram Soma, Lisa Vaz, Vishal Saxena, Vasu Venkatasubramanian, Suman Palavalli, Sameer Joshi, Malai Stalin, Markus Michalewicz, Subrahmanyam Kodavaluru, Sudip Datta, Madhu Hunasigi, Jim Erickson, Marcus Fallen, Joseph Francis, Allan Graves, Barbara Glover, Thirumaleshwara Hasandka, Putta Ramesh, Sergio Leunissen, Aneesh Khandelwal, Joel Kallman, Eugene Karichkin, Jai Krishnani, Prasad K Kulkarni, Kevin Jernigan, Christopher Jones, Simon Law, Bryn Llewellyn, Saar Maoz, Gopal Mulagund, Ankur Kemkar, Sue Lee, Rich Long, Raunak Rungta, Barb Lundhild, Robert Achacoso, Rudregowda Mallegowda, Prasad Kuruvadi Nagaraj, Krishna Mohan, John McHugh, Satish Panchumarthy , Rajesh Prasad, Rajendra Pingte, Ramesh Chakravarthula, Srinivas Poovala, David Price, Hanlin Qian, Michael Coulter, Hema Ramamurthy, Mark Richwine, Dipak Saggi, Rodrigo Gonzalez Alba, Naveen Ramamurthy, Mohit Singhal, Dharma Sirnapalli, Akshay Shah, James Spiller, Roy Swonger, Binoy Sukumaran, Ravi Thammaiah, Pablo Sainz Albanez, Hector Vieyra, Peter Wahl, John Haxby, Sergiusz Wolicki