Database Administration (MOSC)

MOSC Banner

connecting to Windows Oracle database

edited Jan 4, 2010 8:36AM in Database Administration (MOSC) 2 commentsAnswered
 I just came across a database in which I can tnsping the database and can login with syntax sqlplus / as sysdba.
However, when I try to qualify the database name such as sqlplus system/pwd@LUMPRODD I get the error:
ora-28547: connection to server failed, probable oracle net admin error:

I checked and noticed this database had different namings all over it.  I changed the database names as follows:

Listener.ora  (global_name = LUMPRODD)
                       (sid_name = LUMPRODD)

tnsnames.ora (LUMPRODD
                                          SID=LUMPRODD
                                          SERVICE_NAME = LUMPRODD)

The init.ora shows the db_name = LumProdD
                                       db_unique_name = LumProdDB

( I recreated the spfile from pfile and restarted database. )

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center