listner problem

From: Pradeep <agarwalp_at_eeism.com>
Date: 12 Jan 2006 00:23:51 -0800
Message-ID: <1137054231.224669.82100@g14g2000cwa.googlegroups.com>

below is my listener.ora, tnsnames.ora and sqlnet.ora. I think there is no problem with these files, but i am still not able to connect to the database. I have oracle8.0 on Win2K

LISTENER =
  (ADDRESS_LIST =
(ADDRESS=

          (PROTOCOL= TCP)
          (Host= oracle)
          (Port= 1521)
        )
        (ADDRESS=
          (PROTOCOL= TCP)
          (Host= oracle)
          (Port= 1526)
        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = 0
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = ORCL)

    )
    (SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)

    )
  )
PASSWORDS_LISTENER = (oracle)

tnsnames.ora

extproc_connection_data.world =
  (DESCRIPTION =
    (ADDRESS =

        (PROTOCOL = IPC)
        (KEY = EXTPROC0)

    )
    (CONNECT_DATA = (SID = extproc)
    )
  )

orcl =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = DEDICATED)
(SID = orcl)

    )
  )

sqlnet.ora

TRACE_LEVEL_CLIENT = OFF
#sqlnet.authentication_services = (NONE) names.directory_path = (TNSNAMES, HOSTNAME) #names.default_domain = world (it is commented) #name.default_zone = world (it is commented) automatic_ipc = off

I tried.

SQL> connect sys/change_on_install_at_orcl as sysdba ERROR:
ORA-01031: insufficient privileges

SQL> connect / as sysdba
ERROR:
ORA-12203: TNS:unable to connect to destination

SQL> connect /@orcl as sysdba
ERROR:
ORA-01031: insufficient privileges

SQL> connect sys/change_on_install_at_orcl
ERROR:
ORA-01034: ORACLE not available

Kindly suggest where am i doing wrong. Received on Thu Jan 12 2006 - 02:23:51 CST