Just spent 2 days on this error. Using instant client I needed to point
ORACLE_HOME and TNS_ADMIN to the instanclient folder and make sure the
tnsnames.ora file was inside.
On Tuesday, March 6, 2012 8:21:52 AM UTC-6, rochacbruno wrote:
>
> Does anybody knows something about this?
>
> it connects with cx_oracle and raw queries, but gives this error on DAL.
>
>
>
> 1. Traceback (most recent call last):
> 2. File "<pyshell#19>", line 1, in <module>
> 3. db = DAL("oracle://ricardo/[email protected]:1521/XE")
> 4. File "C:\Python27\lib\site-packages\gluon\dal.py", line 5968, in
> __init__
> 5. raise RuntimeError, "Failure to connect, tried %d times:\n%s" %
> (attempts, tb)
> 6. RuntimeError: Failure to connect, tried 5 times:
> 7. Traceback (most recent call last):
> 8. File "C:\Python27\lib\site-packages\gluon\dal.py", line 5955, in
> __init__
> 9. self._adapter = ADAPTERS[self._dbname](*args)
> 10. File "C:\Python27\lib\site-packages\gluon\dal.py", line 2185, in
> __init__
> 11. self.pool_connection(connect)
> 12. File "C:\Python27\lib\site-packages\gluon\dal.py", line 465, in
> pool_connection
> 13. self.connection = f()
> 14. File "C:\Python27\lib\site-packages\gluon\dal.py", line 2184, in
> connect
> 15. return self.driver.connect(uri,**driver_args)
> 16. DatabaseError: ORA-12514: TNS:listener does not currently know of
> service requested in connect descriptor
>
>
>
> --
>
> Bruno Rocha
> [http://rochacbruno.com.br]
>
>
--
