Oracle 9i Database Administration in 10 Minutes
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Chapter 7: Enabling Other Computers to Access Oracle Server
Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
Step 4:
Once you click the “Test” button ONM (Oracle Network Manger) will use
the “scott/tiger” account to test the connection. If you don’t have this
account in your database or if you would like to use some other account
you can do that too. Upon successful connection don’t forget to save the
Network Configuration. The tnsnames.ora file will get created or updated
only when you save the configuration by clicking “File” and then “Save
Network Configuration”.
Figure 65: Service Name & Net Service Name is not
same. Service Name is the Global Database Name.
________________________________________
Figure 66: Save Network Configuration. Oracle Net
Manager will generate tnsnames.ora file containing Net Service Name
(alias) resolution to make a Oracle Server connection.
________________________________________
Chapter 7: Enabling Other Computers to Access Oracle Server
Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Share with others: