Login or Register to Ask a Question and Join Our Community


Solaris

Please help me how to administrate Oracle/plsql server

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems Solaris Please help me how to administrate Oracle/plsql server
# 1  
Old 03-14-2013
Oracle Please help me how to administrate Oracle/plsql server
I previously worked for the L1 support on DNS/Apache servers in solaris10......
Now our team lead wants me to work on Oracle/plsql server for our new client....
I've to work without training...

How can we know that Oracle/plsql server running in our machine ??

How to Administrate Oracle/plsql server ??
what are the main responsibilities ??
What is the role of a sys admin in maintaining Oracle/plsql server??
What are the services/processes involved in Oracle/plsql server??

I'm helpless.........

please tell me....Smilie

please.....

Thanks in Advance.....
# 2  
Old 03-14-2013
Well, there are tutorials online, but this is extreme. You can tell it is up by connecting a client like Toad, looking at the tables, data.
  • The big deal is managing the log, which is the database backup, and which flows from it as transactions modify the data.
  • Periodic full dumps are also wise and normal.
  • Databases need to have their file spaces defragmented and their staatistics refreshed to endure proper index use.
  • Monitoring and allocating space is an important aspect of the job, and attaching new storage as needs grow.
  • Occasionally or periodically, old data is purged. Big operations have rotating pools of partitions for tables, so each day a new partition is added, one of the old ones that had ben detached and purged of its data.
  • Offsite duplicate backup is a best practice.
  • There is the administration of user ids, groups, permissions and security.
  • You may have to do bulk import or export of data, ad hoc or in periodic batches.
  • Batch processing, scheduling may also be in your realm.
  • Developers often need help figuring out why queries run slow or do the wrong thing. Good luck!
Last edited by DGPickett; 03-14-2013 at 03:42 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. Solaris

Is there any GUI or web ui to administrate zfs/zpool

HI, Is there any GUI or web ui to administrate zfs/zpool. i want to monitor/expand/migrate zfs from one machine to another machine (0 Replies)
Discussion started by: bentech4u
0 Replies

2. Shell Programming and Scripting

Connecting+Firing plsql to Oracle DB in one go

Hi, I am using the below command to connect to a remote Oracle DB from my unix shell script. sqlplus -s user1/password1@remotedbhost:1252/demo @/tmp/PROC_MS.prc But I get the below error. 1. Can you confirm if my code is correct ? 2. Can you help me overcome the error ? (3 Replies)
Discussion started by: mohtashims
3 Replies

3. Shell Programming and Scripting

scope of oracle plsql development /unix shell scripting

I am working in production support in an leading bank and more of my job is more in oracle/plsql. I am learning unix shell scripting and have started development in the same.I would like to know regarding the scope of these two in the industry.Also would like to know about other scripting... (2 Replies)
Discussion started by: jesthomas
2 Replies

4. Shell Programming and Scripting

To get value from Oracle Anonymous PLSQL block

Hi All, i need you help while accessing the value from anonymous PL/SQL block. Initially our requirement was to get the value from SQL statement. I was doing like... But now i need to use dbms_application_info.set_module in it. So i have planned to use anonymous block instead of SQL... (2 Replies)
Discussion started by: Amit.Sagpariya
2 Replies

5. Solaris

shutting down oracle with the server

What can I do to ensure that oracle database is shut down when the server reboots. (1 Reply)
Discussion started by: krishan
1 Replies
Login or Register to Ask a Question