Oracle 9i Database Administration In 10 Minutes
Apr 29, 2007
The Topics Covered In This Book Are: Understanding the Oracle
Environment; Understanding the Oracle Instance; Understanding the
working of Oracle Instance; Understanding the Oracle Database; Oracle
9i Software Installation; Oracle 9i Database Design using DBCA;
Enabling other computers to access Oracle Server; Oracle Enterprise
Manger Oracle Backup & Recovery -Simple Technique; Oracle Performance
Tuning. Everything in this book is covered in a step by step manner
by
first building reader's concept using analogies, real world examples
and then taking him/her to the steps of design implementation. The
book covers Oracle 9i Database Server. The concepts and most of the
stuff discussed in this book are equally good for other Oracle
versions including 10g. For advance user please check Oracle Database
Administration Concepts & Implementation Made Simple, ISBN:
0977073904.
The link is provided below:
http://www.lulu.com/takveen
View 1 Replies
ADVERTISEMENT
Jul 6, 2007
Learn Oracle Database Administration in 10 Minutes. No kidding. Checkit yourself,http://www.takveen.comOnly good analogy makes complex concepts simple!
View 2 Replies
View Related
Oct 5, 2001
To All SQL Guru's
I have this simple problem. How can I make SQL Enterprise Manager list only one database that is accessible by client who registered the SQL Server on his / her Enterprise Manager. The user has been granted access to only one database. But every time I register the server in the client's SQL Server Enterpise Manager it lists all database and user database with it.
I just want it to show only one or two or as how many database that login has granted access to and eliminate the database from the SQL Server Enterprise Manager's database list.
Please Help
Thanks
View 3 Replies
View Related
Jun 26, 2005
Hi...
Does anybody know of an open source script I can download that will enable me to manage an SQL database? I basically need to access and modify the database from any machine that may not have SQL Enterprise Manager Installed. I was thinking of writing my own script to do this but I assumed that there is probably already one out there.
View 6 Replies
View Related
Jul 23, 2005
Hi,We are a systems research group at the Computer Science departmentatRutgers University, and are conducting a survey to understand detailsabout network, systems and database administration. We hope that thisinformation would help us recreate a realistic environment to helpresearch in 'systems management'.We request network, systems, and database administrators to take thissurvey. As an incentive, all surveys completed in their entirety willbeentered into a drawing of a number of $50 gift certificates (fromAmazon.com).We hope you have a few minutes to take the survey which is located at:http://vivo.cs.rutgers.edu/administration_survey.htmlResearch in our group:The goal of our research is to improve the overall availability andmaintainability of services. Since administrators form an integral partof these services, a key aspect of this work is to build environmentsand tools that ease the task of service administration. In particular,environments which would help administrators know how their actionsmight impact the real service (before performing them for real), webelieve would be useful in preventing inadvertent actions. This surveytries to understand the existing environments, what administrators docurrently to test the 'validity' of their actions, and the difficultiesthey face in doing so. The two specific systems we are looking at arenetworks and databases, as we believe these are important components ofmany services.If you have any questions regarding this survey or our work, feel freeto email us:Fabio Oliveira (fabiool at cs || rutgers || edu), orKiran Nagaraja (knagaraj at cs || rutgers || edu)Thanks for your time,Fabio OliveiraPhD student, Vivo Research Group (http://vivo.cs.rutgers.edu)Rutgers University
View 4 Replies
View Related
Sep 10, 2006
Hi All, I will shortly (hopefully) begin devleoping an ASP.Net web application to let users manage a remote sql server 2005 database (kind of like the php myAdmin tool for MySQL databases). Were not talking a server managament tool for DBAs, more an end user tool for managing personal databases (it seems that web hosting companies provide tools for MySQL, but if you use SQL Server, you're stuck unless you have management tools on your PC - and what about mac users?).Given that premise, what features should i attempt to include? Creating and modifying tables structures and data is an obvious inclusion, but what else? I also haven't yet decided whether to go about this using scripts or using SMO. I've read that SMO is backwards compatible across versions of SQL Server...how true is this? are there issues or is it seamless? Please post any comments or thoughts you have, and thanks for taking the time.
View 4 Replies
View Related
Apr 21, 2015
My table as data as follow,
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[table_Data]') AND type in (N'U'))
DROP TABLE [dbo].[table_Data]
GO
/****** Object: Table [dbo].[table_Data] Script Date: 04/21/2015 22:07:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[table_Data]') AND type in (N'U'))
[code].....
View 6 Replies
View Related
May 16, 2006
I have been working SQL server for many years as a web developer, however in my current position we are lacking an expert in maintenance and admninistration as the company has recently switched over to SQL Server 2005.
I therefore need to develop a greater understanding of the best practices with regards to administration and am a bit lost as there are so many options which seem like they might match my requirements. As I have never looked beyond the basic administration/maintenance side of things before I have no idea which options to investigate.
Basically I want to clear any records older than 3 months old on a scheduled/automatic basis. There seem to be various options that could do this, however I want to know what the best option is, rather than waste a lot of time and risk problems by resorting to trial and error.
We are already backing up this data, however I am not sure if I should combine these tasks. It is highly unlikely that we will ever have to restore these older records, however we do need to store the data for legal reasons.
I dont expect anyone to tell me everything, as I am happy to investigate, I just need a nudge in the right direction.
Thanks
maw
View 3 Replies
View Related
May 12, 2008
We are having problems getting the ADO.NET client to failover in a timely manner in a web application. Here's what happens:
1) Database fails over in 3 to 5 seconds
2) Clients attempt to login to primary and receive SQL server not available errors
3) The clients slowly start to connect and succeed without errorson the secondary.
4) We are still see SQL Server login errors on the primary, even after the failover
5) When we failback to the primary, it all happens within a few seconds (no problems)
If we recycle IIS, this problem goes away
Here's what we have tried
1) Turning off connection pooling (has no effect). We also can see the connections get killed on the primary server
2) Applying this hotfix (http://support.microsoft.com/kb/944099)
And yes, we are running a script to sync up the SIDS so that doesn't appear to be a problem. What seems to be happening is the primary server is getting stuck in the ADO.NET application memory. The problem is we don't know how to fix it.
BTW, our hardware is SQL Server 2005, Windows Server 2003, .NET 2.0 (and .NET 3.5)
Let me know if you need additional information. Thanks in advance
View 2 Replies
View Related
Jul 20, 2005
Hello,I need to copy a table from an 8i oracle database to a sqlserver 2000 database.Is it possible to use the command "COPY FROM ... TO ..." ?So, what is the correct syntax ?Thanks for your helpCyril
View 1 Replies
View Related
Oct 15, 2001
Ho do I convert Oracle 8 database into SQL server 7.0 database ? Is it possible ? Please let me know at skbhaduri@rediffmail.com
View 1 Replies
View Related
Nov 7, 2007
Hi,
I am looking for TSQL book for Administration
Could anybody help ASAP.
Frozen
View 3 Replies
View Related
Mar 13, 2007
HI, I would like to set up a dba admin database on each of the instances that I have. Is there any recommended standard format for this database?
Thanks
View 1 Replies
View Related
Jun 11, 2007
Is it possible to write an ASP.NET app that can do certain SQL Server 2000 administration tasks, specifically add sql server users, and change sql server user passwords? Would it just be a matter of running the appropriate system stored procedures (sp_password, etc.), or does .NET provide any hooks into SQL Server for something like this? Thanks!
View 5 Replies
View Related
Feb 17, 2008
The job failed. The Job was invoked by User SERVER110Administrator. The last step to run was step 1 (Subplan_1).
anyone know what this error means?
View 1 Replies
View Related
Apr 13, 2000
Hi!
I need to connect to a database located in another city and administer it from my place.Can any one suggest the basic hardware and sql server(std/enterprice edition?).Shall it be on NT work station or server?Any limitations in administering this way due to some reason we can't move it entirely here.Please advice.
Thanks.
View 2 Replies
View Related
Nov 28, 2000
Hi all,
We are about to have 'colocated servers' for our web pages, mail and on line catalogues. The NT administrator is going to use 'pcAnywhere' to administer the servers. I prefer to register the SQL server in Enterprise Manager,using the IP address.
Are there any known advantages between pcAnywhere against using enterprise manager, particularly any security issues?
Many thanks in advance
Keith
View 1 Replies
View Related
Jan 21, 2000
Hi
Could someone help me out with administration of SQL Server over the internet.
What do I need to change on my SQL Server and what will I need to configure on my clients using SQL analyzer connecting over the internet
Vijay
View 1 Replies
View Related
Feb 18, 2002
I have configured a master server to do multiserver administration and configured my production server as a client. My problem is that when I try to create a multi system maintenance plan it says that I get a security error and it won't create the plan. I have local admin rights to both systems. Do I need domain admin rights?
View 2 Replies
View Related
Oct 11, 2006
Can anyone help me how to monitor the growth of transaction log of our SQL Server?... How will I maintain it?..
View 4 Replies
View Related
Mar 15, 2007
Hi pals,
I want to create a user in sql server 2000 and i need to give only
INSERT,UPDATE,DELETE,SELECT,CREATE VIEW,CREATE PROCEDURE,ALTER PROCEDURE,DEBUG PROCEDURE,EXECUTE PROCEDURE permissions. i dont want give Administrative priviliges. He should not be able to alter table structures/drop tables.
In SQL server 2005 ihave the concept of DDL triggers so that i can track and restrict whatever suspcious activities (dropping columns,changing datatypes) being done by the database users.
But in SQl Server 2000, what i can do i want restrict the users. to
I need this.can any one me help me out.
Regards,
franky
View 2 Replies
View Related
Oct 29, 2005
I want to set up Multiserver Administration.The problem I encounter is a firewall between the master server and sometarget servers.What ports need to be set open to make this possible ?
View 1 Replies
View Related
Jul 25, 2006
Hi all!
We would like to create an Intranet based cube administration tool.
Power users should be able to process cubes and dimensions. This works
and all the cubes, dimensions and even databases from the SSAS can be
displayed in the web! ASP.NET@C# combined with
Microsoft.AnalysisServices offer a lot of very good possibilities!
But we still have a problem:
How ist it possible to show some kind of progress bar (maybe in a self refreshing iframe or a new window??)??
When a cube/dimension is processed the user does not get ANY feedback
(of course the webserver waits to finish the process() method.
I tried to start a different thread an this even works!
I want to show our powerusers at least some kind of progress (%, events, what ever).
can someone help?? we are totally lost with that topic!
I already had a look at the example from:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=75148&SiteID=1
But it did not lead me to a propper solution :)
TIA and regards
JohnnyR
View 1 Replies
View Related
Mar 2, 2004
I'm new in the DBA position recently aquired, and I'm having a few issues with MSSQL configuration and administration.
1. I have created a two maintenance plans, one for system databases and another one for user databases, this plans include things such as, Integrity Checks, Optimizations and DB Backups, however the Integrity Checks fail with the error that the DB's must be in single user mode, how can I go about to make this and what are the implications of doing so?
2. There's been a few reports of MSSQL server compromises through UDP port 1433, so I closed it at firewall level, only TCP 1433 is going through, do I really need UDP 1433?
Thank you very much.
View 1 Replies
View Related
Nov 6, 2001
Does anyone have a user administration tool that they like? It seems that there are two common operations that have to be performed:
1. Create a new login for a user, and grant all of the database access rights and role memberships already assigned to another user. In other words, "Make User B just like User A." This same operation has to be performed for multiple servers.
2. Copy a login to a different server. This is usually done to add someone to a test environment. The database names and role names are the same, but the server is different.
In our environment, adding a new employee involves going to three different servers, finding a "model" login, and adding the database access rights for three or four databases, with three or four role memberships in each database. Some databases have thirty or more roles defined, so it's easy to miss a checkmark when scrolling through a list of that size.
I have tinkered with some scripts to do this, but they usually fail because things like sp_addrolemember only work in the current database. I am about to start writing something in VB to do this, but I don't want to reinvent the wheel if someone has already done something similar.
View 1 Replies
View Related
Dec 1, 2000
Is it possible to administer both SQL7 & SQL2000 databases from the same console ?? It's fine administering SQL 6.5 & SQL7, as 6.5 had no MMC, but it seems that SQL7 & SQL2000 have the same MMC.
Thanks,
Jazz.
View 1 Replies
View Related
Oct 30, 1999
Sorry for starting a new thread on this subject but my situation is a bit different.
I want to connect to a remote SQL-server in a DIFFERENT domain, using Enterprise Manager. Whatever I try, I allways get an "SQLserver not found"-error.
The ASP's on the server that make use of the SQL server are functioning without any problems, so I guess the SQL-server itself is OK.
I tried:
servername = URL remote server
setting up a linked server
setting up a remote server
I'm a webdesigner and a newbe to SQLserver7. Please keep in mind I could be overseeing something that very obvious for you.
So what could be the problem. Any tips? Thanks!
View 2 Replies
View Related
Jan 26, 2000
Is there a way to remotely control SQL server 7.0 from NT workstation
and win98?
Thanks
williams
View 1 Replies
View Related
Jul 11, 2001
Hi
i Would like to know is there any tool which would allows me to manage database over the web i.e from a brower
if any tool is there can any one let me know from where i can get it
thanks
Prasad
View 1 Replies
View Related
Oct 19, 2006
what is the best firewall protection for network computer?
View 1 Replies
View Related
Mar 27, 2007
(Post removed)
View 3 Replies
View Related
Jul 20, 2005
I'm searching for some alternate administration tool (permisions, rights,etc.) on sql server, something not so complicated as default. Does anyonehave some info about that? ThanksPete
View 1 Replies
View Related
