Can't use xe as sid
Hi,
I set up 11g XE in OL5.8. I don't know why I get these and can't connect to it using XE as sid.
SQL> conn system/???@xe as sysdba
ERROR:
ORA-12541: TNS:no listener
SQL> conn system/??? as sysdba
Connected.
while I've put this in tnsnames using the relevant IP of the machine as the host.
XE =
(DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ?.?.255.127)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
Many Thanks & Best Regards,
HuaMin