Migrating to a Server Parameter File
If you are currently using a text initialization parameter file, use the following steps to
migrate to a server parameter file.
1. If the initialization parameter file is located on a client machine, transfer the file
(for example, FTP) from the client machine to the server machine.
2. Create a server parameter file using the CREATE SPFILE statement. This
statement reads the initialization parameter file to create a server parameter file.
The database does not have to be started to issue a CREATE SPFILE statement.
3. Start up the instance using the newly created server parameter file.[@more@]
migrate to a server parameter file.
1. If the initialization parameter file is located on a client machine, transfer the file
(for example, FTP) from the client machine to the server machine.
2. Create a server parameter file using the CREATE SPFILE statement. This
statement reads the initialization parameter file to create a server parameter file.
The database does not have to be started to issue a CREATE SPFILE statement.
3. Start up the instance using the newly created server parameter file.[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-1002554/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- What Is a Server Parameter File?Server
- Exporting the Server Parameter FileExportServer
- Errors and Recovery for the Server Parameter FileErrorServer
- Step 5: Create a Server Parameter File (Recommended) (63)Server
- Initialization Parameter Files and Server Parameter Files (287)Server
- Oracle Server Parameter FilesOracleServer
- FROM ASM Migrating to FILE SYSTEM Using RMAN(三)ASM
- Step 3: Create the Initialization Parameter File (61)
- Backing Up Server Parameter Files with RMANServer
- SQL SERVER – Attach mdf file without ldf file in DatabaseSQLServerDatabase
- OGG-01453 Database login information not specified in parameter fileDatabaseORM
- 【分散式計算】MapReduce的替代者-Parameter Server分散式Server
- oracle parallel並行_引數parameter_parallel_max_serverOracleParallel並行Server
- MySQL server PID file could not be found!MySqlServer
- Row Chaining and MigratingAI
- The server quit without updating PID fileServerUI
- Row Chaining and Migrating(六)AI
- LRM-00109: could not open parameter file '/u01/.../dbs/initshdb.ora'
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- Description of restoring file and filegroup backups in SQL ServerRESTSQLServer
- Migrating to ASM Using RMAN(二)ASM
- Migrating to ASM Using RMAN(一)ASM
- Oracle ParameterOracle
- Required parameter $xxx follows optional parameter $yyyUI
- WebLogic啟動報Could not get the server file lockWebServer
- The SPFILE Initialization Parameter
- Sessions & Processes parameterSession
- Import parameter: STATISTICSImport
- Export Parameter : BufferExport
- Export Parameter : QueryExport
- MySQL過程報 Parameter number N is not an OUT parameter錯誤MySql
- How to serve uncommon file in WebDAV using IIS in Win ServerWebServer
- Mysql啟動錯誤-server PID file could not be foundMySqlServer
- 使用DBMS_UTILITY.get_parameter_value檢視session的parameterSession
- Create a New Parameter ID
- 10.2.0.2 init parameter
- Export Parameter : ConsistentExport
- Export Parameter : CompressExport