Remote connection to Oracle port ing

ArticleDirectory

•  

Version: Oracle 9i 9.2.4.0
Since oracle is installed on an intranet machine and uses broadband to connect to the Internet, the external database needs to map out the Oracle port for remote connection. It was thought that it would be enough to connect as long as 1521, But it could never be connected, after checking the information, we found that 1521 only listens on the port. If the server runs in dedicated mode, the system will randomly allocate a port for communication during connection. After consulting the hangaiting of MDC, change the database running mode to share. The parameters are all default. You can use dbca for convenience. After that, log on to the system using macro-electric gprs dtu, oracle 7.3 installed on the client. Use sqlplus to connect. OK. query the help table of the system. The speed is acceptable. Haha, I don't know if the database is Oracle 7.3. I haven't tried it yet.