
Oracle 10g mi radi bez problema ali sam prije neki dan pokušao da kreiram db link na lokalnu bazu i link uspješno kreiram ali kada pokušam da npr. selektujem nešto koristeći link ne može. Greška je
ORA-28546: connection initialization failed, probable Net8 admin error
Znači na mom računaru imam Oracle bazu koja se zove orclanti. Želim da kreiram link na tu istu bazu. Evo nekih podataka za koje mislim da su bitni:
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
ORCLANTI.LOCAL.HOST
SQL> select name,value from v$parameter where name='global_names';
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
global_names
TRUE
tnsnames.ora:
ORCLANTI.LOCAL.HOST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = antix.login.net)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclanti)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\ora10g)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orclanti.local.host)
(ORACLE_HOME = E:\ora10g)
(SID_NAME = orclanti)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = antix.login.net)(PORT = 1521))
)
)
)
sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
NAMES.DEFAULT_DOMAIN= local.host
E sada.. pokušao sam da kreiram link na milion načina (loopback, sa domenom, postavio sam global_names na false itd... ali uvijek ista greška). Da ne bih lupao sada da li može neko od iskusnih u radu sa Oracle-om da mi kaže kako da kreiram link na osnovu podataka koje sam dao???? Ili možda nešto da popravim, da dam neke dodatne podatke????
hvala unaprijed