Re: >>DBA HELP<<ORA-03526 local ORACLE kernel not found

From: Bill Manry <BManry_at_us.oracle.com>
Date: 1996/03/01
Message-ID: <4h67fv$o3q_at_inet-nntp-gw-1.us.oracle.com>#1/1


Don,
 I don't know the Mac stuff at all (sorry) but you might want to look at my followup to your earlier item about listener problems. You need something equivalent to tnsnames.ora on your Mac and it needs to contain a service entry for your AIX server. The key fields in this entry are the protocol (TCP), host (AIX hostname), TCP port on which the host listens (default is something like 1521), and the SID of the Oracle7 server on AIX. These must correspond to stuff in listener.ora on the AIX side.
I suggest you stick to SQL*Plus for your testing. The problem with SQL*DBA is that it wants to connect to a "default host" (before you ever give it a CONNECT statement) and that is confusing matters. If you've created a tnsnames service entry as described above then try connecting using scott/tiger_at_name where "name" is the service name. Also, you should be able to find an Oracle utility called "tnsping" on the Mac. You can use it to "ping" a service name and confirm that SQL*Net connections work.

/b

--
Bill Manry - Mainframe & Integration Technologies - Oracle Corp. USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.
Received on Fri Mar 01 1996 - 00:00:00 CET

Original text of this message