ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Can you post the output of foloowing commands:

lsnrctl services
lsnrctl status

Can you post the content of your %ORACLE_HOME%/network/admin/listener.ora file

Did you check your tnsnames.ora and compare it to the listener status output?

Did you also add the new SID to the listener.ora file in your %ORACLE_HOME%/network/admin directory and restarted/reloaded the listener?

Either you need to add it to listener.ora or use dynamic registration by setting the local_listener parameter of the database

no.. can u tell me how to add the new SID to the listener.ora file in  %ORACLE_HOME%/network/admin directory? presently, my lister.ora file has the following content:

# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.29.57.188)(PORT = 1521))
    )
  )

Can you also post the tnsnames.ora?

I tried to create a new sid test22, host name is Arunima and there's another sid called orclimg present in the tnsnames as u can see. somehow orclimg is working fine but test22 is not.. when i'm doing C:>tnsping orclimg then it is responding properly but when i'm doing C:>tnsping test22 then it says - failed to resolve name.
This is the tnsnames.ora for oracle client.

TEST22_ARUNIMA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Arunima)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = test22)
      (SERVER = DEDICATED)
    )
  )

ORCLIMG_ARUNIMA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Arunima)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = orclimg)
      (SERVER = DEDICATED)
    )
  )

You will need to do:

tnsping test22_arunima

How did you create a new SID? Did you use DBCA to create a new database on host Arunima? 

yes, i did  tnsping test22_Arunima, this is the output.

C:\Documents and Settings\ADM>tnsping test22_Arunima

TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 29-JUN-2
010 12:17:36

Copyright (c) 1997, 2006, Oracle.  All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = Arunima)(PORT = 1521))) (CONNECT_DATA = (SID = test22) (SERVER = DEDICAT
ED)))
OK (20 msec)

-------------------------

I created a new sid by oracle enterprise manager consoleby following steps(i can't paste the screenshot here):

add database to the tree-> add database manually-> host name-Arunima, port id-1521, sid-test22, service name-test22_Arunima(this gets generated by itself when i type host name and sid). when i click on ok it creates a new database. when i want to log on to it using username - system and password- admin, connect as - sysdba, it throws the following error: SID given in connect descriptor could not be resolved.

is there any other way to create a new sid?