-
编辑 删除
解决oem ORA-28000: the account is locked (DBD ERROR: OCISessionBegin)
solution：先看看DBSNMP用户是否被锁定，如锁定，先解锁ALTER USER DBSNMP ACCOUNT UNLOCK;如有需要，更改密码ALTER USER DBSNMP IDENTIFIED BY XXXX;然后执行emca -config dbcontrol db -repos create按提示输...
-
编辑 删除
Oracle备忘
无法登陆:ORA-12162: TNS:net service name is incorrectly specified错误原因：未指定ORACLE_SID解决办法：export ORACLE_SID=xxxx
-
编辑 删除
Error accessing PRODUCT_USER_PROFILE
登陆普通用户出现警告SQL> conn scott/tiger;Error accessing PRODUCT_USER_PROFILEWarning: Product user profile information not loaded!You may need to run PUPBLD.SQL as SYSTEMConnected.经查，需要运行$ORACLE_HOME/sqlplus/admin/pupbld.sql但是用sysdba登陆执行了以后还是报错，google了一番，才发现原来要用system用户登陆执行才行。。。[@more@]
-
编辑 删除
RMAN基础
1、创建rman默认表空间SQL> create tablespace rman datafile '/oracle/oradata/test/rmandata1' size 125M autoextend on next 50M maxsize 500M;SQL> grant recovery_catalog_owner to rman identified by rman;SQL> alter user rman default tablespace rman quota unlimited on rman;[@more@]2、创建catalog //数据库数量不多时，不需使用catalog $ rman catalog rman/rman RMAN> create catalog; 3、注册数据库 $ rman target / catalog rman/rman RMAN> register database; 4、执行备份
