I'm a fairly novice user of Oracle but having used SQL Server 7.0 and 2000, i'm very familiar with relational databases and structure. However, i am having problems with an Oracle server that is confirmed to be started and running. the proper tnsnames.ora is in place with the correct entries and i've also confirmed the listener.ora file to be intact.
my problem is after going over these checkpoints, i am still unable to connect to the database via SQLPlus. other databases added to the same tnsnames.ora file can be accessed except one. The error being rec'd is that the Oracle server is not even available. (??)
Has anyone experienced this before and know what other avenues i can double check?
Any assistance would be appreciated.
Thank you,
Claude Johnson
claude_johnson@s2systems.com
my problem is after going over these checkpoints, i am still unable to connect to the database via SQLPlus. other databases added to the same tnsnames.ora file can be accessed except one. The error being rec'd is that the Oracle server is not even available. (??)
Has anyone experienced this before and know what other avenues i can double check?
Any assistance would be appreciated.
Thank you,
Claude Johnson
claude_johnson@s2systems.com