Tag: network

database
ID: 20150820

SQL*Net more data from client

#oracle #network

The error SQLNet more data from client* usually happens when there’s a large amount of data sent from client (or other database in case of dblinks), which doesn’t fit into single SDU size Oracle pa... Read more

20 Aug 2015 - 1 minute read
database
ID: 20150620

Registering with the listener

#oracle #network

When restarting a database, if you can’t acess it from outside, you may have to associate the newly restarted database with the listener. The Pmon process that is started with the instance is respo... Read more

20 Jun 2015 - less than 1 minute read
database
ID: 20141120

Getting the server IP Address from SQL*plus

#system #network

Here’s a small script to get the IP address of the host server directly from the SQL*plus command line. DECLARE v_host_name v$instance.host_name%type; v_ip_address varchar2(50); BEGIN SELECT host_... Read more

20 Nov 2014 - less than 1 minute read