User's Manual

Testing the Oracle Database XE Installation

2-2 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft

http://www.oracle.com/technology/tech/php/zendcore/index.html

To the right of the "Zend Core for Oracle" Web page, click the Free Download

image:

3. Save the downloaded file in a temporary directory, such as /tmp.

Testing the Oracle Database XE Installation

1. The PHP application connects to the database as the HR user. You may need to

execute the following SQL command, as a user with DBA privileges:

alter user hr account unlock identified by hr;

2. To test that Oracle Database XE is accessible, connect to the database using the

HTML DB web interface, or enter the following commands in a command

window:

export ORACLE_HOME=

export PATH=$ORACLE_HOME/bin:$PATH

sqlplus hr/hr@localhost

Terminate the SQL*Plus session by entering the exit command at the SQL

prompt:

SQL> exit