How to connect to Oracle 8i Database and start database services?
Set the required variables from command prompt.
> set ORACLE_SID=TestID
> set ORACLE_HOME=D:\oracleHomePath
> set PATH=%ORACLE_HOME%\bin;%PATH%
> svrmgr30
Oracle Server Manager Release ******
PL/SQL Release 8.0.6.0.0
SVRMGR> connect username/password;
Connected.
SVRMGR> startup;
ORACLE instance started.
Total System Global Area
.....Database Opened.
SVRMGR> select dbid, name, log_mode from v$database;
NAME DBID LOG_MODE
TestID 2343434**** NOARCHIVELOG
Here database is started and up running.
Comments
Post a Comment