10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I have one application server, which is Solaris non global zone (dsapid02-dt3d02 - 10.63.76.96) and a database server, which is Linux (db1-serv26 - 10.63.36.117 & 10.63.36.118).
Whenever database admin is starting listener, it starts filling listener log file. Within minutes, it will make file in... (6 Replies)
Discussion started by: solaris_1977
6 Replies
2. Programming
HI Guys ,
Below are the two columns ITEMS and STATE of table .
ITEMS STATE
'2345','ggdh','k5tg','dgyt','hFF' DF
'1234','ghyt','DDD','GHTD','ABF' PQ
Can we get output in PL/SQL in below way ?... (7 Replies)
Discussion started by: Perlbaby
7 Replies
3. Programming
HI ,
Please guide to get the PL/SQL logic to retrieve parameter VALUES passed IN variable seperated with comma(,)
Say items =(MTH,WKL,DLY,QTR)
It should send above parameters seperatly USING LOOP condition IN the below IN clause
SELECT * FROM tb_data_storage
WHERE items IN... (4 Replies)
Discussion started by: Perlbaby
4 Replies
4. Hardware
I have an M5K with disk issues I'm trying to troubleshoot, and it's causing me some confusion. I know the host has four on-board HDDs, but the format command's output shows c0t0d0, c0t1d0, c3t0d0, and c3t1d0. cfgadm -al shows c0t3d0 as the DVD-ROM drive, and c1 and c2 as SAN disks. Confused yet?
... (2 Replies)
Discussion started by: desertdenizen
2 Replies
5. Shell Programming and Scripting
Hi,
we have PERL 64-bit build with Oracle 10g DBD . PERL database connection are working fine. Database upgraded to 11.2 and in PERL documents it says still use 10g DBD to connect to 11.2. when I try some test connections, I am getting this error . Did anyone see this error before .
I set the... (2 Replies)
Discussion started by: talashil
2 Replies
6. Solaris
I wanted to ask how do i assign the control files and archive log to be stored in different volume? I didn't come through any selection for that during the GUI installation. :)
Thanks in advance for any reply.
p/s:
I will appreciate it also if anyone can provide me a link for me to go... (1 Reply)
Discussion started by: beginningDBA
1 Replies
7. Shell Programming and Scripting
Dear Sir/Madam,
I use the following way to call the oracle stored procedure in a perl script, but I do not know how to call a oracle function by the following way ?
# ARGV is the oracle stored procedure name with parameters
$str = "sqlplus -s <<-eof \n" .
"$db_login... (0 Replies)
Discussion started by: ili
0 Replies
8. Shell Programming and Scripting
Hi
All,
I have issued ps -ef | grep oracle command and i got these result
oracle 356394 1 0 09:32:06 - 0:03 oracleCMS (LOCAL=NO)
Now I can see user from here but I can not from which machine they are running this process. How can I see that?
Thanks,
Vishal (5 Replies)
Discussion started by: vishalpatel03
5 Replies
9. Red Hat
Perhaps someone here has some experience with this.
machine os RHE 4 6
oracle 10g RAC
disk is SAN attached clariion.
I have presented new disks to the host, so the machine sees all needed LUNS. powermt shows them, they are labeled and i have fdisk'd them.
They are visible across all RAC... (5 Replies)
Discussion started by: Eronysis
5 Replies
10. UNIX for Dummies Questions & Answers
Hi All,
I have a 2 questions; 1 is oracle and another is korn shell
say TIME=20060928
desired output: 20060927
say TIME=20061001
DESIRED output: 20060930
If i substract one day from 'TIME' i am looking for previous day.
can anyone please suggest me how do i do this is SQL.
i... (4 Replies)
Discussion started by: pavan_test
4 Replies