| Oracle 8.1.7 and Sun Solaris 8 - Install Fails [message #97431] |
Mon, 06 May 2002 01:58  |
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  |
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 #97985 is a reply to message #97983] |
Wed, 27 August 2003 04:16 |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
