Interested to Buy Any Domain ? << Click Here >> for more details...
How do you switch from an init.ora file to a spfile?
- 4 Answers
- 19960 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / santo
Just create a spfile for pfile and then bounce the
database...While restarting, if Oracle finds spile first it
will use it first instead on pfile.
| Is This Answer Correct ? | 28 Yes | 1 No |
Post New Answer View All Answers
What is replication? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What is dbcc? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
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.
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
Query processing is slow(eg select query)how will u solve that
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
how can you initialize log miner?
