远程连接oracle xe数据库

远程客户端连接oracle,需进行如下设置。

To use the SQL Command Line, follow these steps:

Start SQL*Plus and log in as SYSTEM:

$ sqlplus system

Enter password: SYSTEM_password
Or, if you are logging in remotely:

$ sqlplus system@xe_server_host_name

Enter password: SYSTEM_password
At the SQL prompt, enter the following command:

SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

Leave a Reply

电子邮件地址不会被公开。 必填项已用*标注

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>