it comes with your oracle.
Run the following tests once u install Oracle:
1)Start --> Run --> cmd
2) at the command prompt type in
tnsping
ex: if your tns entry is :
SRGTDEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cmc8asff2.ny.jpmorgan.com)(PORT = 10005))
)
(CONNECT_DATA =
(SERVICE_NAME = APPRDEV)
)
)
type in :
tnsping SRGTDEV
YOU SHUD SEE THE FOLLOWING SCREEN

ALSO YOU CAN TYPE IN sqlplus at the command prompt to make sure ur oracle is properly installed. In that case you will see the following:

No comments:
Post a Comment