Top Solutions

I want to run multiple statements in parallel not sequentially
dbms_stats.gather_table_stats (ownname=>'RDWDM', tabname=>'TABLE_1');
dbms_stats.gather_table_stats (ownname=>'RDWDM', tabname=>'TABLE_3');
dbms_stats.gather_table_stats...

OK.. I'm sure this question is very basic to most of you. .Just trying to get an understanding..

I have a bff file that I downloaded from the IBM website called perl.libext.2.0.56.0.bff . This file is stored in /var/tmp/

How is this file...

Hi,

I've got a SPARC system running SunOS 5.10 that's been giving us problems.  When booting up, it would get stuck in a WARNING loop, and display the following over and over again:

WARNING: /pci@1c,600000/scsi@2 (glm0):
        Resetting...

I am on RHEL 6 and need to increase the limits for

 

I have the following config:

 

Specifically, I need max open files to be unlimited and max processes to be 4096. for user mqm

I have no entries in my limits.conf file

How do I...

I am trying to run sqlplus and sqldr from a korn shell script.  See the script below. It run step 2 but doesnt go to step 3.  If i remove step 2 it runs step 3 but it give me >> unmatched error.   Also eveytime it does as step i guess it clears...

I just about have everything working with SFTP.  I tested SFTP using a batch file to pass it the commands and it works great.  The problem I have though is it prompts me to put a password before it starts reading the file and processing the...

hai friends,
       Is there any command in unix to find the Oracle version number of a oracle that set in the ORACLE_HOME environment variable.

Thanks

Hello All,
I need help in displaying the tab character in UNIX.  I am writing a script which will load the tab delimited text file into a Teradata table. I tried to use the below but it didn’t work

TAB= “\t”
echo "Hello${TAB}World"...

I have a HPUX server with java 1.5.0.03

I have several java applications running on this server.

The problem is that the java applications use the wrong timezone when logging to a logfile. They use GMT time instead of GMT+8

I have tried...

I need a command to check the number of CPU/cores AIX 6.1 running on.
AIX running in virtual environmetn - PowerVM LPAR.

Hi,

I am newbee in UNIX/solaris  i cant install samba on solaris see wht steps i tried in cdrom

# pkgadd -d . SUNWsmbar SUNWsmbau SUNWmbac SUNWsmbas

but it could only install SUNWsmbar and SUNWsmbau

for other packages it says package...

In unix mks shell the following error occurs

$ seq=07
$ seq=`expr ${seq} + 1`
$ echo $seq
8
$ seq=08
$ seq=`expr ${seq} + 1`
expr: non-numeric argument "08"    <=====

for 08 and 09 get this error. Seems like it iterprets as a octal 08...

Sun Server Version : SunOS 5.10 Generic_118833-36 sun4u sparc SUNW,Sun-Fire-V890

Top.cls , dl  command is not working in solaris 10
bash: top: command not found

Please give me the steps to install top command in my server

In order to defragment Oracle memory, I have to schedule - every 1-2 hours - the following Oracle instruction:
ALTER SYSTEM FLUSH SHARED_POOL;
In YOUR opinion, what is the best way, and why?
(a) Schedule in cron;
(b) Schedule as an Oracle Job...

I want to display all files and directories and sort by date (similar to dir /od in Windows). Is there a way? If it can't be done with ls or if I have to pipe the putout to some other command, then what would be the complete syntax?

I'm new to Solaris and I'm working remotely using PuTTY and Xming on Windows PC to connect to a Solaris 10 Sun server.  I'd like to use an OS GUI like gnome or similar.  Do I need to install anything (there is something in...

How can i start stop restart dsmc service on AIX

hi i am new to systems calls, and have been given the following question:
1)Use system calls getpid() and getppid() to report the pid and ppid of your current process?

I think the code shown satisfies the requirements but in terminal when I...

OS: UNIX AIX 6.1
DB: Oracle Database 11g Release 2 (11.2.0.1)

I am currently on version 11.2.0.1 and need to upgrade to version 11.2.0.3.  I am trying to figure out if this requires a full install of 11.2.0.3 or is this merely a patch to the...

Hi All,

I have inserted a new tape in library with label 007162 and I want to add it to scratch pool. I have searched on google and got following commands, but none of the commands are working, giving following output :

label libv L3494B...

hi i'm running AIX 5.1 ML 4

The problem is ...

i tried to activate nfs

To start the nfs group, i type

# startsrc -g nfs

nfsd, biod,rpc.statd,rpc.lockd showing ALL STARTED WITH PROCESS ID.

but then when i type to check status...

SUN/Oracle tells me I need tp apply this patch 139434-08 - to the firmware.
I have a SUN T2000 -solaris 10
Do not know how to update firmware - it says to power the system off then ftp the patch to the system - I don't know how you do that.  I...

I have to write a shell script that checks for the word SUCCESS in the log file . If It didnt find the word SUCCESS in the log file then an error message should go out.
My script:
#!/usr/bin/sh
Result=SUCCESS
File=`find /opt/dev/logs/ -name...

I am on a THEL 6 system

A new Broad com 10 GB has just been placed into the machine

WHen I run the following command

 

I can see my 10 GB card

 

I enter the following command:

 

and then select Device Configuration, I get...

Hi Members,

I couldn't find a TA for HP-UX. Hence posting it here.

This is the error when I invoke Bash shell in HP-UX 11.2.

"/usr/lib/hpux32/dld.so: Unable to find library 'libintl.so'  "

I tried searching for the library and...

Hello
i have a filesystem which needs to be increased in an aix 6.1 server, that has HA installed on it.
The filesystem is not in rootvg( so i cannot use chfs command to increase the size)
how can i find out if the this filesystem is part of a...

I am getting following error when i do fcstat for fcs1 on AIX 5.3 ( TL10 SP2).

Error opening device: /dev/fscsi1
errno: 0000003d

lsdev -Cc adapter is showing adapter as available. we have changed this adapter 2 months back. The problem is...

Unfortunately im sitting in between two suppliers so i dont have all the necessary OS info to hand but hopefully it wont matter too much as this is an SFTP question.

The situation is such that we have a windows based SFTP server hosted at our...

Hi, I am writing a shell script which will input a string parameter. Inside the script I will do different action depending on the string value. I wrote

myscript:

if [ $1 == "test1" ]
then
  echo A
else
  echo B
fi

myscript  test1...

Hello i am decommissioning an lpar

i have shutdown the lpar, now i need to unmap the disks to that lpar.

can someone tell me how i can unmap from vio for a vio client?
also how to remove vhost from vio?

Given that the lpar is down, do i...

PLATFORM : SUN FIRE T2000
OS: SOLARIS 10

I am having a serious issue with my server.

First of all I had this error Unable to repair the / filesystem. Run fsck manually
(fsck -F ufs /dev/md/rdsk/d400).

I couldn't fix this file system...

I have a unix environment SOLARIS. I am trying to find directory size for each directory in MB like:

/home/sam
Now I want to know what is sam size in mb.Thank you

When doing a preview install of software on an AIX 5.3 server, it said OK at the top. Then after I actually updated the software for real it said "failed" and caused huge problems.  When software installs successfully, it just says "OK" at the...

Hi Experts,

I'm trying to run wget (GNU Wget 1.8.2) on Solaris 8, as follows:
    wget http://www.gnu.org
And I get the following output:
  --16:41:56--  http://www.gnu.org/
           => `index.html'
Resolving www.gnu.org... done....

wget doesn't work on AIX 5.3, it says command not found. Does anybody know the command for downloading a file off the internet for the AIX?

Hello Expert,

I'd like to change the nofile variable to 65563 acccroding to oracle specification.
I've tried setting the variable in the /etc/system, but it has no effect:

In /etc/sysetem:
set rlim_fd_max = 65536

When I tried to set it...

does anyone know what the command and syntax are to move a batch of files (anything up to approx 200) and delete them as they are moved, not at the end of copying them.  The problem is that files could be placed onto the server as the copy...

In aix server I am getting following error through errpt command
173C787F   0410091407 I S topsvcs        Possible malfunction on local adapter
173C787F   0410085807 I S topsvcs        Possible malfunction on local adapter
173C787F  ...

Hello,

I have a server running soalris 10 with processes that I'd like to kill, but kill -9 on the parent process seems to have no affect to it. I've also noticed there are few "defunct" processes:

# ps -ef|grep...

I am doing a "vgscan -v" to try fixing some volume groups that won't activate after a hard shutdown. It runs for a few seconds then gives "Memory Fault(coredump)".

This might be related..... Previously I was getting this error, but fixed this...

Dear experts -

           I am getting the following error when I run this command

 /usr/local/nagios/libexec/check_nrpe -H localhost

CHECK_NRPE: Error - Could not complete SSL handshake.

I have made the changed correctly in the...

Hi there, i have installed a new zone on a Solaris 10 x86 server and i an unable to resolve the following error:

 svcs -xv

svc:/application/management/sma:default (net-snmp SNMP daemon)
   State: maintenance since Sun May 09 16:42:44 2010...

hi

I have always done SPOTs from MKsysb resources on NIM, but after upgrade the NIM to AIX 7.1TL1-SP1 I get this error:

[isga01s@nim:/var/tmp] sudo nim -o define -t spot -a server=master -a location=/nim/spot1 -a source=MKSYSB_testaix...

Hello
can someone tell me
How to install / upgrade samba on AIX
how to check what current version is installed on it?

Hi Experts,
I installed postgres - under a non-admin account through the installer for Postgres 8.3.  The installer itself tries to start the service and cannot after the cluster is initialized...

If I go to the command prompt under the bin...

Does anyonw know what pbrun command does?

is there another alternate command to use and what is causing the error below.

solaris% pbrun /usr/bin/chown -R cbcadm "/upload/cbc/mags/2331"
pbrun4.0.8-03[9656]: 3003.01 Could not connect to a...

Hi there
I just bought a Sun StorageTek SL500. My problem is I can't  seem to find the installation and configurations manual. It look like it is not available to anyone to download. I found only users guide and assurance guides which is not...

I am trying to mount the CIFS share from Netapp on AIX 5.3 system. I have installed the bos.cifs package, also I see the permissions are set properly for the cifs share. But still I am getting the error :
mount -v cifs -n netapp1/user/password...

I run my application on SSL port (https://) and I need to enable the server's http:// port as well. How can I do that? I am running apache version 1.3.28 (with mod_ssl) on solaris 9.
Can I specify this in the VirtualHost setup in the httpd.conf...

Hi Experts,

After patching, I ran init 0 and boot -s and the system did not boot.
Produced the following error messages:

{1} ok
{1} ok boot rootdisk -s
Boot device: /pci@1c,600000/scsi@2/disk@0,0:a  File and args: -s rootdisk
krtld:...

OK, I made this script to list the TCP open ports and their running service

netstat -aAn|grep LISTEN|while read socket b c d puerto resto;do echo "PUERTO: "`echo $puerto|cut -f2 -d"."`  ------\>  `rmsock $socket tcpcb|sed 's/^.*...

experts,

I'm attempting to restore a sybase database from HPUX ASE 12.5 to W2k ASE 15.7 Dev edition.

Has anyone ever done this before and can help out? or is there any documentation out there on how to do this?

So far, I've ftp my 4...

I have a text file which has follwing lines;

asdada  ....      B=0
rwer    .....       B=233
gsggw .....     B=0
asfasf ....      b=234
.........................
..........................
.........................

How to use grep to...

I installed RHEL 6 (64 bit) on Intel hardware, and I get the following error:

 

I Googled the error, and apparently since I only installed the 'basic server', I do not have the correct libraries to process this command

I have never used...

I established a reverse ssh tunnel from my PC to a HP-UX server using putty as shown in
attachment 1 so that after login to the HP-UX server, I can copy files using scp from
HP-UX down to the PC via tcp2222 (this PC is running freesshd...

Hello,
I have a Sunfire v445 running Solaris 10 that is connected to an EMC Clarion CX3-10 array.
i added a Lun to the EMC but Solaris does not see it.
What steps do i take to ensure the lun is recognized by Solaris.
All my previous Luns are...

Hi,

I am in the process of transferring files from a systems local directory to a NFS mount directory on that same system.  In the process of copying the files from the old directory to the NFS mount directory, I receive several messages of...

Hi Folks,

What's wrong here?

NFS mount fails as shown.
Hosts can dig each other and dig -x each other's IPs.
They are in each other's hosts files.

Other tests shown...

Many thanks,


EDIT:  Great, lost entire code section...

Hi,

Bought a IBM 9114 275 AIX server and looks like the boot image is corrupted. So I am trying to install AIX 6.1 on the machine .  Dnt know if the system has any OS on it before.

So kept the AIX volume 1 in the cd rom drive and on the...

I want to know how to open port 1521 et 1158 (for oracle ...) on redhat linux.

I have used the procedure bellow but it doesn't seem to work


#vi /etc/sysconfig/iptables


add this line
# -A RH-Firewall-1-INPUT -m state –state NEW -m...

Dear Experts,

At first, I must inform you that I am a complete novice in the Unix world.

Below is my problem:

I installed OpenBSD 4.9 in a company for firewall purposes. I'm using PF to do NAT. All users are accessing the Internet...

Hi
We have nfs hard mount point on aix 4.2 box
nfs server is down ( backup server)
we are trying to unount nfs mount point from client .
while trying we are getting below message
umount: 1831-015 16 error while unmounting...

Hi Experts,

I'm busy mount two directories from a unix sever called voda50 to my Redhat servers but after updating the /etc/fstab file and running the command mount -a I get the folloing error :
[root@fldemtra5 ~]# cat /etc/fstab
# This file...

Hello experts,

I am new to Solaris Volume Manager and was trying to follow Sun's document for replacing a failed drive. It states that I have to detach the affected submirrors prior to replacing the drive. When I try to detach I get an error...

When looping through this while loop, I get to the first if condition which happens to be true.  It should not get to any of the other elif conditions, right?  I'm looping through a file and if the line doesn't have a ';' at the end, I want to...

Is there any AIX command using which I can know whether the warning light or amber light is "ON" on the pseries IBM servers ? The servers are runnig AIX 5.3. Physically, i can check but i want to  know the command line for the same & also how can...

I've got a brand new T5220 with four 2GB FB-DIMMs in it.  Initially it had eight 2GB FB-DIMMs in it, but they weren't all the same part number and ILOM would report that the box was working in a degraded memory condition.  It would not even allow...

Trying to mount a USB drive to use as a backup drive as the tape drive recently locked up.
Being a BSD noobx10 I am having a few problems that I hope someone can guide me through...

Existing mounts are:
/dev/ar0s1a on / (ufs, local)
devfs...

Platform: HP_UX,  SUN Solaris etc.
Language: c/c++

I have a program where two or more processes share resources. Only one can change the shared resources but more than one can read them at simultaneously. In order to avoid inconsistent state...

How do you flush the arp table.  Do you have to do it one entry at a time, or can you just ditch the whole thing at once?

Thanks,
Bret

Hi - I have the following script, it appears though that when I pipe the output from do_countdown through any kind of stream filter - sed, grep, tr ..etc, and then through tee that the output is being buffered until do_countdown completes.
...

Hi,

I have inserted the following line in my crontab:

*/5 * * * * cactiuser /opt/lampp/bin/php /opt/lampp/htdocs/cacti/poller.php

The CROND is running fine and /var/log/cron shows clearly that the cron is being executed:

Apr 26...

We have a process that is running out of file handles. We are trying to address this problem with the vendor, but in the meantime we need to bounce it when it is getting near the limit. Currently we use Glance to see how many are in use. Is there...

Hello
I need to verify if my server which is getting its storage from EMC SAN has dual path or not ?
and if so, than i have to figure out if the path is failover ready. So if one of the paths goes down, than there would be no outage.

the...

System = SunOS
Release = 5.10
KernelID = Generic_120012-14
Machine = i86pc

----------------------

Created a mount point and then ran this command and got this error:

# mount -F smbfs //192.168.2.1/test /mnt/ntserver
mount: Operation...

Hi,

We are having some very strange issues trying to move files across different directories in our UNIX file system.

The error we are getting in our AIX 7.x unix shell is:

 

Basically we are trying to move a file from one directory...

I use the following command to set my LD_LIBRARY_PATH in csh:

setenv LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/home/mydir

but when look at the result, there will always be a "=" symbol at the end of my LD_LIBRARY_PATH even though I didn't type...

Hi guys,
 I have  a problem , each time I run prtdiag -v on a server I have unknown for a lot of lines, help me resolve this please.


prtdiag -v
System Configuration:  Sun Microsystems  sun4v SPARC Enterprise T5220
Memory size: 32640...

Does Awk have a function to trim leading spaces from a variable?  Like printf("%s\n" trim($1));

I can't seem to find the installp files for OpenSSH version 5.8p1 and OpenSSL version 0.9.8r for AIX 6.1. Can anyone please help provide the link or source?

I have to export and import remote oracle database tables. I am using rsh and exp/imp. The following does not work:

rsh ${rSERVER} "exp ${rDB_USER}/{rDB_PWD} file=${lPATH}/master.dmp TABLES=\(TAB1, TAB2\)"

rsh ${rSERVER} "imp...

How do I move the system clock ahead 1 hr for new daylight Savings time on
     HP-UX cronos B.11.00 U 9000/800 172981587 unlimited-user license (cronos is the machine name)
We have been advised that running the patch (DST) is not necessary,...

Hi,
I just bought a sunfire 280R from ebay. It did not come with video card. I got the video card from the other sunfire 280 which is working fine. So, I plugged that video card into the sunfire 280R that i bought from ebay (and of couse...

I'm experiencing problems printing from new Solaris 10 Server I've setup.

lpsched not started initially. When I start it it starts up fine but seems to disappear once I try send a job to a printer. See output below:

          TO FIX: Your...

Hi,

The link below said number 32000 is the max limit number of processes
that can be set in Oracle 10g :
http://forums.oracle.com/forums/thread.jspa?threadID=540004

The number of Oracle processes I'm referring to are illustrated below :...

Hello,
I am running a multi-threaded process on Solaris 10 platform; compiled using SunStudio 12. Sometimes our process is hung; I looked at "truss -p <PID>"; it gives strange errors like this:
truss -p 1739
/6:     nanosleep(0xFAC7BBE0,...

i am trying to check if a file exists before continuing with my script but it is not working.

if [ -e $filename ]
then
file_menu    #calls the function file_menu if file exists
else
echo data file does not exist
fi

i have put in dummy...

An acquaintance of mine has a problem with an AIX RS/6000 SP node running AIX 4.3.3.

The system has 4Gb RAM and the total memory load of the processes running at any one time is aroung 1.5Gb (i.e. sum of the memory used by processes is 1.5Gb)....

I have a critical server (Sun T5220) that I need access to the ILOM but do not have the p/w. I can SSH to the box as root. I am looking to reset the p/w to the ILOM without wipeing out all of the network and other configurations. I tried to use a...

How to check MAC address for Solaris?

#!/bin/ksh
typeset -i resA
typeset -i resB

opstms_conn_string="abc/def@ghi.com"

set `sqlplus -s  $opstms_conn_string << EOF
set pages 0
WHENEVER SQLERROR EXIT SQL.SQLCODE||SQLERRM

SELECT count(*)
FROM emp1; --table is misspelled...

I usually install RHEL 5.6, and normally get a ksh.

I installed RHEL 6 with default options, and I get the following:

 

How can a get a ksh.

DO I need to do a Yum update,

Do I need to set something ?

Thanks

I looking for unzip utility to freeBSD
Mr. Mrbrocoli send me to this link:
>unzip is a Unix utility that can "unzip" winzip archives.
>Get it at:
>ftp://ftp.freebsd.org/pub/FreeBSD/FreeBSD->current/ports/archivers/unzip.tar

I don't know...

I have been trying to get ghettoVCBg2 working but have had no success so far.
Added a vSphere Management Assistant vMA to my virtual machines
Registered the hosts and VMs with vMA
Modified the top of the ghettoVCBg2 Script
 
Config file for...

Dear experts -

                I am getting the following error message
CHECK_NRPE: Received 0 bytes from daemon. Check the remote server logs for error messages.

I have the set up the NRPE exaclty the same way as I did it on a different...

I needed help with mirroring.

I have datavg and rootvg volume groups, with hdisk0 allocated to rootvg. I have hdisk1, hdisk2, and hdisk4 physical volumes. I needed to mirror rootvg and mirror datavg. I wanted to mirror rootvg with hdisk0 and...

HI,
  Basically we would like to configure LOM with Ipaddress to access the server remotely.

after plug my laptom into the LOM serial port.i get
lom>    -----from here how shall i confiure lom with ipaddress,netmask and gateway.

do i need...

I need help to encrypt and decrypt a string from password file.
I need a sample script which will encrypt and save the information in password.txt file.

1st script (encrypt.sh)
---------------------------
excution: $ ./encrypt.sh
input...