Cannot to new instance of Oracle
Posted on 2008-06-19
We installed Oracle 9i on LINUX RedHat rel4, once we got past some package issues the database created without issues. The problem we have is that we cannot connect to the database from anywhere other then the local server. We can run sqlplus '/as sysdba' and access it or sqlplus system/abcd123@custdb1 and get to it, again only locally. We can connect out from the server to other databases, we can ping the server, putty to it and all that. Does anyone have any suggestions? We are getting to major crunch time on this and we still cannot access the db.
We have checked everything we can think of. We dropped the tnsnames, listener, sqlnet and rebuilt from other 9i sources and so on. Is there anything in the OS maybe host entries that we need to look at?