owngerma.blogg.se

1. CREATE DATABASE IN ORACLE 10G EXPRESS INSTALL
2. CREATE DATABASE IN ORACLE 10G EXPRESS UPDATE
3. CREATE DATABASE IN ORACLE 10G EXPRESS PASSWORD

LISTENER = ( DESCRIPTION_LIST = ( DESCRIPTION = ( ADDRESS = ( PROTOCOL = IPC )( KEY = EXTPROC_FOR_XE )) ( ADDRESS = ( PROTOCOL = TCP )( HOST = oracle )( PORT = 1521 )) ) ) You’ll be presented with a page similar to this one:

CREATE DATABASE IN ORACLE 10G EXPRESS PASSWORD

Log in with the username “SYSTEM” and the password you specified during Oracle configuration. After your tunnel is started, you can connect to the admin page at the URL. Since you most likely do not have a window manager or web browser installed on your Linode, you must connect to your Oracle home page remotely. By default, it listens on the local address 127.0.0.1 at port 8080. Oracle is managed via a web interface, which is installed with the oracle-xe package. You should see output resembling the following: tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN Once you’ve logged back in via SSH, you can verify that the Oracle listener process is functioning correctly by issuing the following command: netstat -an | grep 1521 Reboot your Linode to make sure everything comes back up correctly. ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/serverĪLTER USER SYSTEM IDENTIFIED BY changeme To correct this, issue the following commands, replacing “changeme” with your desired password.

As of this writing, Oracle’s SYSTEM and SYS passwords are not properly set during configuration. You may leave the port options at their default values. You will be asked to specify a system user password and the ports you would like Oracle to listen on.

CREATE DATABASE IN ORACLE 10G EXPRESS INSTALL

Install Oracle XE by running the following command: apt-get install oracle-xeĪfter the installation has finished, you must configuration Oracle by issuing the following command: /etc/init.d/oracle-xe configure

CREATE DATABASE IN ORACLE 10G EXPRESS UPDATE

Since you added a new repository, issue the following commands to update your package lists and install any outstanding updates: apt-get update Change the values shown below to match your Linode’s network configuration, paying special attention to the subnet mask for the private IP. If you need to add a private IP, reboot your Linode after doing so before proceeding with the next step.Įdit your network interfaces file to define your public and private IPs. To do so, visit the Networking tab in the Linode Cloud Manager. You’ll be using a private IP on your Linode and setting the hostname a bit differently than usual to account for this, with the added benefit of being able to connect to your Oracle database from other Linodes in the same data center.įirst, make sure your Linode has a private IP address assigned to it.

Oracle is very picky about the system hostname with respect to what interfaces it will listen on. Configure Networking and Set the Hostname If you’re already using all of your allocated disk space, you may need to shrink your main disk first to accommodate the larger swap image. Once your Linode is completely shut down, click the swap disk under the “Disks” heading in the Dashboard. To do this, log into the Linode Manager and shut down your Linode. While we normally do not advise using a swap partition larger than 256 MB, in this case it’s a good idea to resize your existing swap to 1,025 MB before proceeding with Oracle installation (the extra MB avoids differences in how megabytes are calculated). Please note: Depending on the amount of memory your Linode has, Oracle may require up to a 1,024 MB swap partition. All configuration will be performed in a terminal session make sure you’re logged into your Linode as root via SSH. It is assumed that you’ve followed the steps outlined in our

This guide will help you get started with Oracle 10g XE (Express Edition) on your Ubuntu 10.04 LTS (Lucid) Linode. The Oracle database platform was the first commercially available SQL-based DBMS, and is a great choice for applications that require large, distributed databases. Oracle 10g is a robust, enterprise-grade relational database management system (RDBMS).