Showing posts with label Express. Show all posts
Showing posts with label Express. Show all posts

2012/03/24

Making Oracle Database XE Available to Remote Clients

I installed one Oracle Database XE for testing purpose.

And found that it won't be accessable from different client.

And finally I found the answer in Oracle Document

Here is the copied sentence...

 

Start SQL*Plus and log in as SYSTEM:

SYSTEM_DRIVE:\> sqlplus system
Enter password: SYSTEM_password

Or, if you are logging in remotely:

SYSTEM_DRIVE:\> sqlplus system@xe_server_host_name
Enter password: SYSTEM_password

At the SQL prompt, enter the following command:

SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
 
And it can be remote access now. 微笑
 
 

2012/01/28

Oracle Database 11g Release 2(11.2) Express Edition Installation(Oracle Linux)


Package Requirements

  • glibc should be greater than or equal to 2.3.4-2.41
  • make should be greater than or equal to 3.80
  • binutils should be greater than or equal to 2.16.91.0.5
  • gcc should be greater than or equal to 4.1.2
  • libaio should be greater than or equal to 0.3.104
 

Kernel Parameter Requirements

Table 2 Kernel Parameter Settings Required for Oracle Database XE
Kernel Parameter Setting
semmsl
250
semmns
32000
semopm
100
semmni
128
shmmax
4294967295
shmmni
4096
shmall
2097152
file-max
6815744
VERSION
2.4.21
ip_local_port_range
9000–65500


Installation

rpm -ivh downloads/oracle-xe-11.2.0-1.0.x86_64.rpm
 

Configuration




  • A valid HTTP port for the Oracle Application Express (the default is 8080)

  • A valid port for the Oracle database listener (the default is 1521)

  • A password for the SYS and SYSTEM administrative user accounts

  • Confirm password for SYS and SYSTEM administrative user accounts

  • Whether you want the database to start automatically when the computer starts (next reboot)
 

Usuage


To start the database manually, run this command as root user:
# /etc/init.d/oracle-xe start

To stop the database manually, run the following command as root user:
# /etc/init.d/oracle-xe stop
 
Referenced from Oracle