oracle如何重置指令 oracle重啟命令詳解

如何在命令行重啟oracle數據庫

方法：

創新互聯主營西寧網站建設的網絡公司,主營網站建設方案,成都app開發,西寧h5微信平臺小程序開發搭建,西寧網站營銷推廣歡迎西寧等地區企業咨詢

1.?打開secureCRT，連接到數據庫所在的linux機器。若用戶為root，請輸入命令“su - oracle”并回車，若要密碼，輸入密碼后并回車，就切換到了oracle用戶下。

2.?關掉oracle的監聽進程:命令為“lsnrctl stop”并回車，這時外部沒法連接到數據庫了。如圖有提示關閉成功信息。

3.先殺掉所有session，“ps -ef|grep $ORACLE_SID|grep -v ora_|grep LOCAL=NO|awk '{print $2}'|xargs kill”也可以用其他辦法。然后用sqlplus登錄到數據庫。命令依次為：“sqlplus /nolog”-“connect / as sysdba”?，最后用命令關閉oracle數據庫"shutdown immediate" 。關閉命令的時候需要等待點時間，成功后會有如圖的提示。

4.用命令"exit"退出sqlplus。然后用命令“lsnrctl start”啟動數據庫的監聽進程。如圖提示語句表明啟動成功。

5.先用sqlplus登錄到數據庫。命令依次為：“sqlplus /nolog”-“connect / as sysdba”。然后輸入命令“startup”并回車。等待幾分鐘會出現如圖提示信息。最后用命令“exit”退出sqlplus。

oracle 如何重置用戶密碼

方法/步驟用CRT以安裝oracle數據庫的用戶連接oracle數據庫所在服務器。（以服務器為linux 為例）輸入命令: sqlplus /nolog ,進入oracle控制臺，并輸入 conn /as sysdba;以DBA角色進入。連接成功后，輸入“select username from dba_users”

Oracle忘記密碼如何重置

沒關系的，忘記密碼后可以通過sysdba用戶重新進行密碼設置。 sql： conn /as sysdba;--用dba權限登錄 sql：alter user username identified by newpassword; --修改忘記密碼用戶的密碼 sql：conn username/newpassword；--用此用戶登錄。

怎么樣在Windows下編寫批處理腳本來啟動和重置Oracle數據庫

cmd啟動Oracle數據庫

新建一個bat文件，復制內容進去，雙擊即可啟動.

@echo off

net start OracleXETNSListener 2nul

net start OracleServiceXE 2nul

@oradim -startup -sid XE -starttype inst nul 21

Oracle重置數據庫命令

新建bat文件，復制以下內容，然后執行。

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

@echo off

REM

REM The script assumes that user can connect using "/ as sysdba"

REM

REM =================

REM Restore procedure

REM =================

REM

REM If Installed Oracle home is also lost and oracle binaries were

REM re-installed or the Oracle is installed to new oracle home location

REM compared to backup time, then user will be prompted to enter Flash

REM Recovery Area location.

REM

REM For database in NoArchiveLog mode, database is restored to last offline

REM backup time/scn;

REM For database in Archive log mode, database is restored from last backup

REM and a complete recovery is attempted. If complete recovery fails,

REM user can open the database with resetlogs option provided the files

REM are not recovery fuzzy.

REM

REM The restore log is saved in ?/DATABASE/OXE_RESTORE.LOG

REM

setlocal

set /p inp="This operation will shut down and restore the database. Are you sure [Y/N]?"

:checkinp

if /i "%inp%" == "Y" goto :confirmedyes

if /i "%inp%" == "n" exit

:Askagain

set /p inp=

goto :checkinp

:confirmedyes

echo Restore in progress...

echo db_name=xe %temp%\rman_dummy.ora

echo sga_target=270M %temp%\rman_dummy.ora

net start oracleserviceXe

REM Startup database in nomount mode using RMAN...

echo set echo on^;

echo startup nomount pfile=%temp%\rman_dummy.ora force^;

) %temp%\restore_rman0.dat

rman target / @%temp%\restore_rman0.dat

if not %errorlevel% == 0 set Errorstr= RMAN Error - could not startup dummy instance goto :restorefailederr

echo connect / as sysdba^;

echo set head off

echo set echo off

echo set linesize 515

echo variable var varchar2^(512^)^;

echo execute :var := sys.dbms_backup_restore.normalizefilename^(^'SPFILE2INIT^'^)^;

echo spool %temp%\spfile2init.log

echo select sys.dbms_backup_restore.normalizefilename^(^'SPFILE2INIT.ORA^'^) spfile2init from dual^;

echo exit^;

) %temp%\spfile2init.sql

sqlplus /nolog @%temp%\spfile2init.sql nul

FOR /F %%i in (%temp%\spfile2init.log) do set SPFILE2INIT=%%i

echo connect / as sysdba;

echo set head off

echo set echo off

echo set linesize 515

echo variable var varchar2^(512^)^;

echo execute :var := sys.dbms_backup_restore.normalizefilename^(^'FRA_LOC^'^)^;

echo spool %temp%\restore_rmanlog.log

echo select sys.dbms_backup_restore.normalizefilename^(^'OXE_RESTORE.LOG^'^) RESTORE_RMANLOG from dual^;

echo exit^;

) %temp%\restore_rmanlog.sql

sqlplus /nolog @%temp%\restore_rmanlog.sql nul

FOR /F %%i in (%temp%\restore_rmanlog.log) do set RESTORE_RMANLOG=%%i

if not exist ^"%SPFILE2INIT%^" goto get_rcvarea_loc

echo set echo on^;

echo shutdown immediate^;

echo startup nomount pfile=^"%SPFILE2INIT%^"^;

echo restore ^(spfile from autobackup^) ^(controlfile from autobackup^)^;

echo startup mount force^;

echo configure controlfile autobackup off^;

echo restore database^;

) %temp%\restore_rman1.dat

rman target / @%temp%\restore_rman1.dat trace "%RESTORE_RMANLOG%"

if not %errorlevel% == 0 set Errorstr= RMAN Error - See log for error goto :restorefailederr

goto restored_files

:get_rcvarea_loc

set /p rcvarea_loc="Enter the flash recovery area location:"

echo set echo on^;

echo restore ^(spfile from autobackup db_recovery_file_dest=^'%rcvarea_loc%^'^)^;

echo startup nomount force^;

echo restore ^(controlfile from autobackup^)^;

echo alter database mount^;

echo configure controlfile autobackup off^;

echo restore database^;

) %temp%\restore_rman1.dat

rman target / @%temp%\restore_rman1.dat trace "%RESTORE_RMANLOG%"

if not %errorlevel% == 0 set Errorstr= RMAN Error - See log for error goto :restorefailederr

goto restored_files

:restored_files

echo connect / as sysdba^;

echo declare cursor n1 is select name from v$tempfile^;

echo begin

echo for a in n1

echo loop

echo begin

echo sys.dbms_backup_restore.deletefile^(a.name^)^;

echo exception

echo when others then

echo null^;

echo end^;

echo end loop^;

echo end^;

echo /

echo exit^;

echo /

) %temp%\deltfile.sql

sqlplus /nolog @%temp%\deltfile.sql nul

echo connect / as sysdba^;

echo set head off

echo set echo off

echo spool %temp%\logmode.log

echo select log_mode from v$database^;

echo exit^;

) %temp%\logmode.sql

sqlplus /nolog @%temp%\logmode.sql nul

FOR /F %%i in (%temp%\logmode.log) do set LOGMODE=%%i

if "%LOGMODE%" == "NOARCHIVELOG" goto process_noarchivelog

if "%LOGMODE%" == "ARCHIVELOG" goto process_archivelog

set Errorstr= Unknown log mode : %LOGMODE%

goto :restorefailederr

:process_noarchivelog

echo set echo on^;

echo alter database open resetlogs;

) %temp%\restore_rman2.dat

rman target / @%temp%\restore_rman2.dat trace "%RESTORE_RMANLOG%" append

if not %errorlevel% == 0 set Errorstr= RMAN Error - See log for details goto :restorefailederr

goto :restoresucess

:process_archivelog

echo set echo on^;

echo recover database^;

echo alter database open resetlogs;

) %temp%\restore_rman2.dat

rman target / @%temp%\restore_rman2.dat trace "%RESTORE_RMANLOG%" append

if not %errorlevel% == 0 set Errorstr= RMAN Error - See log for details goto :restorefailederr

goto :restoresucess

:restoresucess

echo Restore of the database succeeded.

echo Log file is at %RESTORE_RMANLOG%.

pause Press any key to exit

exit

goto :EOF

:restorefailederr

echo ==================== ERROR =============================

echo Restore of the database failed.

echo %Errorstr%.

echo Log file is at %RESTORE_RMANLOG%.

echo ==================== ERROR =============================

pause Press any key to exit

exit

goto :EOF

網頁名稱：oracle如何重置指令 oracle重啟命令詳解
網頁地址：http://www.yijiale78.com/article6/hgocig.html

成都網站建設公司_創新互聯，為您提供網站建設、自適應網站、面包屑導航、、定制開發、虛擬主機

聲明：本網站發布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網站立場，如需處理請聯系客服。電話：028-86922220；郵箱：631063699@qq.com。內容未經允許不得轉載，或轉載時需注明來源：創新互聯

猜你還喜歡下面的內容

99偷拍视频精品区一区二,口述久久久久久久久久久久,国产精品夫妇激情啪发布,成人永久免费网站在线观看,国产精品高清免费在线,青青草在线观看视频观看,久久久久久国产一区,天天婷婷久久18禁,日韩动漫av在线播放直播

oracle如何重置指令 oracle重啟命令詳解

如何在命令行重啟oracle數據庫

oracle 如何重置用戶密碼

Oracle忘記密碼如何重置

怎么樣在Windows下編寫批處理腳本來啟動和重置Oracle數據庫