没这种经历,不敢瞎说,帮你up吧!^O^
解决方案 »
- 【提问】请教建立远程表空间的事
- 学习SQL
- 关于模糊查询!大家帮我看下,谢谢了
- pid 递归总计所有子类数量,如何写sql?
- 请问在oracle里如何去掉数据后的回车换行符!
- shutdown transactional的问题
- 求助:一个sql的写法,可能是很常见的,但是不知道如何修改
- 在线等 急!!!!
- 初学存储过程,请教高手。里面有段代码有错误,请高手指点。急急
- I can not delete the datafile after shutdown the database ?
- 问个简单的问题:我想把substr(hm,1,2)和sub(hm,4,2)两个值组合成一个字符,怎么放在一起呢?
- 想请问一下sqlplus在没有用到监听器的时候是怎样与本地数据库连接的,,,,
感谢楼上up.
执行命令startup nomount
但是还是会装载第一个数据库。
create database otherdatabase;
这是就会出错,提示:otherdabase 和firstdatabase不符。
在/etc/oratab中去掉orasid这一行。
还是会出错,oracle not available.
哪位给个合适的文档?
oracle foundation I 认证95.00一本。不想买:(
然后执行你的建库脚本吧~
另1:linux下没有WINDOWS的服务这一说,至于怎么调这个库,我就不清楚了~
另2:有一种专门来搞aix/linux的图形客户端也能实现GUI方式的安装;(类似WINDOWS的桌面连接)
哈哈,等其他兄弟拍砖~
哥们执行了create database已经把原来存在的(环境变量里设置的oracle_sid=firstdatabase)
firstdatabase数据库给毁了。:(
有一点不清楚,为什么查了那么多资料,介绍完建第一个库,
就不讲建第二个库呢?更有甚者,直接讲建立tablespace
建数据库连提都不提?为什么啊?
Now the Oracle server is installed we need to create a database to test the installation. If you are using Oracle 7.2.x or earlier, please read the troubleshooting section below. 3.1 Create the Initialisation File
Copy the $ORACLE_HOME/dbs/init.ora to $ORACLE_HOME/dbs/initorcl.ora:
--------------------------------------------------------------------------------$ cd $ORACLE_HOME/dbs
$ cp init.ora initorcl.ora
--------------------------------------------------------------------------------Modify it by adding the following lines: --------------------------------------------------------------------------------db_name = orcl
COMPATIBLE=7.3.3.0.0
--------------------------------------------------------------------------------3.2 Creating the Database Install Script
Create a script file called makedb.sql in the $ORACLE_HOME/dbs directory:
--------------------------------------------------------------------------------connect internal
startup nomount
set echo on
spool makedb.log
create database orcl
maxinstances 1
maxlogfiles 8
datafile '$ORACLE_HOME/dbs/orcl_syst_01.dbf' size 40M reuse
logfile
'$ORACLE_HOME/dbs/orcl_redo_01.dbf' size 1M reuse,
'$ORACLE_HOME/dbs/orcl_redo_02.dbf' size 1M reuse,
'$ORACLE_HOME/dbs/orcl_redo_03.dbf' size 1M reuse;
@$ORACLE_HOME/rdbms/admin/catalog.sql
create tablespace rollback
datafile '$ORACLE_HOME/dbs/orcl_roll_01.dbf' size 8.5M reuse;
create tablespace temp
datafile '$ORACLE_HOME/dbs/orcl_temp_01.dbf' size 5M reuse
temporary;
create tablespace users
datafile '$ORACLE_HOME/dbs/orcl_user_01.dbf' size 10M reuse;
create rollback segment r1 tablespace rollback
storage ( optimal 5M );
alter rollback segment r1 online;
connect system/manager
@$ORACLE_HOME/rdbms/admin/catdbsyn.sql
connect internal
@$ORACLE_HOME/rdbms/admin/catproc.sql
connect system/manager
@$ORACLE_HOME/sqlplus/admin/pupbld.sql
spool off
exit
--------------------------------------------------------------------------------
3.3 Running the Database Installation Script
Start svrmgrl and run the script:
--------------------------------------------------------------------------------$ cd $ORACLE_HOME/dbs
$ svrmgrlOracle Server Manager Release 2.3.3.0.0 - ProductionCopyright (c) Oracle Corporation 1994, 1995. All rights reserved.Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - ProductionSVRMGR> connect internal
Connected.
SVRMGR> startup nomount
ORACLE instance started.
Total System Global Area 4313312 bytes
Fixed Size 41876 bytes
Variable Size 4140364 bytes
Database Buffers 122880 bytes
Redo Buffers 8192 bytes
SVRMGR> @makedb
<loads of messages>
SVRMGR> exit
Server Manager complete.
--------------------------------------------------------------------------------3.4 Starting the Database
Firstly, we need to bring up the database by hand (we will automate this later on). To startup an Oracle database we need to issue the startup command when connected internally:
--------------------------------------------------------------------------------$ svrmgrlOracle Server Manager Release 2.3.3.0.0 - ProductionCopyright (c) Oracle Corporation 1994, 1995. All rights reserved.Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - ProductionSVRMGR> connect internal
Connected.
SVRMGR> startup
ORACLE instance started.
Total System Global Area 4313316 bytes
Fixed Size 41876 bytes
Variable Size 4140368 bytes
Database Buffers 122880 bytes
Redo Buffers 8192 bytes
Database mounted.
Database opened.
SVRMGR> exit
Server Manager complete.
--------------------------------------------------------------------------------3.5 Stopping the Database
It is worth mentioning here that restarting a Linux server without shutting down the Oracle database first there is a high risk of corrupting the database. So, before we issue the Linux shutdown command it is wise to bring down the database:
--------------------------------------------------------------------------------$ svrmgrlOracle Server Manager Release 2.3.3.0.0 - ProductionCopyright (c) Oracle Corporation 1994, 1995. All rights reserved.Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - ProductionSVRMGR> connect internal
Connected.
SVRMGR> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SVRMGR> exit
Server Manager complete.
--------------------------------------------------------------------------------3.6 Create a Default User
The database, as created, has a two special users which are automatically created. These are:
--------------------------------------------------------------------------------Username PasswordSYSTEM MANAGER
SYS change_on_install
--------------------------------------------------------------------------------
These users are typically used to hold the standard data dictionary information for the database. It is a good idea to change the passwords from the defaults as soon as possible. This can be achieved by:
--------------------------------------------------------------------------------sqlplus system/managerSQL*Plus: Release 3.3.3.0.0 - Production on Sat Feb 21 12:43:33 1998Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
Connected to:
Oracle7 Server Release 7.3.3.0.0 - Production ReleaseSQL> alter user system identified by <newpassword>;User altered.SQL> alter user sys identified by <newpassword>;User altered.SQL> exit;
Disconnected from Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - Production
--------------------------------------------------------------------------------
Since the user system/manager is similar to using root on a UNIX machine, we need to create a user with less ability to cause damage. (remember to bring up the database before attempting to create a user) Connect to SQL*Plus and create a user:
--------------------------------------------------------------------------------$ sqlplus system/managerSQL*Plus: Release 3.3.3.0.0 - Production on Sat Feb 21 12:43:33 1998Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
Connected to:
Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - ProductionSQL> create user <user> identified by <psw>
2 default tablespace users
3 temporary tablespace temp;User created.SQL> grant connect, resource to <user>Grant succeeded.SQL> exit
Disconnected from Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - Production
--------------------------------------------------------------------------------Now that you have a new user on the system you can play with the new system. To login to the Oracle database:
--------------------------------------------------------------------------------$ sqlplus <user>/<password>
--------------------------------------------------------------------------------If this completes with no error messages then you have a working Oracle database. If you never want to connect to this database from anywhere but this server then the job is complete, enjoy! If, however, like most people you want to configure the networking software so that you can connect from other machines, keep on reading.