Creating a 11g Database Manually by Scripts (3/3) - Configure local naming and password file for outside users
Even though the database is created, but it has not been connected from outside. You should configure an entry of local naming for the new database on application servers or client machines.
Add a service naming on a client machine.
On Windows platform, use "Oracle Net Manager" to add a service naming, or you can edit the tnsnames.ora directly and add an entry for the new database: ... smalldb = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = primary01-vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = smalldb) ) )
Test the service name on a client machine.
C:\Documents and Settings\Administrator>tnsping smalldb ...
Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = primary01)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = smalldb))) OK (70 msec)
Create a password file for the new database on the database server.