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;

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2559

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2190

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2058

---

who owns the operating system files created by the utl_file package?

1060

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1900

---

what is asm?

1040

---

What is a correlated sub-query? : sql server DBA

1075

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2613

---

how does an oracle clusterware manage crs resources?

1081

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2539

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1262

---

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

1192

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1058

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

988

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2499

---