how to solve ORA-12154: TNS:could not tesolve the connect identifier specified. in oracle developer suit 10g?

Question

hi Friends

I have just installed ORACLE DEVELOPER SUIT 10g. my DATABASE is ORACLE XE(express edition) and username ,password for database is "SYSTEM","*****".
when i log in SQL PLUS witn this user name and password ,and HOST STRING=XE.it shows an ERROR = ORA-12154: TNS:could not tesolve the connect identifier specified.


my tnsname.ora is

XE =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ARUNSOROUT-PC)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) )

EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) )
(CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )

ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) )
(CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )


please help me in solving this ERROR.

Answer 1

You are missing a bracket after port number. Refer the example below



=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(Host = )(Port = ))

)

(CONNECT_DATA =

(SERVICE_NAME = )

)

)



Good luck!

§

Answer 2

Fatty coconut milk: Believe it or not, it contains good fats which are important for keeping your metabolic process ticking. One meal, like some sort of delicious Thai green curry, will be able to increase your metabolism by 5 per cent, says research published in this International Journal of Obesity.

Answer 3

Bask in the sunlight. Just 20 minutes of Vitamin D absorption every day will boost your ability to help loose weight.

Answer 4

Chew gum. Sometimes just chewing something with negligible calories inside it is all it takes. If you possibly could handle it, chew a piece of gum for one hour along with drop 11 calories. Remember to opt for the sugar-free variety.

Answer 5

Pineapple: Nibble into it to break down the proteins within your main meal and kick start out your metabolism.

Answer 6

blondes tend to be less common so they are dealt with exotically or like a novelty.