原oracle是别人安装的,数据库名,用户名密码均不知道,如何查看数据名?
还有root用户怎么查看?就知道root的用户名和密码。
这个问题怎么解决?
还有root用户怎么查看?就知道root的用户名和密码。
这个问题怎么解决?
解决方案 »
- 新手求助!谢谢!
- oracle触发器:报错ora-04091
- pl/sql Developer 7.0 有没有快捷键切换窗口呢?
- ORACLE9i数据库移行问题-求助
- 关于ORACLE10G与sqlserver2005的区别问题。
- access 中的嵌套查询在oracle里怎么实现?
- 请教这样的集合如何查询?
- 两个小问题
- 在视图里可不可以用sum(),group by......? 再现,急,高分请教
- 统计问题1-group by to_char(my_time,'HH24')的不完全显示
- 在线送分,怎样给一个数据库配置多个服务名(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;