Home » Infrastructure » Linux » installation on 9i on Linux
installation on 9i on Linux [message #129505] Mon, 25 July 2005 08:46 Go to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


I have a linux box ( red hat 9) n i m trying to install 9i on it.

The software is installed without any problem but when i m trying to create a database on it, its hanging. see the scenario

I logged in as sys in Oracle . now when i m trying to take the oracle in nomount stage its hanging .


Connected to an idle instance.
SQL> spool /u01/app/oracle/product/9.2.0/assistants/dbca/logs/CreateDB.log
SQL> startup nomount pfile="/u01/app/oracle/admin/tanudb/scripts/init.ora";

now its hanging.

When i checked the shared memory --- then the output is

------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 131073 root 644 106496 2 dest
0x00000000 557058 oracle 640 4194304 1
0x00000000 589827 oracle 640 33554432 1
0x00000000 622596 oracle 640 25165824 1
0x00000000 655365 oracle 640 20971520 1
0x00000000 688134 oracle 640 25165824 1
0xc8de7cd0 720903 oracle 640 29360128 5
0x00000000 753672 oracle 777 393216 2 dest


So many oracle segments. i killed them n restarted the server bt as soon as i take the databse in nomount stage with pfile specified it hangs.

Pls help me out to come out of this situatio.

REgards,
tarun
Re: installation on 9i on Linux [message #129513 is a reply to message #129505] Mon, 25 July 2005 09:19 Go to previous messageGo to next message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
Have you configured the required kernel parameters like shmmax, shmmni, etc as documented in the installation guide?

Best regards.

Frank
Re: installation on 9i on Linux [message #129619 is a reply to message #129513] Tue, 26 July 2005 00:18 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

yea i configured the variable as per the documentation.

All the shared memory parameters as well as the semaphore values are set as per the documentation. But the moment i try to start the instance in nomount stage with a pfile specified , it hangs i.e. no response in that terminal. i m able to work in other terminals. No error message is thrown in ALERT.LOG .

Yesterday there was an increase in the count of shared memory segments but today when i tried the same , semaphore count is increased, all owned by oracle.

Pls help me to come out of this situation.

Thanks
Tarun
Re: installation on 9i on Linux [message #129743 is a reply to message #129619] Tue, 26 July 2005 08:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try invoking the initsid.ora from its default location $ORACLE_HOME/dbs.
Check the contents of initsid.ora (all parameters related to memory. may be allocated SGA is more than allowed in semaphores).
Do by anychance have LOCAL_LISTENER in initsid.ora?

Post initisid.ora,your semaphore settings and truss output (during execution of startup nomount).

Edit:
Did you install all glibc patch?

>> and truss output
Truss is not available in RH. use strace like
$strace sqlplus

[Updated on: Tue, 26 July 2005 08:39]

Report message to a moderator

Re: installation on 9i on Linux [message #129865 is a reply to message #129743] Wed, 27 July 2005 01:15 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
Hi Mahesh,

>> try invoking the initsid.ora from its default location
$ORACLE_HOME/dbs.

I did the problem is still thr, i m able to connect in idle instance bt unable to allocate the SGA, nomount hanging.

>> Do by anychance have LOCAL_LISTENER in initsid.ora?

I checked no entry is thr.

>> Check the contents of initsid.ora (all parameters related to memory. may be allocated SGA is more than allowed in semaphores).

This is my second installation on linux so dnt know hw to compare with semaphore, sorry. But posting my init file.


>> [oracle@localhost oracle]$ strace -o trace_out sqlplus

The output file trace-out is attached.

>> Semaphore values

oracle@localhost kernel]$ cat /proc/sys/kernel/sem
100 32000 100 100

>> Shared memory variables

[oracle@localhost kernel]$ cat /proc/sys/kernel/shmmax
2147483684
[oracle@localhost kernel]$ cat /proc/sys/kernel/shmmni
4096
[oracle@localhost kernel]$ cat /proc/sys/kernel/shmall
2097152


I am copying the contents of the pfile below cos i cant attach more than one file.

###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_cache_size=52914560
db_file_multiblock_read_count=16

###########################################
# Cursors and Library Cache
###########################################
open_cursors=300

###########################################
# Database Identification
###########################################
db_domain=""
db_name=tanudb

###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=/u01/app/oracle/admin/tanudb/bdump
core_dump_dest=/u01/app/oracle/admin/tanudb/cdump
timed_statistics=TRUE
user_dump_dest=/u01/app/oracle/admin/tanudb/udump

###########################################
# File Configuration
###########################################
control_files=("/u01/app/oracle/oradata/tanudb/control01.ctl", "/u01/app/oracle/oradata/tanudb/control02.ctl", "/u01/app/oracle/oradata/tanudb/control03.ctl")

###########################################
# Instance Identification
###########################################
instance_name=tanudb

###########################################
# MTS
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=tanudbXDB)"

###########################################
# Miscellaneous
###########################################
compatible=9.2.0.0.0

###########################################
# Optimizer
###########################################
hash_join_enabled=TRUE
query_rewrite_enabled=FALSE
star_transformation_enabled=FALSE

###########################################
# Pools
###########################################
java_pool_size=0
large_pool_size=8388608
shared_pool_size=31943040

###########################################
# Processes and Sessions
###########################################
processes=150

###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target=300

###########################################
# Security and Auditing
###########################################
remote_login_passwordfile=EXCLUSIVE

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=20165824
sort_area_size=524288

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDOTBS1



I want to tell you one more thing, this is a testing machine. my last installation was on the same machine , everything was same n i was able to use Oracle with linux last time. But due to some requirement we formatted this machine n installed linux again ( the same version) n now when i m trying to start oracle its not working.
Is thr any possibility that linux installation is not faulty ?
If it is so then we can format the machine n install linux again but i jst want to know the reason that why its not working this time.

I m just 2 months old in this field (DBA) so facing lots of problems.


Thanks a lot,
Tarun
  • Attachment: trace_out
    (Size: 37.12KB, Downloaded 622 times)
Re: installation on 9i on Linux [message #129965 is a reply to message #129865] Wed, 27 July 2005 08:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Lets give a try.

>>oracle@localhost kernel]$ cat /proc/sys/kernel/sem
>>100 32000 100 100

standard recomendation for SEMMSL is 250. you are using 100.

I suggest you go through this URL and do the step-by-step process.

http://www.oracle-base.com/articles/9i/Oracle9iInstallationOnRedHat9.php
Re: installation on 9i on Linux [message #130118 is a reply to message #129965] Thu, 28 July 2005 04:47 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Hi Mahesh,

That Linux box has become a total mess now, i tried Oracle on it 4 times & then continuous experiments.
And even they want to reinstall Linux again so after that installation i will try.
I have downloaded the doc, lets try it out step by step process again.

Hope for the best.

Thanks,
Tarun
icon9.gif  Re: installation on 9i on Linux [message #130335 is a reply to message #130118] Fri, 29 July 2005 07:31 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Hi Mahesh ,

I formatted that linux machine, installed linux again, and installed Oracle Software also.
All the environment variables are set as per the documentation --

>> Semaphore values

oracle@localhost kernel]$ cat /proc/sys/kernel/sem
250 32000 100 128

>> Shared memory variables

[oracle@localhost kernel]$ cat /proc/sys/kernel/shmmax
2147483684
[oracle@localhost kernel]$ cat /proc/sys/kernel/shmmni
4096
[oracle@localhost kernel]$ cat /proc/sys/kernel/shmall
2097152



Now , when i tried--

SQL> startup nomount pfile="/u01/app/oracle/admin/tanudb/scripts/init.ora";

now its hanging.


Exactly the same problem that i was encountering earlier.

I tried both ways through scripts as well as through dbca but nothing seems to work either.

Dont know what to do now.
Sad

Help me out pls.
Tarun
Re: installation on 9i on Linux [message #130336 is a reply to message #130335] Fri, 29 July 2005 07:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
why dont you try dbca? The gui tool?
Re: installation on 9i on Linux [message #130338 is a reply to message #130336] Fri, 29 July 2005 07:52 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


I tried dbca also, its hanging after 2%.

RAM is 256M n SGA is taking the size around 170M . I dnt think this is a problem.

One more thing,
Is it necessary to allocate java pool though i dnt use any java functionality.

thanks for ur prompt reply
tarun
Re: installation on 9i on Linux [message #130350 is a reply to message #130338] Fri, 29 July 2005 08:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
As clearly said in oracle installation manual
Quote:

Installation Requirements

Verify that your system meets the hardware, disk space, operating system, and other requirements for installing the Oracle9i database.
Hardware Requirements

To install the Oracle9i products included with this release, your system must meet the minimum hardware requirements listed in the following table:
Hardware Requirements
Memory A minimum of 512 MB of RAM is required to install Oracle9i Server.

A minimum of 512 MB of RAM is required to install Oracle9i Management and Infrastructure.

A minimum of 256 MB is required to install Oracle9i Client.
Re: installation on 9i on Linux [message #130356 is a reply to message #130350] Fri, 29 July 2005 08:41 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Thanks for ur reply ,

But last time i was able to install same version of Oracle on the same hardware with same OS (linux). Nothing has been changed this time.

Then due to some reasons we format it. Now whn i again tried its givin problem.

Any ways lets see, whats going to happen.

Thanks a lot
tarun
Re: installation on 9i on Linux [message #130359 is a reply to message #130356] Fri, 29 July 2005 08:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Oracle installation is not a deal here.
Creating a database would be the problem.
try toying around your SGA settings ( reduce them).
Re: installation on 9i on Linux [message #131311 is a reply to message #130359] Fri, 05 August 2005 05:13 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Hi mahesh,

Previously i was able to create the database also but it doesnt seems to happen this time.

I reduced the size of the SGA down to 130 MB but still the same problem exist.I reduced java pool to 0 .

Now i really dnt know what to do.

Anyways thanks a lot for all ur support.

tarun
Previous Topic: Oracle 10g installation on Linux (External Hard disk)
Next Topic: How to set password for a specific folder or file?
Goto Forum:
  


Current Time: Thu Dec 02 00:31:16 CST 2021