Showing posts with label Remote. Show all posts
Showing posts with label Remote. 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. 微笑