dhanil anupurath wrote: > I am using Sqlalchemy with Oracle backend in my project. > I am running into listener issues with the Oracle database. > > Here are the steps that I am following: > > 1. My connection string. > sqlalchemy.url=oracle://root::<password>@localhost:1521/orcdb > > 2. Environment variables ..... > export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/ > server > export PATH=$PATH:$ORACLE_HOME/bin > export LD_LIBRARY_PATH=$ORACLE_HOME/lib > export ORACLE_SID=orc10g > > The following is the error that I get when my project tries to connect > to the Oracle db.
what does sqlplus give you ? This is likely a connection issue outside the realm of SQLAlchemy. > > Traceback (most recent call last): > > File "/root/tg2env/lib/python2.4/site-packages/SQLAlchemy-0.5.6- > py2.4.egg/sqlalchemy/schema.py", line 1796, in create_all > bind.create(self, checkfirst=checkfirst, tables=tables) > File "/root/tg2env/lib/python2.4/site-packages/SQLAlchemy-0.5.6- > py2.4.egg/sqlalchemy/engine/base.py", line 1129, in create > self._run_visitor(self.dialect.schemagenerator, entity, > connection=connection, **kwargs) > File "/root/tg2env/lib/python2.4/site-packages/SQLAlchemy-0.5.6- > py2.4.egg/sqlalchemy/engine/base.py", line 1154, in _run_visitor > conn = self.contextual_connect(close_with_result=False) > File "/root/tg2env/lib/python2.4/site-packages/SQLAlchemy-0.5.6- > py2.4.egg/sqlalchemy/engine/base.py", line 1229, in contextual_connect > return self.Connection(self, self.pool.connect(), > close_with_result=close_with_result, **kwargs) > File "/root/tg2env/lib/python2.4/site-packages/SQLAlchemy-0.5.6- > py2.4.egg/sqlalchemy/pool.py", line 142, in connect > return _ConnectionFairy(self).checkout() > File "/root/tg2env/lib/python2.4/site-packages/SQLAlchemy-0.5.6- > py2.4.egg/sqlalchemy/pool.py", line 304, in __init__ > rec = self._connection_record = pool.get() > File "/root/tg2env/lib/python2.4/site-packages/SQLAlchemy-0.5.6- > py2.4.egg/sqlalchemy/pool.py", line 161, in get > return self.do_get() > File "/root/tg2env/lib/python2.4/site-packages/SQLAlchemy-0.5.6- > py2.4.egg/sqlalchemy/pool.py", line 639, in do_get > con = self.create_connection() > File "/root/tg2env/lib/python2.4/site-packages/SQLAlchemy-0.5.6- > py2.4.egg/sqlalchemy/pool.py", line 122, in create_connection > return _ConnectionRecord(self) > File "/root/tg2env/lib/python2.4/site-packages/SQLAlchemy-0.5.6- > py2.4.egg/sqlalchemy/pool.py", line 198, in __init__ > self.connection = self.__connect() > File "/root/tg2env/lib/python2.4/site-packages/SQLAlchemy-0.5.6- > py2.4.egg/sqlalchemy/pool.py", line 261, in __connect > connection = self.__pool._creator() > File "/root/tg2env/lib/python2.4/site-packages/SQLAlchemy-0.5.6- > py2.4.egg/sqlalchemy/engine/strategies.py", line 80, in connect > raise exc.DBAPIError.instance(None, None, e) > sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-12505: TNS:listener > does not currently know of SID given in connect descriptor > None None > > Please give suggestions. > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.