Identify the SQL*Net or Net Service Name

On Unix

1. Log in to the Oracle DBMS server.
   
2. su - oracle
   
3. Execute the ingres associated with the oracle user.
   
4. cd $ORACLE_HOME/bin
   
5. Run the netca program.
   
6. Wait for the Welcome page to appear.
   
7. Select "Local Net Service Name Configuration."
   
8. Select Next.
   
9. Select the Test option.
   
10. Select Next.
    
11. Use the drop-down menu to display a list of Oracle net service names available on the machine.
    
12. Exit the utility.

On Windows

1. Log in to the machine that hosts the Oracle DBMS.
   
2. Launch the Net Configuration Assistant (Start menu >> Programs >> Oracle).
   
3. Click the Local Net Service Name configuration radio button.
   
4. Click Next.
   
5. Click Test.
   
6. Click Next.
   
7. Use the drop-down menu to display a list of Oracle net service names available on the machine.
   
8. Use the Cancel button to exit the utility.