Answer Posted / sanju

shut the database then do fllowing
1)In Parameter file set logfile destination
2)startup mount
3)alter database archivelog
4)alter database open
5)archive lo list;

What happens on checkpoint? : sql server DBA

1093

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1726

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1974

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1984

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1197

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1022

---

What is the importance of a recovery model? : sql server DBA

1025

---

What are the steps you will take to improve performance of a poor performing query?

2849

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

1973

---

how does an oracle clusterware manage crs resources?

1085

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2461

---

What the different components in replication and what is their use? : sql server DBA

1049

---

Why does Oracle not permit the use of PCTUSED with indexes?

2939

---

what functionality does oracle provide to secure sensitive information?

992

---

What is a system database and what is a user database? : sql server DBA

1227

---