Re: >>DBA HELP<<ORA-03526 local ORACLE kernel not found
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