Can some body giude me how to change the IP of a Sun Box using solaris 5.9.
I think it is ifconfig... But still I am not sure about the way to substitute the old IP with the new IP. Does this require Validation?. I am not planning to change the Host name.


Thanks in advance


Fouzan

You will not need a new validation, because the validation is dependend on the CPU Id, not the IP.

The exact command on solaris I do not know unfortunately. The ifconfig command ist the right one to change it temporarily. See manpage. But additionally you will need to change a config file (in HP-Ux it is called /etc/rc.config.d/netconf) to make the change permament (in case of a reboot).

regards

Markus

Dear Mark

Thanks for the reply. I got over the problem.
I have moved from Tbase to Oracle 10g yesterday. There are performance issues but things are mostly fine except some sessions take hell lot of time ( for example the session 'tdsls4125m000 'Maintain and confirm Backorders' is taking 20 minutes to get the first record). I think Main-table IO is the one causing the problems. Do you know anything about this session's problems.


Regards

Fouzan

Hi there,

I do not know any specific problems for this session, but ...

a) If you run oracle on the same server tbase, then any performance degration is expected, as Oracle needs much more power.

b) You will find on Oracle support a solution in regards to Performance of Oracle9i and some hidden parameters. You can try these.

d) Did you perform "analyze tables" for all tables after importing the data?


Regards

Markus

For performance problems on Oracle see also this thread (http://www.baanboard.com/baanboard/showthread.php?t=22964)

Kind regards,
Dick

@all

a) If you run oracle on the same server tbase, then any performance degration is expected, as Oracle needs much more power.

--> specify the server details

b) You will find on Oracle support a solution in regards to Performance of Oracle9i and some hidden parameters. You can try these.

--> Be carefully !! These are hidden Parameters for Oracle9, Don't set this Parameter in 10g ! Setting hidden Parameters loss Oracle Support !!
BTW, setting up a 10g Database is not easy because there are a lot of changes in the DB-Design.

d) Did you perform "analyze tables" for all tables after importing the data?

--> analyze Table in 10 g ?? not supported, try DBMS_STATS Package.
BTW: in 10g the Statistics would be generated automaticly, if it was configred --> see b)

martin

--> Be carefully !! These are hidden Parameters for Oracle9, Don't set this Parameter in 10g ! Setting hidden Parameters loss Oracle Support !!
BTW, setting up a 10g Database is not easy because there are a lot of changes in the DB-Design.

You only loose support when Oracle Support doesn't agree with the setting. As all of these paramters are advised on Oracles Support site you don't have to worry about it. And if someone complains, unsetting the parameters is as easy as setting them.

Kind regards,
Dick

To change IP address on Solaris just:
1.- Edit file /etc/hosts
2.- Determine what IPAddress you want to change and do it.
3.- Save and exit.
4.- Reboot server.

You can configure ip-address and netmask and making the interface as in following:

#ifconfig hme0 192.9.2.106 netmask 255.255.255.0 up

#ifconfig -a will now show the ip address , netmask and up status as follows :

lo0: flags= 849<UP,LOOPBACK,RUNNING,MULTICAST,IPv4> mtu 1500 inet 127.0.0.1 netmask ffff00
hme0: flags=843<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 192.9.2.106 netmask ffffff00 broadcast 192.9.2.255
ether 8:0:20:a8:2c:fc

The file /etc/netmasks is used to define netmasks for ip addresses

You can specify a particular route for a particular address as in following example

# route add -net 10.0.0.0 -netmask 255.0.0.0 172.40.30.1 1