Hi,
I am working with an Oracle RDBMS 10gR2.
The database is running on a Linux server as user: talg02.
I have the following situation:
SQL> connect sys as sysdba
Enter password:
Connected.
SQL> !whoami
talg02
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=t
dbalg02.dbr.agro.nl)(PORT=1521
))
remote_listener string
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string talg004
SQL> !hostname
lnvx0084
SQL>
The database talg004 runs on host/node lnvx0084.
I see local_listener = (ADDRESS=(PROTOCOL=TCP)(HOST=tdbalg02.dbr.agro.nl)(PORT=1521)).
Does this mean that the listener is running on a different host?
What is then the usage local_listener versus remote_listener?
Thanks and Regards