Listener

[scohan]

I'm trying to get my sid set up to be accessed remotely (unsuccessfully). There's another sid setup (not by me) on this Solaris box that I can access get to from sqlplus id/pw@SID, but I can't get my db to work that way even trying to duplicate their definition in tnsnames.ora and listener.ora. Can someone enlighten me? Using the Oracle 8 book, I've defined my service name in tnsnames.ora as:

LRO_DEV = (DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)(HOST = 38.204.12.37)(PORT = 1521))
(CONNECT_DATA =
(SID = lroldev)))


And in listener.ora:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 38.204.12.37)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = 38.204.12.37)(PORT = 2481))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/bin/oracle/app/oracle/product/8.1.5)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = loanrate)
(ORACLE_HOME = /opt/bin/oracle/app/oracle/product/8.1.5)
(SID_NAME = orcl)
)
(SID_DESC =
(SID_NAME = lroldev)
(ORACLE_HOME = /opt/bin/oracle/app/oracle/product/8.1.5)
)
)

In my initlroldev..ora fiel I have:

db_name = lrodevdb
instance_name=lroldev
service_names = lrodevdb


Thanks.