Wednesday, May 20, 2009
Starting Up with a Non-Default Server Parameter File
Create a one-line text initialization parameter file that contains only the SPFILEparameter. The value of the parameter is the non-default server parameter filelocation.For example, create a text initialization parameter file/u01/oracle/dbs/spf_init.ora that contains only the following parameter:SPFILE = /u01/oracle/dbs/test_spfile.oraSTARTUP PFILE = /u01/oracle/dbs/spf_init.ora
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2009
(30)
-
▼
May
(13)
- To find total size of the database
- The simplest query for checking what’s happening i...
- Starting Up with a Non-Default Server Parameter File
- How to backup the archivelogs which are not backed...
- Migrating to Automatic Undo Management
- Create Schema stmt
- Disabling the Recyclebin at session level and syst...
- how to know whether 32-bit or 64-bit oracle s/w in...
- max_enabled_roles error in all the versions includ...
- How to find TOP SQL in a particular period.
- How to do database characterset migration
- Using metadata
- Finding 64-bit or 32-bit at OS level
-
▼
May
(13)
About Me
- Palani Vijay
- Working as Oracle DBA for Wipro Technologies, Chennai, India
No comments:
Post a Comment