| installation on 9i on Linux [message #129505] |
Mon, 25 July 2005 08:46  |
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 #129619 is a reply to message #129513] |
Tue, 26 July 2005 00:18  |
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 |
 |
Mahesh Rajendran
Messages: 10708
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 |
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 1929 times)
|
|
|
|
|
|
| Re: installation on 9i on Linux [message #130118 is a reply to message #129965] |
Thu, 28 July 2005 04:47 |
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
|
|
|
|
|
|
|
|
| Re: installation on 9i on Linux [message #130338 is a reply to message #130336] |
Fri, 29 July 2005 07:52 |
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 #130356 is a reply to message #130350] |
Fri, 29 July 2005 08:41 |
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 #131311 is a reply to message #130359] |
Fri, 05 August 2005 05:13 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
