oracle 9i tns / listener problems

I've just finished installing 9i enterprise on my RedHat 7.1 Server.

(A very painful experience I might add)

I believe that the installation was successful. I completed all of the install steps including net config and dbca.

Here's my problem -

While I'm pretty sure that everything was configured properly, I can not connect to the database.

I can not tnsping successfully either. When I try bin/tnsping localhost from the oracle home I get error TNS-12541: TNS:no listener.  (I realize that this uses HOSTNAME to resolve) When I try bin/tnsping ORADB_ORADB.REDSAND or bin/tnsping oradb or any other variation of tnsping that I can think of I get error TNS-03505: TNS: Failed to resolve name.

I've included the vitals below.....

My Linux Hostname + Domain:

RedSand1.Sandboxes

My listener.ora file is as follows:

LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =
(ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = RedSand1.Sandboxes)(PORT = 1521))

      )

(ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))       )

    )

  )

SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =
(SID_NAME = PLSExtProc)

(ORACLE_HOME = /usr/oracle/OraHome)

(PROGRAM = extproc)

    )

    (SID_DESC =
(GLOBAL_DBNAME = oradb.redsand1)

(ORACLE_HOME = /usr/oracle/OraHome)

(SID_NAME = oradb)

    )

  )

My tnsnames.ora file is as follows:

INST1_HTTP.REDSAND1 =   (DESCRIPTION =     (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = RedSand1.Sandboxes)(PORT =
1521))

    )

    (CONNECT_DATA =
(SERVER = SHARED)

(SERVICE_NAME = MODOSE)

(PRESENTATION = http://HRService)

    )

  )

EXTPROC_CONNECTION_DATA.SANDBOXES =   (DESCRIPTION =     (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )

    (CONNECT_DATA =
(SID = PLSExtProc)

(PRESENTATION = RO)
    )

  )

ORADB_ORADB.REDSAND =   (DESCRIPTION =     (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = RedSand1.Sandboxes)(PORT =
1521))

    )

    (CONNECT_DATA =
(SID = oradb)

(SERVICE_NAME = oradb.redsand)

(SERVER = DEDICATED)
    )

  )

I consider myself a novice with Oracle and would greatly appreciate any help.

Thanks in advance.

Joel Received on Wed Feb 13 2002 - 22:29:54 CST