[Spacewalk-list] rhnpush error -> ORA-12519: TNS:no appropriateservice handler found

Santi Saez santi at hostalia.com
Thu Oct 30 12:58:50 UTC 2008


El 29/10/2008, a las 0:32, Paul M. Dyer escribió:

> Just a guess, check that you have ORACLE_SID, ORACLE_HOME, and  
> maybe LD_LIBRARY_PATH set in the environment before doing the push.
>
> Second, login as the owner of the XE database and check that the  
> listener is running:
>> su - oracle
>> lsnrctl services
>> ps -ef |grep tns
>
> These are debugging steps.  I don't have an answer.

Thanks for the help.

Problem solved with this:

SQL> alter system set processes = 400 scope=spfile;
SQL> alter system set "_optimizer_filter_pred_pullup"=false  
scope=spfile;
SQL> alter system set "_optimizer_cost_based_transformation"=off  
scope=spfile;

Regards,

--
Santi Saez





More information about the Spacewalk-list mailing list