[Spacewalk-list] Oracle connection issues after 1.0 upgrade

[Daniel Wittenberg]

Finally had some time to dig through this and found that /etc/tnsnames.ora had gotten set to 600 during the update, set it back to 644 permissions and life is good, clients can now register again!

Dan


On May 4, 2010, at 1:02 PM, Daniel Wittenberg wrote:

> 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
>> 
>