Toad World® Forums

spotlight for rac


#1

I am trying to configure the spotlight but appear the following error message ora-12514 when trying to connect, i send the configuration tnsnames.ora. the conection with toad work fine

webcr=

(DESCRIPTION=

(FAILOVER=on)

(LOAD_BALANCE=on)

(ADDRESS_LIST=

  (ADDRESS=

    (PROTOCOL=TCP)

    (HOST=mhoidsa05_vip.minhacienda.gov.co)

    (PORT=1521)

  )

  (ADDRESS=

    (PROTOCOL=TCP)

    (HOST=mhoidsa06_vip.minhacienda.gov.co)

    (PORT=1521)

  )

)

(CONNECT_DATA=

  (FAILOVER_MODE=

    (TYPE=select)

    (METHOD=basic)

  )

  (SERVER=dedicated)

  (SERVICE_NAME=webcr)

)

)


#2

This is the Toad for Oracle forum. The Spotlight forum is here: www.toadworld.com/…/125.aspx


#3

There are multiple reasons why this could be happening. Do you have any problems connecting with sqlplus with tns entry?

To get Spotlight connecting for you in the short term, I would bypass the tnsnames lookup by using EZConnect - hostname:PortNo/Sid or service name as indicated in the screenshot.

To establish why the tnsnames lookup is failing I would recommend you raise a support case and this can be looked at in more detail,

Regards,

Paul

spotlight_ezconnect_example.png