When trying to configure listener or net services of oracle database below error is received
Same time i'm unable to access in oracle net Manager unable to add or modify in Name serving.
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.75.131)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST)
)
)
C:\Documents and Settings\Administrator>netca
Oracle Net Services Configuration:
ServiceAliasException: Could not enum Net Service Names:
TNS-04404: no error
caused by:
oracle.net.config.ConfigException: TNS-04414: File error
caused by:
TNS-04605: Invalid syntax error: Unexpected char or LITERAL "PROD"
before or at PROD = (
Oracle Net Services configuration terminated by user. The exit code is -1
Same time i'm unable to access in oracle net Manager unable to add or modify in Name serving.
Solution for this Error is:
Reason : Entry in tnsnames.ora syntax is incorrect or missing some parameters.
Solution :
Check the below syntax is matching according to your SID(TEST) , IP Address(192.168.75.131) and Port (1521)
otherwise copy this below syntax and paste in your $ORACLE_HOME/network/tnsnames.ora
and change these SID,IP and Port according to your Env.
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.75.131)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST)
)
)
After doing this you can verify it whether this is ping or not using tnsping
C:\Users> tnsping TEST
No comments:
Post a Comment