这里要说说连接oracle最开始的时候的连接方法:
第一种是:(根据系统默认的ORACLE-SID 这个在环境变量中有设置)
[root@localhost ~]# su - oracle (注:这里也可以临时导入个ORACLE_SID 这个临时变量)
[oracle@localhost ~]$ export ORACLE_SID=mediadb(默认ORACLE_SID是VODAFONE)
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 5 10:14:15 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba;
Connected.
SQL> select name from V$database;
NAME
---------
VODAFONE
第二种是:
------------------------------------------------------------------------
或者:
用户授权:
grant connect,resource,dba to gavin;
grant sysdba to gavin;
commit;
更改数据库用户的密码:(将sys与system的密码改为application.)
alter user sys indentified by application;
alter user system indentified by application;
SQL> create user gavin identified by viewtoo;
-------------------------------------------
(1):
查看当前登陆的数据库实例:
[root@localhost ~]# su - oracle
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 5 10:14:15 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba;
Connected.
SQL> select name from V$database;
NAME
---------
VODAFONE
SQL>
SQL> show parameter db_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string vodafone
SQL> show parameter instance_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string vodafone
SQL>
(2):
怎样查看哪些用户拥有SYSDBA、SYSOPER权限:
SQL> select * from V$pwfile_users;
USERNAME SYSDB SYSOP
------------------------------ ----- -----
SYS TRUE TRUE
或者
SQL> select * from V_$PWFILE_USERS;
USERNAME SYSDB SYSOP
------------------------------ ----- -----
SYS TRUE TRUE
查看当前数据库连接用户
SQL> show user;
USER is "SYS"
(3):
增加数据库用户:(gavin/vodafone)
create user gavin identified by vodafone default tablespace users Temporary TABLESPACE Temp;
用户授权:
grant connect,resource,dba to gavin;
grant sysdba to gavin;
commit;
更改数据库用户的密码:(将sys与system的密码改为application.)
alter user sys indentified by application;
alter user system indentified by application;
(4):
查询归档日志的路径:
SQL> show parameter db_recovery_file_dest;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /zhanggh/flash_recovery_area
db_recovery_file_dest_size big integer 4G
SQL>
或者:
SQL> select name from V$recovery_file_dest;
NAME
--------------------------------------------------------------------------------
/zhanggh/flash_recovery_area
(5):
oracle增加个普通用户:
SQL> create user gavin identified by viewtoo;
User created.
SQL> grant connect, resource to gavin;
Grant succeeded.
SQL>
然后客户端验证下就OK。
-------------------------------------------
sqlplus 清除sql屏幕
SQL> clear scr
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15713890/viewspace-612580/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15713890/viewspace-612580/