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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- Required parameter $xxx follows optional parameter $yyyUI
- WebLogic啟動報Could not get the server file lockWebServer
- ERROR 1290:The MySQL server is running with the --secure-file-priv optionErrorMySqlServer
- MySQL提示:The server quit without updating PID file(…)失敗MySqlServerUI
- Redis Cluster [WARNING] Node 127.0.0.1:7003 has slots in migrating state (15495).Redis127.0.0.1
- UNREFERENCED_PARAMETER
- MySQL啟動報錯:The server quit without updating PID fileMySqlServerUI
- v$parameter gv$parameter 檢視 DDL 與隱含引數
- 理解ASP.NET Core - 檔案伺服器(File Server)ASP.NET伺服器Server
- python parameter引數Python
- LTSPICE parameter設定
- Caused by: org.apache.ibatis.binding.BindingException: Parameter 'parameter' not found.解決ApacheBATException
- how to show hidden parameter(zt)
- Field Parameter的設定
- PostgreSQL DBA(86) - Table Parameter(fillfactor)SQL
- UNREFERENCED_PARAMETER的用處
- MySQL The server quit without updating PID file xx/var/DESKTOP-BHVUG0D.pidMySqlServerUI
- DataTables 1.10錯誤: requested unknown parameter
- Linux安裝mysql出現ERROR! The server quit without updating PID file問題解決LinuxMySqlErrorServerUI
- cat > file << EOF 與 cat > file << -
- File
- PostgreSQL DBA(152) - pgAdmin(log_XXX parameter:when)SQL
- PostgreSQL DBA(153) - pgAdmin(log_XXX parameter:what)SQL
- PostgreSQL DBA(151) - pgAdmin(log_XXX parameter:where)SQL
- SD 一些常用的引數(Parameter)
- 矽基流動 The parameter is invalid. Please check againAI
- How to Convert Class File to Java File Online?Java
- mac scrcpy 報錯 does not exist or is not a regular file,ERROR: Server connection failed(scrcpy mac與極空間衝突)MacErrorServerAI
- org.apache.ibatis.binding.BindingException: Parameter 'xxx' not found.ApacheBATException
- docker fileDocker
- include "head_file" 和 include <head_file>
- web應用servlet中Attribute、Parameter、InitParameter的區別WebServlet
- pyhton3解決”tuple parameter unpacking is not supported”問題
- java.sql.SQLException: No value specified for parameter 1 異常分析JavaSQLException
- ValueError: output parameter for reduction operation logical_and has too many dimensions ?Error
- 【PARAMETER】Oracle引數:MAX_IDLE_BLOCKER_TIME 解釋OracleBloC
- ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsedHive
- parameter hj8828vip installed Oracle h518vip onOracleH5