GGSCI (myserver1.oric.no) 7> dblogin useridalias mydb domain admin ERROR: OCI Error DPI (status = 7-DPI-007: invalid OCI handle or descriptor).Cause:
Incorrectly specified network configuration:
sqlnet.ora
names.default_domain = worldtnsnames.ora
mydb = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver1.oric.no)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = mydb) ) )To correct the error, you need to do either of the following:
1. remove the names.default_domain from sqlnet.ora
or
2. add an alias to your tnsnames.ora file
mydb.world =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myserver1.oric.no)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mydb)
)
)
No comments:
Post a Comment