Re: ora-12663 Services req'd by client not available on Server

Don Hall <dhall_at_twoil.com> writes:

> I am currently migrating from a 7.3.3 server to an 8.0.5 version of the
> database. A database link 'db73' has been created on the new server.
> In Plus80w, I can execute the statement "create table ver8_tab as select
> * from ver7_tab_at_db73" and that works with no problem. However, if I try
> "Describe ver7_tab_at_db73", I receive the ora-12663 error. I believe I
> have seen this work before at another site, but I have not found a
> resolution at my location. Does anyone have any ideas on what is
> causing this error?
> Thanks,
> Don Hall
> Transworld Oil USA
>

I can't explain why the create table statement works while the describe fails. They should succeed/fail in the same way.

However, an ORA-12663 is usually caused by the client requiring Advanced Security Option encryption or checksumming but ASO has not been installed on the server.

To fix it, you can either install ASO on the server or disable encryption and checksumming on the client.

--

                                        Rick
                                        Rick Wessman
                                        Security and Directory Technologies
                                        Server Technologies
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com