SQL & PL/SQL :: ORA-01994 - GRANT Failed / Password File Missing Or Disabled

Apr 5, 2012

When I create the orapwd file the sys user is not in the file,The problem started when I tried to grant sysdba privileges to sys

[oracle@bg2mo08i3 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Apr 5 18:47:06 2012

Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production

SQL> grant sysdba to sys;
grant sysdba to sys
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled

SQL> shutdown immediate;

From the postings I read I shutdown the DB and I created a new orapwd file:
$ orapwd file=$ORACLE_HOME/dbs/orapwSID password=password entries=30 force=y

SQL> startup;

Started the DB, verified that the password parameter is set to EXCLUSIVE.

SQL>show parameter password;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL>

SQL> select * from v$pwfile_users;
no rows selected
SQL>

Shouldn't the sys user be listed in the v$pwfile_users?

[oracle@bg2mo08i3 dbs]$ ls -l ora*
-rw-r----- 1 oracle oinstall 1536 Apr 5 18:02 orapwSID

Are these permissions and ownership correct?

I can connect using sys's password: SQL> connect sys/sysPASSWORD as sysdba Connected

View 12 Replies


ADVERTISEMENT

Save Password Disabled In Login Screen

Dec 6, 2011

I have Toad 9.6.1 already installed on my machine and have now installed Toad 10.6 . unfortunately the Save Passwords option on the Connection screen is disabled. how do I enable that option.

View 2 Replies View Related

Security :: Create Password File / Don't Know Password Of Sys User

Jun 5, 2012

I want to know what if any person don't know the password of SYS, can he create password file, becauase i dont know the password of sys users, generally login with '/ as sysdba',

View 4 Replies View Related

Security :: Difference Between Grant All On Any Table And Grant All On Table_name

Oct 31, 2012

I would like to know what happens when we fire:

grant all on any table to user_name;

and

grant all on table_name to user_name;

Actually I was performing "grant all on table_name to user_name;" to grant the privilege but 1 of my friends suggested "grant all on any table to user_name;"

View 5 Replies View Related

Enterprise Manager :: Jvm.dll File Missing?

Jan 21, 2010

While running "Prompt>Emctl resetTZ agent"

it gives error message: jvm.dll missing....

View 1 Replies View Related

SQL & PL/SQL :: Password For Zip File

Jul 4, 2012

We have a procedure which compress and email a file (account stmt) to 100s of customers daily. Need protecting that zip file with password before emailing.

It is something similar to credit cared statement where only the recipient should able to open.

View 4 Replies View Related

Sqlnet.ora Network Configuration File (parameters Missing)

Dec 18, 2012

Just now i create sqlnet,ora  through NETCA

My  SQLNET.ora contains following informations only..

# sqlnet.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES)
*>> Help me >>*

why it did n't display all parameters ? I need to set SQLNET.AUTHENTICATION_SERVICES = NONE

View 78 Replies View Related

Creation Control File Failed?

Nov 30, 2004

I am cloning a database from a cold backup in archivelog mode using the control file script but failes:

STARTUP NOMOUNT
CREATE CONTROLFILE DATABASE PROD NORESETLOGS ARCHIVELOG
:
:
:
ALTER DATABASE OPEN;
ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORADATA\PROD\TEMP01.DBF'

[code]...

Tried again with RESETLOGS:

STARTUP NOMOUNT
CREATE CONTROLFILE DATABASE PROD RESETLOGS ARCHIVELOG
:

ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-00344: unable to re-create online log 'D:\ORADATA\PROD\REDO01B.ORA'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

View 3 Replies View Related

Error In Creating Password File

Dec 2, 2010

I am creating prim and phy standby on same WIN machine. I have done with all settings. I can do TNSPING to both oracle_sid.I am trying to connect as sysdba to UP the phy standby. But it gives below error:

Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error

So i tried creating password file for phy standby. But gives below error:

Unable to find error file %ORACLE_HOME%\RDBMS\opw<lang>.msb

I am running it from proper dir.

View 4 Replies View Related

Security :: Password File Authentication

Jan 5, 2013

What is happening here:

c:usersjohnhome>
c:usersjohnhome>orapwd file=%ORACLE_HOME%databasePWDorcl.ora password=oracle
c:usersjohnhome>sqlplus sys/garbage@orcl as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sat Jan 5 18:25:06 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

orcl> sho user
USER is "SYS"
orcl> select sys_context('userenv','ip_address') from dual;
SYS_CONTEXT('USERENV','IP_ADDRESS')
---------------------------------------------------------------------------------------------------
127.0.0.1

orcl>Why can I get a sys login, when I am connecting through the listener and giving an incorrect password? The listening address is a loopback address, is Oracle clever enough to realize that I am in fact logged on to the server as a member of the OSDBA group? I didn't think that information was passed through SQL*Net.

View 3 Replies View Related

Database File 1 Failed Verification Check

Apr 3, 2011

i did the following steps for resolving.

1 alter database backup controlfile to trace;

2 startup nomount;

3 recover database using backup controlfile;//in this step generate error msg "database not mounted"

4 alter database open// this is also happend above error

ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/u01/app/oracle/oradata/DB11G/system01.dbf'
ORA-01207: file is more recent than control file - old control file

View 6 Replies View Related

SQL & PL/SQL :: ORA-22288 / File Or LOB Operation FILEOPEN Failed

May 3, 2011

My Login is System

Already created Directory MY_DIR in c:mydir

Showing Following error

1 DECLARE
2 src_lob BFILE := BFILENAME('MY_DIR','C:
mi2Blue.jpg');
3 dest_lob BLOB;
4 BEGIN
5 INSERT INTO lob_table VALUES(2, EMPTY_BLOB())
6 RETURNING doc INTO dest_lob;

[code].....

View 21 Replies View Related

RMAN :: Recovery Failed In Control File?

Sep 27, 2013

I took database backup without "change the controlfile configuration autobackup on".. and unfortunately i deleted my controlfile. Then I tried to restore my controlfile but it gives error,now how can i restore controlfile is there any other way to restore controlfile with aautobackup..

View 17 Replies View Related

Recovery Manager (RMAN) :: Filename For Datafile Is Missing In Control File

Jun 15, 2012

DB:11.2.0.2.0
Oracle Apps:12.1.3
O/S:AIX 6.1 64 bits

RMAN backup throws the error:

RMAN-06169: could not read file header for datafile 40 error reason 1
RMAN-06169: could not read file header for datafile 41 error reason 1
RMAN-06169: could not read file header for datafile 40 error reason 1
released channel: oem_disk_backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/14/2012 07:54:43
[code]...

Could we skip the backup of the above missing files using RMAN -> backup database skip inaccessible;On further research, this would compromise tablespace SYSAUX recoverability...Questions:

1) What caused the above missing files to get created?
2) What is recommended: Recover the datafiles?

View 10 Replies View Related

Security :: Create Password File In Oracle 10g?

Nov 28, 2011

I want to create password file in Oracle 10g, setp to create password file.

View 5 Replies View Related

Trace File - MVs Failed (ORA-10980 Error Encountered)

Oct 19, 2010

In Trace file I am always geeting one error "Error encountered: ORA-10980" due to which MVs fails . how to overcome from this error?

View 2 Replies View Related

(failed To Close File) Error Message While Backing Up DB?

May 30, 2012

We have been getting the below error message, while backing up the DB(Full DB backup) via netbackup. The DB version is 10.2.0.3 (64bit). The archive backup goes fine. the problem is with the full backup.

input datafile fno=00241 name=/u106/oradata/iwhdbqa/iwh_mvlog_01x.dbf
channel CH02: starting piece 1 at 29-MAY-12
RMAN-03009: failure of backup command on CH01 channel at 05/29/2012 21:41:28
ORA-19506: failed to create sequential file, name="iwhdbqa_20120529210533_db_ipnc7n6l_1_1", parms=""

[code]...

I came to know that this is a netbackup configuration/client bug. Can we do something from the oracle side.

The RMAN COMMAND STRINGS we use is as follows:

SET SNAPSHOT CONTROLFILE NAME TO '/u101/app/oracle/product/10.2.0.5/db_1/dbs/iwhdbqa_snapshot_db.snap';
RUN {
ALLOCATE CHANNEL CH01 TYPE 'SBT_TAPE' parms='SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1' ;
SEND 'NB_ORA_SERV=atlbackupmaster, NB_ORA_POLICY=iwh-dbqa_oracle, NB_ORA_CLIENT=iwh-dbqa-bu';
ALLOCATE CHANNEL CH02 TYPE 'SBT_TAPE' parms='SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1' ;

[code]...

View 3 Replies View Related

Recovery Manager (RMAN) :: Active Cloning Fails With 06054 - Missing Log File?

May 15, 2013

Version Details:

O.S Version     HP-UX B.11.31 U ia64
Oracle DB Version     11.2.0.3.0
     Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
Scenario :

Using RMAN Active cloning to duplicate a RAC database from Production to Development environment.

Problem:

At the end of the cloning the below errors are reported;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

[code]...

How to prevent the error of RMAN-06054: media recovery requesting unknown archived log for thread  with sequence   and starting SCN of  while performing the RMAN Active Cloning? I do NOT want to use UNTIL clause.

View 5 Replies View Related

Reports & Discoverer :: Generate PDF File With Password Protection?

Aug 18, 2010

Is it possible to generate .pdf file with password protection.

View 2 Replies View Related

Precompilers, OCI & OCCI :: Compile ProC File - Failed Assertion

Aug 13, 2010

I am trying to compile a pro c file. Rest of the pro c file is compiling fine. But one particular file is showing following error.

INTERNAL ERROR: Failed Assertion [Code=40706]

View 11 Replies View Related

Database Failed To Start Up - ORA-03113 / End-of-file On Communication Channel

Jun 19, 2012

We had power failure, and i had to restore the database from offline backup.after restore i tried to start the database and i received following errors.

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 663961600 bytes
Fixed Size 2184056 bytes
Variable Size 394267784 bytes
Database Buffers 260046848 bytes
Redo Buffers 7462912 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

[code]....

I reviewed the /oracle/PRD/saptrace/diag/rdbms/prd/PRD/incident/incdir_583361/PRD_ora_7179_i583361.trc, it hugh file with alot of Jargon.

View 7 Replies View Related

Forms :: Oracle 11g Windows 64bit / File Extraction Password

Nov 27, 2012

I downloaded Oracle Fusion Middleware11g Forms and Reports (ofm_frmrpts_win_11.1.2.0.0_64_disk1_1of1). When I begin to extract I am getting bogged down with a password message and that is:

File Windows-amd64 is password protected. please enter the password in the box below.

BTW- I downloaded Windows64 based forms and reports on my windows xp pro machine. I am trying to unzip them and burn it on a DVD so that I can install them on my new dell windows 7 professional laptop.

View 7 Replies View Related

Server Utilities :: Not A Valid Export File Header Failed Verification

Nov 22, 2012

Sometimes during recovery I encountered the following message "

This error occurs when Backup And Restore Occur between different versions

View 4 Replies View Related

Server Utilities :: ORA-01187 / Cannot Read From File 203 Because It Failed Verification Tests

Apr 26, 2011

I want to export all db using data pump. I got this error when using it:

Export: Release 10.2.0.4.0 - Production on Thu Nov 25 11:46:48 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export the entire database ...

. exporting tablespace definitions
EXP-00068: tablespace TISDATA is offline
EXP-00008: ORACLE error 1187 encountered
ORA-01187: cannot read from file 203 because it failed verification tests
ORA-01110: data file 203: '/u03/app/oracle/product/10.2.0/oradata/unidev/TISTEMP01.dbf'
EXP-00000: Export terminated unsuccessful

View 2 Replies View Related

Export/Import/SQL Loader :: DMP File In Oracle XE - Failed To Process Parameters

Jul 18, 2012

I am getting the following error while trying to import dmp file in oracle xe:

D:>imp system/manager file=pune_ucf.dmp tables=(ARR_TOT, DE
P_TOT) grants=no indexes=no rows=yes ignore=yes log=loc.log buffer=100000000;
LRM-00104: '100000000;' is not a legal integer for 'buffer'

IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help
IMP-00000: Import terminated unsuccessfully.

View 2 Replies View Related

Pass Variables For UserID And Password To Sqlplus In Windows From Text File?

Jul 23, 2013

I would like to store user-id, password and the TNS-Entry in a small text file and pass them to a script to log in and execute another script on the database from Windows.

Example of the text file samp.txt that stores user info:

username=Jdoe
password=candybar
db_sid:orcl

main script main.bat is as follows:

--read the samp.txt do not know how to do it

sqlplus -s &username/&password@&db_sid @db_info.sql

db_info.sql contents:

column tm new_value file_time noprint
select to_char(sysdate, 'YYYYMMDD') tm from dual ;
spool C:\server\DB_Report_&file_time..log
select * from v$instance;
spool off;
exit

View 1 Replies View Related

Server Administration :: Can Restore Database Password File In ASM For 11gR2 Version

Mar 28, 2012

Can we restore database password file in ASM for 11gR2 version.

View 4 Replies View Related

Reports & Discoverer :: How To Create Password Protected Report File In Oracle 11g

Dec 21, 2011

I want to create pdf file of a report with password protection for security reason with. eg. Employee A is logged to run rep1. The pdf file created to his desk with his userid & password.

View 1 Replies View Related

Server Administration :: How To Avoid Clear Password In Checkpoint File With Oracle DBCA

Nov 15, 2011

I found there is clear password in the xml file in the process of Oracle instance creating. The process like below

1, when using the following process to create the instance

Login as user Oracle
/home/Oracle11home/bin/dbca -createDatabase -silent -templateName /home/Oracle11home/assistants/dbca/templates/Small.dbt -gdbName testDB -sid testSID -sysPassword [b]testpwd[/b] -systemPassword [b]testpwd[/b]

2. Found the file in $ORACLE_HOME/checkpoints/dbca/OraDb11g_home2_oracle_creation_checkpoint.xml , it listed the sys and system passwd (like testpwd for sys and system password) directly.

<CHECKPOINT LEVEL="MAJOR" NAME="db_oracle" DESC="db creation checkpoint" STATE="FAIL">
<PROPERTY_LIST>
<PROPERTY NAME="command" TYPE="STRING" VAL=" -silent -createDatabase -templateName Small.dbt -gdbName testDB -sid testpwd -sysPassword testpwd -systemPassword testpwd"/>
</PROPERTY_LIST>
</CHECKPOINT>

I hope to confirm :

1. what is the purpose for oracle to genate the checkpoint.

2, can we remove the file safely ?

3, if there is configuration that we can avoid to show clear password in checkpoint file?

View 1 Replies View Related

How To Know Password (Exact Password Not Hascode) Of All Users As A Sysdba

May 28, 2008

How to know the password(Exact password not hascode) of all users as a sysdba in Oracle 9i or 10g.How to convert hashcode password to Actual password.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved