Script to drop oracle DB users on HP, LINUX, SOLARIS
Hi everybody,
i need help from all of you.
I have many users who are no more work in our Company. Some who get objects are Locked. There Many users and many Database Servers. And it'll take long for me to finished this job.
That's why i need your help to provide me anyone Scripts for(HP,LINUX,SOLARIS) which drop all users who don't have any objects in all databases on all oracle Server.
Hier his my Sql script which i want to combine your help Script
Code:
select username, count (object_name)
from all_users, all_objects
where username = owner(+)
group by username
having count (object_name) = 0;
Und another one to import all users all users who still get objects in one Table. And i suppose to do it before Friday 03th of July 09 Afternoon.
Thanks a lot in advance
i'm here because i need help like a shell script to do this on all unix server. i have allready my sql sript like ishow you. May be now please somedoby can help me.
Hi Gurus,
We are migrating Oracle from Solaris to RHEL 7 and looking for Solaris equivalent commands for Linux.
we are using lot of korn shell scripts built on Solaris so, i am looking for equivalent commands which are using in Solaris..
Could you please help me here by proving any info ... (4 Replies)
Hi Gurus,
We are migrating Oracle from Solaris to RHEL 7 and looking for Solaris equivalent commands for Linux.
we are using lot of korn shell scripts built on Solaris so, i am looking for equivalent commands which are using in Solaris..
Could you please help me here by proving any info... (1 Reply)
What I am trying to do is install Remedy on a Solaris machine. However to install Remedy on Solaris, the server has to be able to connect to the oracle database on the Linux server? How can I accomplish this? (8 Replies)
We have a SPARC T4-1 server, running Solaris 11, and it's doing some pretty extensive parsing on roughly 100GB data set.
All was well still few weeks ago, when I was testing the performance, I was reaching rougly 50minute calculation times, and it was more or less expected performance.
Now... (0 Replies)
Hi admins,
I am trying to run a script to add users on solaris with password:
I am using crypt for passwords:
The part of my scripts is as below:
if ; then
echo "$username exists!"
exit 1
else
pass=$(perl -e 'print... (5 Replies)
Hi,
os version :sun solaris 5.9
I have a problem with one of production server where listener will die frequently,
I have raised SR with oracle for the same, but mean time i need simple script and i need schedule in cron for every 5 min if listner will down it will start automatically.
... (4 Replies)
