ORACLE - any idea with 'ORA-03114 not connected to ORACLE'

ORACLE - any idea with 'ORA-03114 not connected to ORACLE'

Post by Tony McClur » Sun, 24 Jun 2001 08:02:22



I am new to Solaris, and just installed the operating system and the 'bonus'
Oracle software from the media kit onto an Intel platform . The installation
worked but failed to
create a starter database. I get 'ORA-03114 not connected to ORACLE'
whenever I try to create a database (either thru dbassist or server
manager).

Any attempts fail. Its some sort of environment problem.

Any ideas would be welcome. Otherwise I'll just re-install everything
again!!

Tony McClure

 
 
 

ORACLE - any idea with 'ORA-03114 not connected to ORACLE'

Post by G.T. » Sun, 24 Jun 2001 08:25:58



> I am new to Solaris, and just installed the operating system and the 'bonus'
> Oracle software from the media kit onto an Intel platform . The installation
> worked but failed to
> create a starter database. I get 'ORA-03114 not connected to ORACLE'
> whenever I try to create a database (either thru dbassist or server
> manager).

> Any attempts fail. Its some sort of environment problem.

> Any ideas would be welcome. Otherwise I'll just re-install everything
> again!!

Re-installing won't work, been there, done that, installed Oracle on
three different Solaris 8 installations following the Oracle defaults
and no go.  Here is what somebody sent me to get this going:

This did the trick - try changing your semaphore setting on  parameter
SEMMNS from the suggested 200 to 2000 in /etc/system; reboot.  Then
remove
all SID instances by deleting from dbassist and then manually removing
file
instances.  I then ran dbassist to create a new database.

I set SEMMNS to 2000 but I have a feeling it will work as low as 300.
It definitely does not work with the suggested 200 on Solaris 8 01/01,
Solaris 8 01/01 MU4, and Solaris 8 04/01 on a Blade 100.  Maybe the
Oracle suggestions were for Solaris 7 and before.

Greg

 
 
 

ORACLE - any idea with 'ORA-03114 not connected to ORACLE'

Post by Dave Uhrin » Sun, 24 Jun 2001 11:22:03




>> I am new to Solaris, and just installed the operating system and the
>> 'bonus' Oracle software from the media kit onto an Intel platform . The
>> installation worked but failed to
>> create a starter database. I get 'ORA-03114 not connected to ORACLE'
>> whenever I try to create a database (either thru dbassist or server
>> manager).

>> Any attempts fail. Its some sort of environment problem.

>> Any ideas would be welcome. Otherwise I'll just re-install everything
>> again!!

> Re-installing won't work, been there, done that, installed Oracle on
> three different Solaris 8 installations following the Oracle defaults
> and no go.  Here is what somebody sent me to get this going:

> This did the trick - try changing your semaphore setting on  parameter
> SEMMNS from the suggested 200 to 2000 in /etc/system; reboot.  Then
> remove
> all SID instances by deleting from dbassist and then manually removing
> file
> instances.  I then ran dbassist to create a new database.

> I set SEMMNS to 2000 but I have a feeling it will work as low as 300.
> It definitely does not work with the suggested 200 on Solaris 8 01/01,
> Solaris 8 01/01 MU4, and Solaris 8 04/01 on a Blade 100.  Maybe the
> Oracle suggestions were for Solaris 7 and before.

> Greg

You are correct and when he posted this question to alt.solaris.x86 my
answer failed to provide this information.  The values required are in the
white paper at http://www.dbspecialists.com.
 
 
 

ORACLE - any idea with 'ORA-03114 not connected to ORACLE'

Post by david.mosci.. » Mon, 25 Jun 2001 04:17:27



> I am new to Solaris, and just installed the operating system and the 'bonus'
> Oracle software from the media kit onto an Intel platform . The installation
> worked but failed to
> create a starter database. I get 'ORA-03114 not connected to ORACLE'
> whenever I try to create a database (either thru dbassist or server
> manager).

> Any attempts fail. Its some sort of environment problem.

> Any ideas would be welcome. Otherwise I'll just re-install everything
> again!!

> Tony McClure

Hello,

Did you read the oracle's documentation ?

You have to modify your /etc/system file.

David.

 
 
 

ORACLE - any idea with 'ORA-03114 not connected to ORACLE'

Post by Tony McClur » Mon, 25 Jun 2001 04:59:08


Many thanks for the help on this, I now have it working after increasing the
SEMMNS kernel variable.

Tony McClure



> > I am new to Solaris, and just installed the operating system and the
'bonus'
> > Oracle software from the media kit onto an Intel platform . The
installation
> > worked but failed to
> > create a starter database. I get 'ORA-03114 not connected to ORACLE'
> > whenever I try to create a database (either thru dbassist or server
> > manager).

> > Any attempts fail. Its some sort of environment problem.

> > Any ideas would be welcome. Otherwise I'll just re-install everything
> > again!!

> > Tony McClure

> Hello,

> Did you read the oracle's documentation ?

> You have to modify your /etc/system file.

> David.

 
 
 

ORACLE - any idea with 'ORA-03114 not connected to ORACLE'

Post by Dave Uhrin » Mon, 25 Jun 2001 00:11:51




> > I am new to Solaris, and just installed the operating system and the
'bonus'
> > Oracle software from the media kit onto an Intel platform . The
installation
> > worked but failed to
> > create a starter database. I get 'ORA-03114 not connected to ORACLE'
> > whenever I try to create a database (either thru dbassist or server
> > manager).

> > Any attempts fail. Its some sort of environment problem.

> > Any ideas would be welcome. Otherwise I'll just re-install everything
> > again!!

> > Tony McClure

> Hello,

> Did you read the oracle's documentation ?

> You have to modify your /etc/system file.

> David.

Those same kernel parameters are recommended for a Linux install, but they
are unnecessary there.  /etc/system in Solaris certainly must be modified
according to the recommendations.
 
 
 

1. Oracle listener.ora looks fine, but doesn't work

Hi,I've installed Oracle 8.0.5 on RH 6.0 (which is working great) and am now
trying to start the listener, which won't start.listener.ora looks like
this:#LISTENER =  (ADDRESS_LIST =  (ADDRESS= (PROTOCOL=
TCP)(Host=localhost)(Port= 1521))  )SID_LIST_LISTENER =  (SID_LIST =
(SID_DESC =  (ORACLE_HOME= /u01/app/oracle/product/8.0.5)  (SID_NAME = shop)
)  )The network file in /etc/sysconfig
isNETWORKING=YESHOSTNAME=localhostDOMAINNAME=thecitylofts.cometc.The error is
what everyone else gets but it turns out to be a typo:TNS-01150: The address
of the specified listener name is incorrectNL-00303: syntax error in NV
stringI've pored through the Net8 admin guide, scoured the newsgroups, but
have had no luck.I must be missing something. What is it?Thanks in
advance,Andre'

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

2. ** How to create an FTP Account ? **

3. New Oracle New Solaris v's Old Oracle Old Windows

4. Kernel selection guide

5. Ellison says Oracle's 'whole business' to run on Linux

6. Linux - Workgroup E-Mail Setup

7. Oracle's Big Linux Bet: Not Just For Customers

8. netscape 2.02

9. Can't build Perl's DBD::Oracle module...

10. oracle developer's/pa's - seattle

11. 'make' rule for Oracle Pro-C?

12. Oracle ORA-01019 Error

13. ``limit'' in Oracle?