Hi,

I am working with SUSE Linux 10 SP2 and this is a production server. Now the issue is "su - oracle" is taking more than 10 seconds of time where as it was not taking more than one second before for the same. Because of this may be the tar command is also running very slow and taking double the time to zip files when compared to previous results. Please suggest what might be the reason for it.

Thanks&regards,
Natraj

Does your initial login to the server take a long time? The most common reason I've seen logins/switching users take time is because they do quota checks (even if you haven't enabled quotas). The quota check hangs because it tries to check quota on things like NFS mounts from other servers that are no longer available on the local server. This happens if the other server gets shutdown or the mount is no longer exported with permissions for the local server.

In such a situations "df -hP" would also likely hang.

You can check /etc/mtab to see if it lists any filesystems mounted (look for colon [:] in the entries). Do NOT edit /etc/mtab.

You can try to do "umount -f" on the hung filesystem to force unmount it. Failing that you can try "umount -l" to lazy unmount it.

If the issue is not a hung NFS mount it is likely your profiles or bashrc files or other environment files of the oracle user are doing something that is taking more time than in the past. You could try doing:
su oracle (Not su - oracle)
set -x
cd ~oracle
. ./.bashrc

That will make it go to the home directory of user, oracle, then execute what should be its first environmental file (assuming it is using bash shell) then ideally that would step through everything else it is doing.

To add to what MensaWater said, you seem to have omitted a LOT of things. Also, you do realize that SLES 10 was END OF LIFE/unsupported since 2008?? From Suse's website
...and you're STILL running a production server on it?? With Oracle....BOTH of these things are commercial, PAY FOR products. Have you contacted Suse or Oracle??? Because these things have been suggested to you in the past, several times.

You tell us nothing about your server, your environment, what has changed recently, database details, what kind of storage it's on, any procedures/scripts that run upon login, etc. Again, the best thing for you to do is to contact Oracle support for help.

hi,

Thanks for the replies but I have already contacted oracle support and they confirmed that there is some issue at OS level which needs to be resolved by unix support. Since the support for suse has ended please h3lp me to resolve this issue. Also our organization is planning to migrate from suse 10 to redhat 6 soon.

Regards,
Natraj

Ok...so are YOU unix support???
Why are you going to bother??? Because RHEL 6 is ALSO old, and about to be end-of-life. Latest is 7.4...and unless you're going to PAY FOR RHEL, then don't use it. Are you going to pay??

And as you were asked before:

• Details about your server?
• Details about your environment?
• Details about what has changed recently?
• Any details about your database?
• What kind of storage it's on?
• What, if any procedures/scripts that run upon login??

If you're not going to answer questions when asked, then there isn't much point in posting. You were also given the advice to check DNS. Did you?? You've been posting like this for two years now, and not providing details or showing much in the way of effort.

You don't answer any of the questions that I asked. You really need to learn to read more than one reply in a thread as mine gave you some things to look at.

I agree with the prior poster. If you're going to migrate to another OS and have paid support from Oracle you should go to RHEL7 rather than RHEL6. The RHEL subscription allows you to upgrade the major release you're using so even if you bought it originally for RHEL6 it will allow you to install RHEL7.

1 members found this post helpful.

Hi,

Our customers are planning to migrate to RHEL with payed version for sure.

1. Details about your server?
SLES 10 SP2
Details about your environment?
2. Details about what has changed recently?
We have not changed anything.
3. Any details about your database?
Oracle EBS application r12.1.1 and the DB is installed on other server.
4. What kind of storage it's on?
Floppy disk controller
VMWare Virtual Machine Chipset
LSI Logic / Symbios Logic 53c1030 PCI-X Fusion-MPT Dual Ultra320 SCSI
5. What, if any procedures/scripts that run upon login??
There are no procedures running upon login and the same server is running for past 7 years with good performance.

Also PFA the script we are using for application server backup.

Regards,
Natraj

Attached Files

prod app backup script.txt (2.0 KB, 8 views)

Your customers?? So they hired you to solve this problem, and you're asking US to do it for you? How much of your paycheck do we get? And do your customers know that RHEL 6 is similarly old, since you say they were going to 'upgrade' to another old, obsolete version?
...which you said before. Not the OS, things like what KIND of server, running what KIND of hard drives/controllers, etc., on what kind of network. You know...DETAILS.
This is the "what kind of network/environment"...which you didn't answer.
Oh? Then why are things behaving differently?? SOMETHING changed if it wasn't doing this and now it is...common sense.
This is where the "Details about your environment" come in. You ONLY NOW say that the DB is installed on another server, and STILL don't tell us anything about it, where it is, connection between the two, etc.
Do you honestly expect anyone here to believe that an SLES server is running an Oracle 12 database off a floppy disk?? And now you bring VMware into things, so yet AGAIN, details that weren't mentioned before
So it's run for seven years, and nothing has changed....therefore, either you're lying, or there is no problem. Because if NOTHING changed, it'll work the way it always has.

Which is it?