| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Check this
I think I've found the problem.. you see I cloned the database from one
machine to another with all directory structures etc the same.. however
on the new machine the ORACLE_HOME is different.. in the Listener.ora file
I had the new ORACLE_HOME specified.. when I rem (#) out the line in
listener.ora for ORACLE_HOME. and restart the listener it works...
I suspect somewhere it is referencing the old ORACLE_HOME ?????
Thanks
Saj
-- U-NET Ltd a VIA NET.WORKS Inc company Sajid Iqbal | Mail : sajid_at_u-net.net Database DBA/Developer | Ext : 4485 U-NET Ltd | ICQ : 43903417 Warrington, Cheshire, UK | On Wed, 31 May 2000, ODell, Charles wrote:Received on Wed May 31 2000 - 07:01:38 CDT
> Did the pc you are using ever have a copy of oracle running on it?
> 1034 suggest that sqlnet wants to connect locally. I'm beginning
> to suspect your registry on that pc. Other than SQL*Net has any other
> Oracle product been installed on it?
>
>
> ------------------------------------------------------------------
> ORA-1034, 9215, OSD-1050: You don't have enough free conventional memory
> (the first 640k) to work with your database. Try removing some TSR's from
> your CONFIG.SYS and AUTOEXEC.BAT files to free up more conventional memory.
> If you're sure you have plenty of conventional memory free, then this
> problem might also be solved by reinstalling the database base tables: go
> into the ORACLE6\DBS subdirectory, run SQLDBA, then enter
> "@C:\ORACLE6\DBS\INSTALL".
>
> ORA-1034, 9215, OSD-2042: The database isn't running right now. Do a
> "SQLDBA STARTUP" from a operating system prompt.
>
> ORA-1034, 9243, OSD-2042: The database isn't running right now. Go to the
> server, run SQLDBA, then enter "CONNECT INTERNAL" and "STARTUP".
>
> -----Original Message-----
> From: Sajid Iqbal [mailto:sajid_at_u-net.net]
> Sent: Wednesday, May 31, 2000 7:11 AM
> To: ODell, Charles
> Subject: RE: Check this
>
>
>
> Yep the error code is 1034..
>
> I checked the sqlnet.log file on the pc but there doesn't seem to be any
> mention of this error.. How do u turn on trace ?
>
> Saj
>
>
> On Wed, 31 May 2000, ODell, Charles wrote:
>
> > The below says you want to use port 1315 instead of the 1525 I showed
> > you in my example. The services file on the solaris must agree
> > (and probably does) with 1315. The SQLPlus failures should be logged in a
> > file sqlnet.log somewhere on the pc with the error code. Have you looked
> at
> > this?
> > Try to turn tracing on, on the pc side. What was your error code again?
> > 1034?
> >
> >
> > -----Original Message-----
> > From: Sajid Iqbal [mailto:sajid_at_u-net.net]
> > Sent: Wednesday, May 31, 2000 6:33 AM
> > To: ODell, Charles
> > Cc: ORACLE-L_at_fatcity.com
> > Subject: RE: Check this
> >
> >
> >
> > tnsping from the pc works.
> >
> > in the listener log file the pc connections are logged a here is a copy of
> > the entry -
> >
> > 31-MAY-00 11:31:10 *
> >
> (CONNECT_DATA=(SID=UNET)(CID=(PROGRAM=C:\ORAWIN95\BIN\PLUS80W.EXE)(HOST=SAJ1
> > )(USER=sajidi)))
> > * (ADDRESS=(PROTOCOL=tcp)(HOST=194.119.129.98)(PORT=1315)) * establish *
> > UNET * 0
> >
> > But in the client (pc) sqlplus it says Oracle not available.
> >
> > Saj
> >
> > --
> > U-NET Ltd a VIA NET.WORKS Inc company
> > Sajid Iqbal | Mail : sajid_at_u-net.net
> > Database DBA/Developer | Ext : 4485
> > U-NET Ltd | ICQ : 43903417
> > Warrington, Cheshire, UK |
> >
> >
> > On Wed, 31 May 2000, ODell, Charles wrote:
> >
> > > By successful, you mean the local connections made on the Solaris
> > > machine are showing up. Do you see any attempts from the PC machine?
> > >
> > > Do you have tnsping?
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: Sajid Iqbal [mailto:sajid_at_u-net.net]
> > > Sent: Wednesday, May 31, 2000 6:18 AM
> > > To: ODell, Charles
> > > Subject: RE: Check this
> > >
> > >
> > >
> > > Yes sorry.. the server is Solaris Oracle 8.0.4.
> > >
> > > The client is Win98 se . SQL*Plus: Release 8.0.5.0.0
> > >
> > > It appears as though the problem is on the server side.. as connection
> are
> > > logged as successfull (on the server) in the listener log file.
> > >
> > > Thanks
> > >
> > > Saj
> > >
> > > --
> > > U-NET Ltd a VIA NET.WORKS Inc company
> > > Sajid Iqbal | Mail : sajid_at_u-net.net
> > > Database DBA/Developer | Ext : 4485
> > > U-NET Ltd | ICQ : 43903417
> > > Warrington, Cheshire, UK |
> > >
> > >
> > > On Wed, 31 May 2000, ODell, Charles wrote:
> > >
> > > > I thought you said the PC was having trouble finding the Oracle
> > > > database.
> > > >
> > > > What version of SQLPlus are you using?
> > > >
> > > > -----Original Message-----
> > > > From: Sajid Iqbal [mailto:sajid_at_u-net.net]
> > > > Sent: Wednesday, May 31, 2000 5:03 AM
> > > > To: ODell, Charles
> > > > Subject: Re: Check this
> > > >
> > > >
> > > >
> > > > I'm on Solaris !
> > > >
> > > > --
> > > > U-NET Ltd a VIA NET.WORKS Inc company
> > > > Sajid Iqbal | Mail : sajid_at_u-net.net
> > > > Database DBA/Developer | Ext : 4485
> > > > U-NET Ltd | ICQ : 43903417
> > > > Warrington, Cheshire, UK |
> > > >
> > > >
> > > > On Tue, 30 May 2000, ODell, Charles wrote:
> > > >
> > > > > See if you have the file:
> > > > >
> > > > > c:\winnt (or windows)\system32\drivers\etc\hosts
> > > > >
> > > > > In there put the ip address of the machine you are trying to reach,
> > like
> > > > so:
> > > > >
> > > > >
> > > > > 127.0.0.1 localhost #This will always be
> here
> > > > > ###.###.###.### hroc #hroc at Chantilly
> > > > >
> > > > > and then also in the same directory check your services:
> > > > >
> > > > > kpop 1109/tcp # Pop with Kerberos
> > > > > phone 1167/udp
> > > > > oracle 1521/tcp #Oracle SQL*Net
> > version
> > > 2
> > > > > ingreslock 1524/tcp
> > > > > oracle 1525/tcp #Oracle SQL*Net
> > version
> > > 1
> > > > > maze 1666/udp
> > > > > nfs 2049/udp # sun nfs
> > > > > knetd 2053/tcp # Kerberos
 |
 |