Folk,
Hello. I am running Oracle Database Server 11gR1 in Virtual Machine Operating System Oracle Linux 5.
My host machine is Windows 10 in which 2 virtual machines are running.
The VM Oracle Linux 5 Host name is localhost.localdomain.
DB server LISTENER start up successfully for a long time as below:
[user@localhost bin]$./lsnrctl start LISTENER
Listening Endpoints Summary ...
(DESCRYPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
SNMP: OFF
...
The command commpleted successfully.
Now, I need to configure the virtual machine into my local network in Windows 10.
Thus, I assign a IP Address "MyIPaddress" and a new host name "mylinux.mydomain" to Oracle Linux 5.
I modify the 2 files "etc/hosts" and "tnsnames.ora" in Oracle Linux 5.
In the file "etc/hosts", I cancel one line and add one line as below:
::localhost6.localdomain6 localhost6 (this line is canceled)
MyIPaddress mylinux.mydomain mylinux (this line is added)
In the file /OracleDB_Home/network/admin/tnsnames.ora, I changed "localhost.localdomain" into "mylinux.mydomain" in the line below:
LISTENER=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
I shutdown and reboot Oracle Linux 5, I start LISTENER as below:
[user@localhost bin]$./lsnrctl start LISTENER
Listening Endpoints Summary ...
(DESCRYPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
SNMP: OFF
...
The command commpleted successfully.
As you see the output above,[user@localhost bin]$ doesn't change to [user@mylinux bin]$.
HOST=localhost.localdomain doesn't change to HOST=mylinux.mydomain.
The file "listener.ora" is not created when start the LISTENER.
My questions are:
1) How to have [user@localhost bin]$ change to [user@mylinux bin]$ ?
2) How to have LISTENER listening on (DESCRYPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mylinux.mydomain)(PORT=1521))) in the file tnsname.ora ?
Thanks in advance.