Hi, Allen
In order to log into Oracle you need to open port 1521. This is the port the Oracle listener is on. To activate the port do the following:
1. Open YaST
2. Select FireWall
3. Select Allowed Services
4. Make sure the option under Allowed Services for Selected Zone is set to External Zone.
5. Click Advanced
6. In the text area under TCP Ports type:
1158 - This allows you to connect to Oracle from a browser on your PC.
1521 - This allows users to connect from their PCs assuming the users have the Oracle client installed and the net configuration has been set up.
This should do the trick. To see if this worked run the following command from a user's PC command prompt (with Oracle client)
tnsping <oracle server ip address>
For axample - tnsping 192.168.20.25
Please let me know if this worked.
Regards,
William Chadbourne
Oracle DBA