Home » Infrastructure » Unix » Oracle 8.1.7 and Sun Solaris 8 - Install Fails
Oracle 8.1.7 and Sun Solaris 8 - Install Fails [message #97431] Mon, 06 May 2002 01:58 Go to next message
Pat Dolan
Messages: 3
Registered: May 2002
Junior Member
Under Oracle Database Configuration Assistant:

I am unable to get Oracle up-and-running on a Sun Solaris 8 machine. I am getting exactly the same problem as outlined in http://www.orafaq.net/msgboard/unix/messages/1208.htm.

As per suggested remedial action, I tried upping the quoted parameter from 200 to 600, then 1000, then 10000 (!) and the Error messages:

ORA-03114: not connected to ORACLE and
ORA-01034: ORACLE not available

persist.

In /etc/system:
set semsys:seminfo_semmns=200, then 600, then 1000, then 10000.

I hope someone can help!?! Many thanks --> Pat Dolan
Re: Oracle 8.1.7 and Sun Solaris 8 - Install Fails [message #97433 is a reply to message #97431] Mon, 06 May 2002 09:10 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
Setting semiphores to 1000 is enough. Make sure all your environment variables are set. Where is this error generated from on the server or client? Make sure your SID parameter in the tnsnames.ora and listener.ora match your case on the server. Also make sure you have ORACLE_SID set correctly and $ORACLE_HOME is specified correctly in your listener.ora file.
Re: Oracle 8.1.7 and Sun Solaris 8 - Install Fails [message #97983 is a reply to message #97431] Wed, 27 August 2003 01:50 Go to previous messageGo to next message
choi soo young
Messages: 1
Registered: August 2003
Junior Member
i same case(i use Solaris x86, oracle8.1.7i..)

if you resolve --> Please Help me....
Re: Oracle 8.1.7 and Sun Solaris 8 - Install Fails [message #97985 is a reply to message #97983] Wed, 27 August 2003 04:16 Go to previous messageGo to next message
Mark
Messages: 284
Registered: July 1998
Senior Member
it seems to be a connection made by a database user, is it?
try to start up only instance:
sqlplus internal
startup nomount

(verify if exists a pfile and matching with your ORACLE_SID enviroment variable)

if instance start, you can discard system memmory allocation problem.

let me know about it
Re: Oracle 8.1.7 and Sun Solaris 8 - Install Fails [message #98081 is a reply to message #97431] Tue, 27 January 2004 22:51 Go to previous message
Mahmoud
Messages: 5
Registered: November 2001
Junior Member
hi ,
Set to the sum of the PROCESSES parameter for each Oracle database, adding the largest one twice, then add an additional 10 for each database. For example, consider a system that has three Oracle instances with the PROCESSES parameter in their initsid.ora files set to the following values:

ORACLE_SID=DIA1, PROCESSES=100
ORACLE_SID=DIA2, PROCESSES=100
ORACLE_SID=DIA3, PROCESSES=200

The value of SEMMNS is calculated as follows:

SEMMNS = [[(A=100) + (B=100)]] + [[(C=200) * 2]] + [[(# of instances=3) * 10]] = 630

Setting parameters too high for the operating system can prevent the machine from booting up. Refer to Sun Microsystems Sun SPARC Solaris system administration documentation for parameter limits.

*
* Kernel Parameters on our SUN Enterprise with 640MB or (256mb) for Oracle 8.1.x
*
set shmsys:shminfo_shmmax=4294967295 or (20971520)
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmns=2500 or (2000)
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767

thanks
Mahmoud
Previous Topic: Uploading files from Client (NT) Machine to UNIX server
Next Topic: monitoring oracle database tables from korn shell script and sending e-mail
Goto Forum:
  


Current Time: Sat Jan 16 12:01:10 CST 2021