[Spacewalk-list] Oracle connection issues after 1.0 upgrade
Daniel Wittenberg
dwittenberg2008 at gmail.com
Tue May 4 18:02:51 UTC 2010
Just realized my first update bounced..
Dan
> More woes since the 1.0 update...looks like it won't connect to oracle now, but if I do it from sqlplus using info in /etc/rhn/rhn.conf it works fine:
>
> 2010/05/04 12:20:07 -04:00 26914 1.2.3.4: rhnSQL/driver_cx_Oracle.connect('Connecting to database', 'XE')
> 2010/05/04 12:20:07 -04:00 26914 1.2.3.4: rhnSQL/driver_cx_Oracle.connect('ERROR', 'Connection attempt failed', 12154, 'ORA-12154: TNS:could not resolve the connect identifier specified\n')
>
>
> /etc/rhn/rhn.conf
> default_db = username/password at XE
>
> db_backend = oracle
> db_user = username
> db_password = password
> db_name = XE
> db_host = localhost
> db_port = 1521
>
> # cat /etc/tnsnames.ora
> XE =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = XE)
> )
> )
>
>
> Any thoughts? I'm not a Oracle dba by any means, pretty good with mysql/postgres but not oracle.
>
> Thanks!
> Dan
>
More information about the Spacewalk-list
mailing list