by Tony McClur » Sun, 24 Jun 2001 08:02:22
Any attempts fail. Its some sort of environment problem.
Any ideas would be welcome. Otherwise I'll just re-install everything
again!!
Tony McClure
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!!
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
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
by david.mosci.. » Mon, 25 Jun 2001 04:17:27
> Any attempts fail. Its some sort of environment problem.
> Any ideas would be welcome. Otherwise I'll just re-install everything
> again!!
> Tony McClure
Did you read the oracle's documentation ?
You have to modify your /etc/system file.
David.
by Tony McClur » Mon, 25 Jun 2001 04:59:08
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.
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.
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
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
9. Can't build Perl's DBD::Oracle module...
10. oracle developer's/pa's - seattle
11. 'make' rule for Oracle Pro-C?