General :: Find List Of Table Spaces In Oracle In Unix?
May 11, 2011command to find list of table spaces in oracle in unix
View 1 Repliescommand to find list of table spaces in oracle in unix
View 1 RepliesWhere can i find a list of cronjob return codes for linux/unix
View 1 Replies View RelatedHow to compare oracle database table contains using (Perl/Shell)scripts.
View 4 Replies View RelatedI have installed Enterprise Linux Version 5 provided from Oracle
I am able to access Internet using network cable
how can I enable WIFI service ,so that I can use internet without the network cable
Im using this unix command(in a php file) to remove a certain string and then remove the whitespace left by that string. Unofrtunately in many cases, the files get completely erased. Is there a workaround?
Code
<?php
$dir = "./";
$rmcode = `find $dir -name "*.php"
[cod3e]....
I have beeen trying to find a list of all flags that can be used in UNIX and their meaning but I have had no luck.
Does anyone know if such a list exists?
If so where can I find it?
What I need is, given a process id, list all his children without any clutter (table header, other columns than the pid) What I have is :
ps h --ppid $PID Which gives me:
26277 pts/13 S+ 0:10 cmd1
26280 pts/13 S+ 0:10 cmd2
Using h allow me to hide the table header. Is there a way to tell ps to not print the pts/13 S+ 0:10 cmd part in order to get a list of children process ids separated by carriage return?
I am very new to Linux and Unix. Is there a command list which indicates the UNIX command equivalents also?
View 5 Replies View Relatedcreating the below unix script to run in oracle database .I need a script which should do the following things.
1. The script should insert row count of a table from one database(A) into table (AB) in another database(B).
2. The script should update tow count of the similar table and tablespace from database (B) in to a table AB.
3. The script should update the status column of the table AB as: 'Y' if the rowcount of the table@A and rowcount of the table@B matching. or else it should update 'N'
Is there any unix command to list services running on remote unix box.
View 6 Replies View RelatedIs it possible, in Linux, to rename a file from something without spaces to something containing spaces? I know I can create directories and files with spaces by doing:
mkdir "new dir" and:
touch "new file.txt"
I want to rename files from:
imgp0882.jpg to something like:
20091231 1243 some topic.jpg
And how would it look in a shell script that uses parameters like:
for i in *.jpg do
rename "$i" "$somepath/$mydate $mytime $mytopic$extension"
?
I'm new to Linux (using PCLinuxOS 2009.2), coming from Windows, and I've written myself a little shell script to download files from my camera and then automatically rename them according to a date-and-topic pattern. As you can guess by now, I'm stuck on the bit about renaming. If you want to see my script, here's a copy. I'm not using jhead for this renaming because that only works with JPEG files but I want a single solution for any media format including videos.
the below tag is in the xml file. Now i want to find and extract the value of application name test1 and test2 one by one in the unix shell script. how to do this
<application name="test1">
</application>
<application name="test2">
[code]...
Using rpm -qa | grep -i <pkgname> gives if a package is installed or not.
But, I would like to find out where a package is already installed i.e the location where a particular package is installed say /opt/<pkg>
I have two sets of data. 1,2,3,4 and 6,7,8 and I have written a fortran code to put them in order as below:
program gap
implicit none
integer:: i, j
do i = 1,4
do j = 6, 8
[Code]...
I want a space once every row loop has finish.I am dont know how to write the data as shown above using the fortran code in this post.
I'm a new user for oracle,tried to install oracle 10g on redhat linux 5 but gettinh the same error message.response/ runInstaller[oracle2@localhost database_10201]$ sh runInstaller _runInstaller: line 54:/tmp/database_10201/install/.oui: Permission denied_Doany one plz help me how to give full set of permisions to an user in linux to access a folder??
View 2 Replies View RelatedI've got a new hard drive, formatted it to ext3, and made a check for bad blocks using e2fsck.
It gave me this:
Quote:
I just would like to know where i can find how many bad blocks were found (perhaps one if it is using singular in sentence "Updating bad block inode."?), and what is/are the number(s) of located bad block(s).
I downloaded rpm so far but my only problem is I don't know what apps there are for it?
View 14 Replies View RelatedI want to search in many many files for a string.
I used find /archive/* -print0 | xargs -0 grep 'robert' -sl
Is there a simple method to do it ?
Is there any UNIX coomand to find the unix machine type (like whether the machine is belongs to Sun ultra 45 type) like that .
View 3 Replies View Relatedwhat is the translation table and referance table in any DB (with referance to Data conversion)
View 2 Replies View RelatedHow to find and list files and directories present the current directory which were created in, say, years 2005, 2006, and 2009 and then move them to some other location, for example, /backup. Yes, I need to list them and move simultaneously. We can use:
Code:
find . -mtime n {};
but that n is troublesome for me to figure out files/directories created in years 2005, 2006, and 2009, for instance. Is there any way to match exactly by Year Value rather than calulating the "n" (days * 24 Hours)?
System Info:
SunOS 5.8 Generic_117350-06 sun4u sparc SUNW,Ultra-Enterprise
How can I find a list of files that are named duplicates i.e. have same name but in different case that exist in the same directory?
View 7 Replies View RelatedI use find / -name myfile to search files. But it will print out a very long list such as follow:
Code:
...
find: /var/empty/sshd: Permission denied
find: /etc/audit: Permission denied
find: /etc/httpd/conf/ssl.crl: Permission denied
find: /etc/httpd/conf/ssl.crt: Permission denied
[code]....
Where would i find the list of distribution codes.For example.Code:samba-32bit-3.4.2 -1.1.3.1.x8664.rpmIn above rpm file it is indicated that its release is 1.1.3.1 .The rpm is meant to be run for opensuse.Where would i get the linking of release number and In simple words How would i guess distribution by merely looking at rpm name?
View 2 Replies View RelatedI'm trying to do a
find /photos/* -type f -mtime +365
to find all my pictures that are over a year old, but I keep getting argument list too long. How can I view what all the results are, even if it just dumps it to a file that I have to open?
I tried Gnome-ppp but terminal can not find it! Retired can only afford cheap dialup.
Where can I get a version of ubuntu that has system -> administration-> networking?
Would someone be able to point me in the direction to find a list of update releases for Redhat Linux v5?
View 1 Replies View RelatedI need to delete all *.trc files that are older than 30 days and I am getting a "Argument list too long" error. There are other files that should not be deleted which is why I am using the "*.trc" and newer files need to be kept as well. I have seen other postings but they do not cover both of the conditions. Below are 2 of the many attempts at doing this but I cannot get this to work.
find *.trc -mtime +31 -print| xargs rm -f {}
find *.trc -mtime +31 -print -exec rm -f {} ;
I am facing an issue, while unzipping an UNIX ZIpped file. The message I am getting is as below.
/> unzip np_ARUDDP99_20110201.zip
Archive: np_ARUDDP99_20110201.zip
End-of-central-directory signature not found. Either this file is not a zipfile, or it constitutes one disk of a multi-part archive. In the latter case the central directory and zipfile comment will be found on the last disk(s) of this archive. unzip: cannot find zipfile directory in one of np_ARUDDP99_20110201.zip or np_ARUDDP99_20110201.zip.zip, and cannot find np_ARUDDP99_20110201.zip.ZIP, period.
I've AMD64 system with Ubuntu 11.04 installed. It's been rough ride for me to install oracle-xe-universal. I've already spent more than 2 days on this. Still unsuccessful.
1) First I downloaded the packages libaio_0.3.104-1_i386.deb and oracle-xe-universal_10.2.0.1-1.1_i386.deb
2) Then I ran
sudo apt-get install bc (ran fine)
sudo dpkg -i --force-architecture libaio_0.3.104-1_i386.deb (ran fine)
sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb
(gave me dependency error for libc6 (>= 2.3.2), I modified the control file to remove dependency and rebuilt the package) (now worked fine) Oracle xe is now installed. Then I tried to start the DB it started but it's HTTP client never started. So I decided to uninstall the oracle-xe=universal. None of the sudo apt-get remove oracle-xe-universal command's didn't worked for me. So i went for manual uninstallation directions as per oracle link.
I ran the following command-
--Manually uninstalling Oracle 10g--
sudo rm -rf /usr/lib/oracle /etc/oratab /etc/init.d/oracle-xe /etc/sysconfig/oracle-xe /usr/share/doc/oracle_xe /usr/share/doc/oracle_xe_client
Then I again ran the following command to install oracle-xe
sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.0_i386.deb
See below what I got as the output-
rocky@ubuntu:~/git/mygit/edas2/libaio$ sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb
dpkg: warning: overriding problem because --force enabled:
package architecture (i386) does not match system (amd64)
[code]....
Even in applications menu I don't see the if oracle has been installed. So i conclude first time installation was ok but somehow http client didn't worked. After manual uninstallation, second installation didn't even loaded/installed the oracle-xe in init.d directory.