Подключение базы данных

C:\>set nls_lang=russian_cis.ru8pc866
 
C:\>set oracle_sid=orlc
 
C:\>sqlplus /nolog
 
SQL*Plus: Release 10.2.0.1.0 - Production on Ср Мар 30 10:32:04 2011
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 
SQL> conn / as sysdba
Соединено.
SQL> alter user sys identified by system;
 
Пользователь изменен.
 
SQL>

C:\>set oracle_sid=orcl
 
C:\>emctl stop dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
[url]http://my_computer:1158/em/console/aboutApplication[/url]
The OracleDBConsoleorcl service is stopping...........
The OracleDBConsoleorcl service was stopped successfully.
 
 
C:\>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
[url]http://my_computer:1158/em/console/aboutApplication[/url]
Starting Oracle Enterprise Manager 10g Database Control ...The OracleDBConsoleor
cl service is starting..................
The OracleDBConsoleorcl service was started successfully.
 
 
C:\>

# tnsnames.ora Network Configuration File: D:\app\1\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
 
ORACLE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = Oracle)
    )
  )
 
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )