السلام عليكم
قمت بتسبيت ال Oracle Developer Suite 10
و عند الدخول الي احد البرامج مثل ال Oracle 10g Designer
يطلب Username و password و Connection string
قمت بجلب ال Connection string من ال tnsnames.ora
وكانت بالشكل التالي
ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = elbaz)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
و قمت بطابعتها في حقل ال Connection string
و النتيجه
Message ------- ORA-12154: TNS:could not resolve the connect identifier specified 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 Chapter 4 in the SQL*Net V2 Administrator's Guide. If possible, regenerate the configuration files using the Oracle Network Manager. -------------------------------------------------------------------------------- Message ------- RME-00220: Failed to connect to Repository Cause ----- Failed to connect to the requested Repository. Action ------ Examine other reported errors for specific details. --------------------------------------------------------------------------------
و ايضا حاولت بهذه ال Connection string
HOST = elbaz,PORT = 1521,SERVICE_NAME = orcl
ولم تفلح ايضا
؟؟