connecting to Windows Oracle database
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. )
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. )
0