[Daily work] configuration of test environment application and database

1. Test the monomer application before this side of the application and the database into a virtual machine, so that you can directly use the snapshot rollback, the application and the database is a complete state for easy testing.

2. But there are many virtual machines in the LAN clone, most of the virtual machine password is also consistent, in order to increase the flexibility, so this piece has a problem sometimes the IP address changes or other circumstances may have a situation of confusion,

So the virtual machine inside generally take a measure is:

When registering, use IP 127.0.0.1 to connect to this loopback address.

This avoids changes in the IP address or the amount of work that is modified after cloning.

Accordingly, the listener and Tnsname settings for the Oracle database are all a machine name address

Because it is found that Oracle will not be able to access external machines if 127.0.0.1 is used.

Another place is: If you change the machine name, you need this piece to be processed. Modify the monitoring and related configuration information for Oracle. Then reboot.

Sqlserve words to use. or 127.0.0.1 can be connected using the 127.0.0.1/instancename method if the database is not the default command

Note

Default port for Oracle 1521

Default port for SQL Server 1433

[Daily work] configuration of test environment application and database