Home » Infrastructure » Unix » remote 9i installation on solaris 9
remote 9i installation on solaris 9 [message #131516] Mon, 08 August 2005 00:02 Go to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
Hi to all,

I want to install oracle 9i from a remote Windows XP machine on a Solaris 9 machine.
Can i install oracle 9i on a solaris 9 machine remotely.
The scenario is that the Oracle 9i software is stored on solaris machine but i need to install it from a remote machine.

i m able to access that machine using ssh and i m able to login to that machine as root.

Any specific actions to be performed remotely. Any precautions need to be taken.


Any help will be appreciated.

thanks,
tarun

[Updated on: Mon, 08 August 2005 01:22]

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #131581 is a reply to message #131516] Mon, 08 August 2005 07:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> Any specific actions to be performed remotely. Any precautions need to be taken.
Nothing.
All you need is an emulator like Exceed (if you use GUI to install oracle in unix box).
And Set your Display to the local windows machine

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #131590 is a reply to message #131581] Mon, 08 August 2005 08:35 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Hi mahesh,

Thanks for ur reply. I hav downloaded exceed 10 and whn i m trying to login to the machine through startup type telnet then i m not able to log in whereas i can telnet that solaris machine from my command prompt. There i m not facing any problem.

And when i m using exceed , do i still need to set DISPLAY variable . if yes then pls tell me how do i set from windows.

Any suggestions for me to implement.

thanks,
tarun

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #131623 is a reply to message #131590] Mon, 08 August 2005 12:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
invoke the Exceed application that allows you work with X-windows.
Login to the remote machine (ssh or anyway you want. I never use telnet).
in the unix machine, set your display to point to your windows machine.
from unix machine, invoke sqlldr, the display / GUI should popup in windows machine.

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #131704 is a reply to message #131623] Tue, 09 August 2005 01:48 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


thanks mahesh for all the information.

now i m able to access that machine.

regards,
tarun

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #131915 is a reply to message #131623] Wed, 10 August 2005 01:28 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Hi mahesh,

I was able to install Oracle remotely and when i tried to create the database manually as well as using dbca, i got same set of errors.

ORA-27302: failure occurred at: skgwreset1
ORA-27303: additional information: invalid shared ctx
ORA-27146: post/wait initialization failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: Os failure message: No space left on device
ORA-27302: failure occurred at: sskgpcreates

Same set of error messages r there in the alert file also.

I set the environment variables to following values :

shmmax = 4294967295
shmmin = 1
shmmni = 100
shmseg = 10
semmns = 2000
semmsl = 1000
semmni = 100

RAM on server is 8 GB.

Following are the entries in the pfile.

##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################

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

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

###########################################
# Database Identification
###########################################
db_domain=""
db_name=testdb

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

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

###########################################
# Instance Identification
###########################################
instance_name=testdb

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

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

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

###########################################
# Pools
###########################################
java_pool_size=33554432
large_pool_size=8388608
shared_pool_size=115343360

###########################################
# 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=25165824
sort_area_size=524288

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


Do i need to reduce the processes entry in my pfile or any other suggestions.
Remember i m trying to create the database remotely and i cannot access that SOLARIS server thats why i m using Hummingbird exceed to do so.

Pls help me ASAP.

thanks ,
tarun

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #131961 is a reply to message #131915] Wed, 10 August 2005 03:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Change the semaphores to
SEMMNI 100
SEMMNS 1024
SEMMSL 256
try again.

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #131971 is a reply to message #131961] Wed, 10 August 2005 03:59 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

hi mahesh,

I did the changes u specified and then tried to

SQL> show user
USER is "SYS"
SQL> startup nomount pfile=/data1/u01/app/oracle/admin/testdb/scripts/init.ora
ORA-27302: failure occurred at: skgpwreset1
ORA-27303: additional information: invalid shared ctx
ORA-27146: post/wait initialization failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpcreates


Now really dont know what to do?

thanks,
tarun

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #132009 is a reply to message #131971] Wed, 10 August 2005 07:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
YOu might not done it properly.
Edit the /etc/system as root.
edit the values.
reboot.
try again.
If you have done this above, post your values from /etc/system
and

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #132010 is a reply to message #132009] Wed, 10 August 2005 07:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
But holdon.

In your previous posting:
>>I set the environment variables to following values :
>>shmmax = 4294967295
>>shmmin = 1
>>shmmni = 100
>>shmseg = 10
>>semmns = 2000
>>semmsl = 1000
>>semmni = 100

These are not environment variables. These are semaphore settings.

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #132012 is a reply to message #132010] Wed, 10 August 2005 07:09 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

oops sorry for the writing mistakes. I hav jst checked /etc/system file and rebooted the server.

tell u the latest after trying once again.

thanks,
tarun

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #132025 is a reply to message #132012] Wed, 10 August 2005 07:41 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Hi mahesh,

see the steps,

>> I logged into that solaris machine as root and changed the semaphore settings as mentioned. and excerpt from /etc/system file

Quote:

* set:
*
* Set an integer variable in the kernel or a module to a new value.
* This facility should be used with caution. See system(4).
*
* Examples:
*
* To set variables in 'unix':
*
* set nautopush=32
* set maxusers=40
*
* To set a variable named 'debug' in the module named 'test_module'
*
* set test_module:debug = 0x13
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_semmns=1024
set shmsys:shminfo_semmsl=256
set shmsys:shminfo_semmni=100
* Begin MDD root info (do not edit)
forceload: misc/md_trans
forceload: misc/md_raid
forceload: misc/md_hotspares
forceload: misc/md_sp
forceload: misc/md_stripe
forceload: misc/md_mirror
forceload: drv/sbus
forceload: drv/isp
forceload: drv/sd
rootdev:/pseudo/md@0:0,0,blk



>> Then i restarted the server using command

>init 6

>> Then i logged in as oracle user using EXCEED and tried the command. this is the excerpt from that prompt

Quote:


Sun Microsystems Inc. SunOS 5.9 Generic May 2002
$ sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Aug 10 08:26:32 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: / as sysdba
Connected to an idle instance.



SQL> startup nomount pfile=/data1/u01/app/oracle/admin/testdb/scripts/init.ora
ORA-27302: failure occurred at: skgpwreset1
ORA-27303: additional information: invalid shared ctx
ORA-27146: post/wait initialization failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpcreates






Now tell me what should be my next step to come up with the database. and one more thing i have reduced the processes from 150 to 50 .

thanks,
tarun

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #132037 is a reply to message #132025] Wed, 10 August 2005 08:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Your semaphores settings are wrong.

Look into this. This is mine.
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmns=3025
set semsys:seminfo_semmni=100
set semsys:seminfo_semmnu=3025
set semsys:seminfo_semmsl=3025
set msgsys:msginfo_msgmax=8192
set msgsys:msginfo_msgmnb=16384
set msgsys:msginfo_msgmni=3600


Some are shmsys.
Some are semsys.
You are not using semsys at all.
Your last three parameters should be semsys:xxxxx
Do not try the same settings. It may not work for you.
try with
SEMMNI 100 -- same as mine
SEMMNS 1024-- mine is different
SEMMSL 256 -- mine is different.

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #132046 is a reply to message #132037] Wed, 10 August 2005 09:13 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


AT last a sign of relief.

Thanks a lot mahesh, u r really genius.
How can i do such a silly mistake ? U know jst to save some typing i copied and pasted and thats how it happened.

Now SGA is allocated and i m running the remaining scripts and hopefully now i should not face any problem.

thanks a lot again,
tarun

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #352160 is a reply to message #132046] Mon, 06 October 2008 07:03 Go to previous messageGo to next message
srilakshmibh
Messages: 3
Registered: October 2008
Location: Mumbai
Junior Member
Hi

Can any one please help me on this:

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmns=3025
set semsys:seminfo_semmni=100
set semsys:seminfo_semmnu=3025
set semsys:seminfo_semmsl=3025
set msgsys:msginfo_msgmax=8192
set msgsys:msginfo_msgmnb=16384
set msgsys:msginfo_msgmni=3600

What is the significance on having a # infront of any of the syntax in /etc/system/ file

Like:

#set shmsys:shminfo_shmmax=4294967295
#set shmsys:shminfo_shmmin=1
#set shmsys:shminfo_shmmni=100

Thanks a lot

Regards,
Srilakshmi

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #352161 is a reply to message #352160] Mon, 06 October 2008 07:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>What is the significance on having a # infront of any of the syntax in /etc/system/ file
Anything following # is just a comment.

[Updated on: Mon, 06 October 2008 07:10]

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #352163 is a reply to message #352161] Mon, 06 October 2008 07:15 Go to previous messageGo to next message
srilakshmibh
Messages: 3
Registered: October 2008
Location: Mumbai
Junior Member
Hi,

Thanks for the reply, but in the /etc/system/ file any thign starting with * looks like a comment, so needed to ask about the significance of line starting with #.

The typical system file with me is:

* vxfs_START -- do not remove the following lines:
* VxFS requires a stack size greater than the default 8K.
* The following value allows the kernel stack size to be
* increased to 24K.
set rpcmod:svc_default_stksize=0x6000
* vxfs_END
#set shmsys:shminfo_shmmax=4294967295
#set shmsys:shminfo_shmmin=1
#set shmsys:shminfo_shmmni=5000

Thanks,
Srilakshmi

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #352181 is a reply to message #352163] Mon, 06 October 2008 09:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Both are valid, I suppose.

Report message to a moderator

Re: remote 9i installation on solaris 9 [message #352186 is a reply to message #352181] Mon, 06 October 2008 09:18 Go to previous message
srilakshmibh
Messages: 3
Registered: October 2008
Location: Mumbai
Junior Member
Ok Thank you very much
I will check this

Report message to a moderator

Previous Topic: Controlling PL/SQL execution from UNIX script (merged 3)
Next Topic: Slow application
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 16:54:13 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.