原oracle是别人安装的,数据库名,用户名密码均不知道,如何查看数据名?
还有root用户怎么查看?就知道root的用户名和密码。
这个问题怎么解决?
还有root用户怎么查看?就知道root的用户名和密码。
这个问题怎么解决?
解决方案 »
- 一个简单的表关联sql语句,请教!
- 大虾快来 存储过程告急
- Oracle 安装问题
- >>>>> 关于空值(NULL)的比较 <<<<<
- 请教高手一复杂sql语句
- 菜鸟提问:startup mount;startup nomount;startup 这三个启动数据库的语句有什么区别?
- ★★在sqlplus中怎么将查询的结果导出到一个txt文件中,默认存在什么地方,是用Spool吗,参数可以设置吗?★★
- sys用户是不是不能进SQL*PLUS
- 问一个查询的问题
- 在linux中配置oracle client 后输入./sqlplus 报错:-bash: ./sqlplus: /lib/ld-linux.so.2: bad
- 在线送分,怎样给一个数据库配置多个服务名(Service_name),解决了马上给分
- Oracle 9i中,在客户端能否创建数据库和创建资料档案库?
passwd oracle2. 使用oracle用户登录操作系统
或在root下su oracle3. 启动监听:
lsnrctl
start 查看监听状态:
status4. 登入数据库
sqlplus /nolog
conn / as sysdba;
5. 启动数据库
startup现在你已经用sys进入数据库了, 想干什么肯定都能干, 呵呵
su - oracle
2.查看ORACLE_SID
echo $ORACLE_SID
3.查看数据库里有什么数据库用户
sqlplus "/as sysdba" -- 这个是以sys用户登录数据库的
select username from dba_users; -- 查看数据库用户
-------- 不知道用户的密码不要紧,可以修改
alter user user_name identified by passwd;祝你好运
SQL> select * from v$database;
DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS_TIME PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TIME LOG_MODE CHECKPOINT_CHANGE# ARCHIVE_CHANGE# CONTROLFILE_TYPE CONTROLFILE_CREATED CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE# CONTROLFILE_TIME OPEN_RESETLOGS VERSION_TIME OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL REMOTE_ARCHIVE ACTIVATION# SWITCHOVER# DATABASE_ROLE ARCHIVELOG_CHANGE# ARCHIVELOG_COMPRESSION SWITCHOVER_STATUS DATAGUARD_BROKER GUARD_STATUS SUPPLEMENTAL_LOG_DATA_MIN SUPPLEMENTAL_LOG_DATA_PK SUPPLEMENTAL_LOG_DATA_UI FORCE_LOGGING PLATFORM_ID PLATFORM_NAME RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN FLASHBACK_ON SUPPLEMENTAL_LOG_DATA_FK SUPPLEMENTAL_LOG_DATA_ALL DB_UNIQUE_NAME STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGET FS_FAILOVER_THRESHOLD FS_FAILOVER_OBSERVER_PRESENT FS_FAILOVER_OBSERVER_HOST
---------- --------- ----------- ----------------- -------------- ----------------------- -------------------- ------------ ------------------ --------------- ---------------- ------------------- --------------------- ------------------- ---------------- -------------- ------------ ---------- -------------------- -------------------- -------------- ----------- ----------- ---------------- ------------------ ---------------------- -------------------- ---------------- ------------ ------------------------- ------------------------ ------------------------ ------------- ----------- -------------------------------------------------------------------------------- ---------------------------- ---------------------- ----------- ------------------ ------------------------ ------------------------- ------------------------------ -------------------------- --------------------- ------------------------------ --------------------- ---------------------------- --------------------------------------------------------------------------------
1189901495 ORCL 2008-8-7 10 530559 2008-8-7 10:26 1 2006-6-26 6:55:43 NOARCHIVELOG 14265243 14134317 CURRENT 2008-8-7 10:25:59 9062 14303361 2008-11-11 10:54 NOT ALLOWED 2008-8-7 10: READ WRITE MAXIMUM PERFORMANCE UNPROTECTED ENABLED 1189942967 1189942967 PRIMARY 530559 DISABLED SESSIONS ACTIVE DISABLED NONE NO NO NO NO 17 Solaris Operating System (x86) 2 2 14304127 NO NO NO orcl 0 DISABLED 0
SQL>
串行了,不好意思
sqlplus /nolog
conn / as sysdba
select username from dba_users;
alter user xx identified by newpaddwd;
exit
/u01/app/oracle/product/10.2.0/db_1/network/admin下的sqlnet.oraSQLNET.AUTHENTICATION_SERVICES = (NONE)如果有这样的设置,把它注释掉#SQLNET.AUTHENTICATION_SERVICES = (NONE)
把结果贴上来,可能安装数据库的那个人用的用户名不是oracle
daemon:!:1:1::/etc:
bin:!:2:2::/bin:
sys:!:3:3::/usr/sys:
adm:!:4:4::/var/adm:
uucp:!:5:5::/usr/lib/uucp:
guest:!:100:100::/home/guest:
nobody:!:4294967294:4294967294::/:
lpd:!:9:4294967294::/:
lp:*:11:11::/var/spool/lp:/bin/false
invscout:*:200:1::/var/adm/invscout:/usr/bin/ksh
snapp:*:201:12:snapp login user:/usr/sbin/snapp:/usr/sbin/snappd
nuucp:*:6:5:uucp login user:/var/spool/uucppublic:/usr/sbin/uucp/uucico
imnadm:*:188:188::/home/imnadm:/usr/bin/ksh
ora:!:202:201::/ora:/usr/bin/csh
ipsec:*:203:1::/etc/ipsec:/usr/bin/ksh
mqm:*:300:300::/home/mqm:/usr/bin/ksh
hzmz:!:600:201::/tomcat/hzmz:/usr/bin/ksh
ierp:!:204:1::/IERP/ierp:/usr/bin/ksh
test:!:7:4::/home/test:/usr/bin/ksh
hlz:!:205:1::/home/hlz:/usr/bin/ksh
给个参考把路径改成linux的目录
-- Create table space
CREATE TABLESPACE "SICDATA"
LOGGING
DATAFILE 'd:\oracle\product\10.2.0\oradata\SICDATA1.ora' SIZE 512M
AUTOEXTEND
ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
/-- Create temp tablespace
CREATE
TEMPORARY TABLESPACE "SICTEMP" TEMPFILE
'd:\oracle\product\10.2.0\oradata\SICTEMP1.ora' SIZE 128M
AUTOEXTEND
ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM
SIZE 1M
su - orasqlplus /nolog
conn / as sysdba
select name from v$database;