Temat: ORA-12154 Nie udało się rozstrzygnąć podanego...
napisz na jakiej wersji forms'ów wyskakuje Ci taki błąd
1.)
prawdopodobnie masz nieprawidłowy zapis w TNSNAMES.ora
znajdź TNS'a
dla forms 6i
C:\orant\NET80\ADMIN\tnsnames.ora
dla 9/10 ten plik jest w (ale nie pamiętam dokładnie ścieżki)
C:\oradevsuite\NETWORK\ADMIN\tnsnames.ora
i sprawdź czy wygląda w ten sposób
pola [*TEXT] musisz uzupełnić o twoje dane
[*ALIAS_DO_BAZY] =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = [*IP_SERWERA])(PORT = [*PORT_DOMYSLNIE 1521]))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = [*BAZA])
)
)
-- Przykład
MOJA_BAZA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
2.)
jeśli to nie pomoże zmień wpis z
[*ALIAS] =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = [*LOCALHOST])(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = [*BAZA])
)
)
na
[*ALIAS] =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = [*LOCALHOST])(PORT = 1521))
)
(CONNECT_DATA =
(SID = [*BAZA])
)
)
lub odwrotnie
a tu jeszcze wrzucam opis błędu
TNS-12154 TNS:could not resolve service name
Cause: The service name specified is not defined correctly in the TNSNAMES.ORA file.
Action: Make the following checks and correct the error:
-Verify that a TNSNAMES.ORA file exists and is in the proper place and
accessible. See the operating system specific manual for details on the
required name and location.
-Check to see that the service name exists in one of the TNSNAMES.ORA
files and add it if necessary.
-Make sure there are no syntax errors anywhere in the file. Particularly look
for unmatched parentheses or stray characters. Any error in a
TNSNAMES.ORA file makes it unusable. See the SQL*Net V2 Net8 Messages (TNS) 25-75
-Administrator's Guide. If possible, regenerate the configuration files using
the Oracle Network Manager.
Igor Piotr I. edytował(a) ten post dnia 28.04.09 o godzinie 08:48
пропозиції роботи
