[Spacewalk-list] Oracle connection issues after 1.0 upgrade

[Daniel Wittenberg]

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
>