Sqlplus uses an IP address to connect to Oracle directly without a service name

The command is as follows:

Oracle server address: 192.168.2.181 port: 1521

Username: jans2002

Password: password123

Service name Sid: dbsvr

If you do not need netmgr to create a service name, you can directly write the IP address port and service name in the command line as follows:

Sqlplus jans2002/password123@192.168.2.181: 1521/dbsvr @ filelist.SQL

 

The content of the filelist. SQL file is as follows:

SetServeroutputOnBeginDbms_output.put_line ('File filelist. SQL executed.');End; // @.SQL@ B.SQLExit

A. the SQL content is as follows:

Begindbms_output.put_line ('File a. SQL executed'); End ;/

B. the SQL content is as follows:

Begindbms_output.put_line ('File B. SQL executed.'); End ;/

The execution result is as follows: