尝试用Django连接远程Oracle数据库时出现奇怪的错误

Question

我正在使用Python 2.6和Django 1.2.3 Final。

每当我尝试运行'inspectdb'或者其他任何需要连接到这个远程Oracle数据库的操作时，我都会遇到以下错误：

Traceback (most recent call last):
  File "manage.py", line 11, in <module>
    execute_manager(settings)
  File "/var/www/local/server-env/lib/python2.6/site-packages/django/core/management/__init__.py", line 438, in execute_manager
    utility.execute()
  File "/var/www/local/server-env/lib/python2.6/site-packages/django/core/management/__init__.py", line 379, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/var/www/local/server-env/lib/python2.6/site-packages/django/core/management/base.py", line 191, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/var/www/local/server-env/lib/python2.6/site-packages/django/core/management/base.py", line 220, in execute
    output = self.handle(*args, **options)
  File "/var/www/local/server-env/lib/python2.6/site-packages/django/core/management/base.py", line 351, in handle
    return self.handle_noargs(**options)
  File "/var/www/local/server-env/lib/python2.6/site-packages/django/core/management/commands/inspectdb.py", line 22, in handle_noargs
    for line in self.handle_inspection(options):
  File "/var/www/local/server-env/lib/python2.6/site-packages/django/core/management/commands/inspectdb.py", line 32, in handle_inspection
    cursor = connection.cursor()
  File "/var/www/local/server-env/lib/python2.6/site-packages/django/db/backends/__init__.py", line 75, in cursor
    cursor = self._cursor()
  File "/var/www/local/server-env/lib/python2.6/site-packages/django/db/backends/oracle/base.py", line 361, in _cursor
    self.connection = Database.connect(conn_string, **self.settings_dict['OPTIONS'])
cx_Oracle.DatabaseError: Error while trying to retrieve text for error ORA-12505

Answer 1

很可能，你在settings.py文件中的数据库连接设置上犯了错误。检查一下这些设置，确保一切都是正确的。

http://www.cryer.co.uk/brian/oracle/ORA12505.htm

Answer 2

一般来说，当你遇到难以理解的错误信息时，可以去网上搜索一下。在这个情况下，软件的组织非常专业，有明确的错误信息编号和错误信息手册。你只需要在网上搜索一下 google("ORA-12505") 就可以了。