This is in continuation of the earlier part. Once you install in a server and if you want to access the admin page from your PC or any other servers you need to make a change. By default it is installed to access from localhost, which is http://127.0.0.1:8080/apex, if you have installed with the default port.

Login to SQLPLUS and execute.

SQL>EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

This would allow you to access the admin page from other computers, if the IP of your server on which it is installed is public. Then you can access from anywhere.  Or if you could login from console, then login to the admin page and go to Administration--> Manage HTTP Access and change it as below:

Example: http://123.45.67.89:8080/apex should allow you to access from other computers.

Before installing the software as root user, make sure that you have a user ‘oracle’ and group ‘dba’ created already. Then you can manage the database using the user ‘oracle’ like any other Enterprise Edition.

Sometime when you start the database as service the listener does not start, hence you need to login as oracle and start the listener with the lsnrctl command.

If it does not start, check the listener log and fix it. Then you should be able to access the database from TOAD or any other tool from your PC.

This is a good database for people to give access to make changes in your production database and still don’t want to give access directly to them to the actual production PeopleSoft database.

This is also great software to generate reports on the PeopleSoft system. All you have to do is create a database link to the actual production database from XE and generate and store the reports in XE database. Why not use it when it is free.

By the way, you can install it in DEBIAN also, if you are not comfortable with Red Hat or don’t want to spend on OS license with Windows.

Here is the link to download:

http://www.oracle.com/technology/software/products/database/xe/htdocs/102xelinsoft.html

You need to have OTN account. You can create if you do not have one.

Enjoy.

Be first to comment this article

Write Comment

Thankyou for your comments. Feel free to comment if there are any mistake in the postings also. If you have a Blog or website, feel free to provide the link. We will take a peak. Just ensure to *Refresh* your browser for a new security code to be displayed prior to clicking on the 'Send' button. Keep in mind that the above process only applies if you simply entered the wrong security code.
Name:
Homepage
BBCode:
Comment:
Code:*
	I wish to be contacted by email regarding additional comments

Copy Right: AKOComments v.1.4.6