You've probably already tried the simple things:
- Confirm that the server name and port are correct. - Ensure that firewall/routing rules will allow the connection. - Try a simple connection on the same box with sqlplus. Walking through this list has helped me a number of times. On Thursday, January 24, 2013 5:27:22 PM UTC-5, Dylan Klomparens wrote: > > I have a Django program that is connecting to an Oracle database. In my > settings.py file I have this configuration: > > DATABASES = { > 'default': { > 'ENGINE': 'django.db.backends.oracle', > 'NAME': 'xe', > 'USER': 'MY_USER_NAME', > 'PASSWORD': 'abcdefghijklmnopqrstuvwxyz', > 'HOST': 'db_server.example.com', > 'PORT': '1234', > }} > > I received a strange error when attempting to load the website: > > ORA-28547: connection to server failed, probable Oracle Net admin error > > After further investigation, I sniffed the TCP traffic between the > webserver and the database server. I discovered this text in the network > communication, which I reformatted for this post: > > (DESCRIPTION= > (ADDRESS= > (PROTOCOL=TCP) > (HOST=1.2.3.4) > (PORT=1234) > ) > (CONNECT_DATA= > (SID=xe) > (CID= > (PROGRAM=httpd@webserver_hostname) > (HOST=webserver_hostname) > (USER=apache) > ) > )) > > So my question is: why is Django attempting to connect to the Oracle > database with different credentials than the ones I specified? Notably, it > is attempting to use user 'apache' instead of 'MY_USER_NAME'. The database > host IP, port, and SID are correct and what I specified. It just appears to > be the user name that is different. > > (As a side note, I suppose the password is transmitted separately in a > later portion of the log in process?) > -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/django-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.