Error ORA-02248 while trying to connect Oracle8 (8.0.5)-Client to Oracle11g Server
Hi,
I have an old Oracle installation running since 1998. I have an UNIX-HP-UX Workstation with Oracle 8.0.5 Database. The Clients are running on Windows machines. Some processes are running on the Server itself with connection to this Oracle 8.0.5 database. These processes are developed in C with Oracle ProC.
Now i'm changing the HP-UX server to an Win2003-Server with Oracle 11g database. My Windows Client program is now connecting to this Oracle 11g DB. But the Unix processes cannot switch at one time to the new system. For a short time, I want to run these processes on the Unix system, but with connection to the new Oracle 11g database.
But now, i get the error ORA-02248 " invalid option for ALTER SESSION" while starting my unix-process or while starting sqlplus.
Has anyone an idea if (and how) it is possible to connect an Oracle8 client to an Oracle11 database.
Thanks in advance
olka
I have an old Oracle installation running since 1998. I have an UNIX-HP-UX Workstation with Oracle 8.0.5 Database. The Clients are running on Windows machines. Some processes are running on the Server itself with connection to this Oracle 8.0.5 database. These processes are developed in C with Oracle ProC.
Now i'm changing the HP-UX server to an Win2003-Server with Oracle 11g database. My Windows Client program is now connecting to this Oracle 11g DB. But the Unix processes cannot switch at one time to the new system. For a short time, I want to run these processes on the Unix system, but with connection to the new Oracle 11g database.
But now, i get the error ORA-02248 " invalid option for ALTER SESSION" while starting my unix-process or while starting sqlplus.
Has anyone an idea if (and how) it is possible to connect an Oracle8 client to an Oracle11 database.
Thanks in advance
olka
ASKER
and that's my problem!
there is no alter session statement in my program. I get this error also when i want to start sqlplus (without calling directly a sql-script)
there is no alter session statement in my program. I get this error also when i want to start sqlplus (without calling directly a sql-script)
Post the syntax, please. Also, I'd like to see the glogin.sql script from your host, and the login.sql (if any) from your user home. Thirdly, results from "which sqlplus" should return something like "/u01/app/oracle/product/1
create a new db string in tnsnames.ora file at oracle 8, for oracle 11g database
and
then tnsping that db string, for example you created a new db string as ora11 in tnsnames.ora in oracle 8
$ tnsping ora11
and is it pinging properly ?
and
then tnsping that db string, for example you created a new db string as ora11 in tnsnames.ora in oracle 8
$ tnsping ora11
and is it pinging properly ?
ASKER
tnsping on server oracle11 is pinging properly.
In the meantime i have found an old test machine with Oracle 8.0.5 and 8.0.6 installed.
Connecting from 8.0.5 to Oracle11 is not working , but i can connect from 8.0.6 to my oracle 11 DB.
So i will install this 8.0.6 version on my production system.
thanks for your hints
In the meantime i have found an old test machine with Oracle 8.0.5 and 8.0.6 installed.
Connecting from 8.0.5 to Oracle11 is not working , but i can connect from 8.0.6 to my oracle 11 DB.
So i will install this 8.0.6 version on my production system.
thanks for your hints
your old client is likely issuing an alter session to set NLS_LANG. It's doing this on its own.
or a logon trigger is doing it for you.
or a logon trigger is doing it for you.
ASKER
yes, that's the same I'm thinking of. But when i don't set NLS_LANG i get a core dump with SIGSEGV. Do you know a way how to trace wo do at what time this ALTER SESSION statement ?
Do you have Toad? It comes with a an OCI monitor.
SQLMonitor.exe
This will track all activity through the Oracle Call Interface for your application.
SQLMonitor.exe
This will track all activity through the Oracle Call Interface for your application.
ASKER
yes, i have TOAD, but i have never worked with SQLMonitor. I will try this to see what happens. In the meantime I will upgrade to 8.0.6 client.
I recommend upgrading to at least a 9.2 client.
As any 8i or lower client (including 8.0.6) should be rejected by an 11g database
See metalink doc: 207303.1
As any 8i or lower client (including 8.0.6) should be rejected by an 11g database
See metalink doc: 207303.1
ASKER
I know that 8.0.6 client running against 11g database is not supported by oracle. But this solution (8.0.6) is only temporary for ~2 months. After that time i think we have finished our upgrade-project to 11g client and server.
Now the client machine is an HP-UX 10.20 unix workstation, and i don't want to change to much for that short time.
Now the client machine is an HP-UX 10.20 unix workstation, and i don't want to change to much for that short time.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Your issue is not with the 8x client, rather with your syntax. Please post your ALTER statement for further assistance.