標籤：style 錯誤 資料 support orm trace and writing with
在startup 啟動資料庫後，使用plsql去串連資料庫時，
出現ora-12170 錯誤: 在啟動、關閉或者重啟oracle監聽器之前確保使用lsnrctl status命令檢查oracle監聽器的狀態：1、$lsnrctl status：檢查當前監聽器的狀態2、$lsnrctl start [listener-name] 啟動所有的監聽器,可以指定名字來啟動特定的監聽器3、$lsnrctl stop [listener-name] 關閉所有的監聽器，可以指定名字來關閉特定的監聽器4、$lsnrctl reload 重啟監聽器，此命令可以代替lsnrctl stop,lsnrctl start5、lsnrctl hep 可以顯示所有可用的監聽器命令常用命令參數：start - Start the Oracle listener
stop - Stop the Oracle listener
status - Display the current status of the Oracle listener
services - Retrieve the listener services information
version - Display the oracle listener version information
reload - This will reload the oracle listener SID and parameter files. This is equivalent to lsnrctl stop and lsnrctl start.
save_config - This will save the current settings to the listener.ora file and also take a backup of the listener.ora file before overwriting it. If there are no changes, it will display the message “No changes to save for LISTENER”
trace - Enable the tracing at the listener level. The available options are ‘trace OFF’, ‘trace USER’, ‘trace ADMIN’ or ‘trace SUPPORT’
spawn - Spawns a new with the program with the spawn_alias mentioned in the listener.ora file
change_password - Set the new password to the oracle listener (or) change the existing listener password.
show - Display log files and other relevant listener information
ora-12170 與 Oracle lsnrctl
