📄 00000058.htm
字号:
Fixed Size 41876 bytes <BR>Variable Size 4140368 bytes <BR>Database Buffers 122880 bytes <BR>Redo Buffers 8192 bytes <BR>Database mounted. <BR>Database opened. <BR>SVRMGR> exit <BR>Server Manager complete. <BR> ______________________________________________________________ <BR> <BR>3.5 停止资料库 <BR> <BR> 先旨声明,在未关闭一个 Oracle 资料库的情况下重新启动 Linux 很有可能会使 <BR> 资料库损毁。 <BR> <BR> 因此,在我们执行 Linux 的 shutdown 指令前最好先关闭资料库: <BR> ______________________________________________________________ <BR> <BR>$ svrmgrl <BR> <BR>Oracle Server Manager Release 2.3.3.0.0 - Production <BR> <BR>Copyright (c) Oracle Corporation 1994, 1995. All rights reserved. <BR> <BR>Oracle7 Server Release 7.3.3.0.0 - Production Release <BR>PL/SQL Release 2.3.3.0.0 - Production <BR> <BR>SVRMGR> connect internal <BR>Connected. <BR>SVRMGR> shutdown <BR>Database closed. <BR>Database dismounted. <BR>ORACLE instance shut down. <BR>SVRMGR> exit <BR>Server Manager complete. <BR> ______________________________________________________________ <BR> <BR>3.6 建立内定用户 (Default User) <BR> <BR> 在建立资料库时,会自动产生两个特别的用户: <BR> ______________________________________________________________ <BR> <BR>Username Password <BR> <BR>SYSTEM MANAGER <BR>SYS change_on_install <BR> ______________________________________________________________ <BR> <BR> 这些用户通常是用来保存标准的资料字典 (data dictionary) 资料在资料库中。 <BR> 尽快把密码修改是一个好主意。 <BR> <BR> 可以这样做: <BR> ______________________________________________________________ <BR> <BR>sqlplus system/manager <BR> <BR>SQL*Plus: Release 3.3.3.0.0 - Production on Sat Feb 21 12:43:33 1998 <BR> <BR>Copyright (c) Oracle Corporation 1979, 1996. All rights reserved. <BR> <BR> <BR>Connected to: <BR>Oracle7 Server Release 7.3.3.0.0 - Production Release <BR> <BR>SQL> alter user system identified by <newpassword>; <BR> <BR>User altered. <BR> <BR>SQL> alter user sys identified by <newpassword>; <BR> <BR>User altered. <BR> <BR>SQL> exit; <BR>Disconnected from Oracle7 Server Release 7.3.3.0.0 - Production Release <BR>PL/SQL Release 2.3.3.0.0 - Production <BR> ______________________________________________________________ <BR> <BR> 用户 system/manager 就如 UNIX 中的 root,因此我们要建立另一个权力较少的 <BR> 用户以防损失。(记著要先开启资料库才建立用户。) <BR> <BR> 连接到 SQL*Plus 及建立用户: <BR> ______________________________________________________________ <BR> <BR>$ sqlplus system/manager <BR> <BR>SQL*Plus: Release 3.3.3.0.0 - Production on Sat Feb 21 12:43:33 1998 <BR> <BR>Copyright (c) Oracle Corporation 1979, 1996. All rights reserved. <BR> <BR> <BR>Connected to: <BR>Oracle7 Server Release 7.3.3.0.0 - Production Release <BR>PL/SQL Release 2.3.3.0.0 - Production <BR> <BR>SQL> create user <user> identified by <psw> <BR> 2 default tablespace users <BR> 3 temporary tablespace temp; <BR> <BR>User created. <BR> <BR>SQL> grant connect, resource to <user> <BR> <BR>Grant succeeded. <BR> <BR>SQL> exit <BR>Disconnected from Oracle7 Server Release 7.3.3.0.0 - Production Release <BR>PL/SQL Release 2.3.3.0.0 - Production <BR> ______________________________________________________________ <BR> <BR> 系统中已有一个新用户,你可以用他来试用新系统。要签入 Oracle 资料库: <BR> ______________________________________________________________ <BR> <BR>$ sqlplus <user>/<password> <BR> ______________________________________________________________ <BR> <BR> 如果这在没有错误讯息的情况下完成,你已有一个运作中的 Oracle 资料库。如 <BR> 果你只会从这部电脑连接到这资料库,而不会从其他地方,你可休息了! <BR> <BR> 不过,如果你像大部分人般想设定网络软件使你可以从其他电脑连接,请继续读 <BR> 下去。 <BR> <BR>4. 在伺服器上设定 SQL*Net <BR> <BR> 所有这些档案都会用於设定 Oracle 的网络软件(SQL*Net,和 Oracle8 的 <BR> Net8 差不多)。这些档案应该都建立在伺服器中的 <BR> $ORACLE_HOME/network/admin 目录。 <BR> <BR>4.1 tnsnames.ora <BR> <BR> TNSNAMES.ORA 档设定所有这电脑提供的服务。现在我们描述所有挂上了伺服器的 <BR> 资料库。对伺服器上所有资料库你要加上类似以下的一段: <BR> ______________________________________________________________ <BR> <BR>orcl.world = <BR> (DESCRIPTION = <BR> (ADDRESS_LIST = <BR> (ADDRESS = <BR> (COMMUNITY = tcp.world) <BR> (PROTOCOL = TCP) <BR> (Host = <INSERT HOST NAME OF SERVER HERE> ) <BR> (Port = 1521) <BR> ) <BR> (ADDRESS = <BR> (COMMUNITY = tcp.world) <BR> (PROTOCOL = TCP) <BR> (Host = <INSERT HOST NAME OF SERVER HERE> ) <BR> (Port = 1526) <BR> ) <BR> ) <BR> (CONNECT_DATA = (SID = ORCL) <BR> ) <BR> ) <BR> ______________________________________________________________ <BR> <BR>4.2 listener.ora <BR> <BR> listener.ora 档描述所有其他电脑可得到的服务及伺服器的监听程式 <BR> (listener) 所需的所有设定。 <BR> <BR> 它有一段包括监听程式名称、监听程式地址、监听程式提供服务的资料库及参数 <BR> 设定 (listener name, listener address, databases served by the <BR> listener and configuration parameters)。 <BR> <BR> 这里有一个例子: <BR> ______________________________________________________________ <BR> <BR># 监听程式名称及所收听的地址 <BR>LISTENER = <BR> ( ADDRESS_LIST = <BR> (ADDRESS = <BR> (PROTOCOL=tcp) <BR> (HOST=<INSERT HOST>) <BR> (PORT=1521) <BR> (COMMUNITY=UK_SUP_TCPIP) <BR> ) <BR> (ADDRESS = <BR> (PROTOCOL=ipc) <BR> (KEY=700) <BR> (COMMUNITY=UK_SUP_TCPIP) <BR> ) <BR> ) <BR> <BR># 列出监听程式提供的服务 <BR>SID_LIST_LISTENER= <BR> (SID_LIST= <BR> (SID_DESC= <BR> (SID_NAME=orcl) <BR> (ORACLE_HOME=/home/oracle/7.3.3.0.0) <BR>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -