select owner,object_name,object_type, status from dba_objects
as of timestamp to_date('10/25/2018 00:00:00','mm/dd/yyyy hh24:mi:ss')
where object_name = 'TEST' and OWNER='TEST';
ERROR: ORA-07391: sftopn: fopen error, unable to open text file. - SOLUTION - Specify file locations & try to create the file again. Like below SQL> create pfile='/backup/expdp/initdev.ora' from spfile='/oracle/product/10.2.0/db_1/dbs/spfiledev.ora'; File created. Thank You !
- Here will see how to deal with => ORA-28007: the password cannot be reused - I got a request from client user, stating his account has been locked. When I check the status of the account I found the below. connect to SYS user & execute the below query of that database. SQL> select password,username,account_status,profile from dba_users where username='TEST'; PASSWORD USERNAME ACCOUNT_STATUS PROFILE ------------------ ---------------- ------------------------------- -------------------- AB2Aa8AC9971521e3 TEST EXPIRED(GRACE)&LOCKED NONAPP_USERS So, then I have unlocked the account and checked the same again & I found the below results. ...
Alert Log: [oracle@ bdump]$ view alert_HDRTG12.log Thu May 28 22:05:42 PDT 2015 Process P021 died, see its trace file Thu May 28 22:05:47 PDT 2015 Process m000 died, see its trace file Thu May 28 22:05:47 PDT 2015 ksvcreate: Process(m000) creation failed Thu May 28 22:06:00 PDT 2015 Process P021 died, see its trace file Thu May 28 22:06:10 PDT 2015 Process P021 died, see its trace file Thu May 28 22:06:43 PDT 2015 [oracle@bdump]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Thu May 28 23:38:59 2015 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select name from v$database; NAME --------------------------- HDRTG12 SQL> select * from v$resource_limit where RESOURCE_NAME in ('sessions','processes','transactions'); RESOURCE...
Comments
Post a Comment