Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick, Simple and Absolutely Free.

Thread Rating:
  • 24 Vote(s) - 3.04 Average
  • 1
  • 2
  • 3
  • 4
  • 5
ORA-01031 with R12.1.1 on OEL 5u4
#1
I've installed OEL using Metalink note 761564.1 (I've not done any of the steps in "After Installing or Upgrading"), and then installed R12.1.1 on top of that.
I've got only one useer (other than root) called oracle that I used to perform the install.

I've got the dreaded ORA-01031 when trying to connect to SQL*Plus as sysdba using:

conn / as sysdba

In addition, select * from v$pwfile_users returns no rows.
Reply
Thanks given by:
#2
(10-07-2010, 06:46 PM)admin Wrote: I've installed OEL using Metalink note 761564.1 (I've not done any of the steps in "After Installing or Upgrading"), and then installed R12.1.1 on top of that.
I've got only one useer (other than root) called oracle that I used to perform the install.

I've got the dreaded ORA-01031 when trying to connect to SQL*Plus as sysdba using:

conn / as sysdba

In addition, select * from v$pwfile_users returns no rows.

I think conn / as sysdba will not work from sql plus.
you will have to login using terminal (linux) or command prompt in windows in the terminal of the installed machine using the same OS user which was used for oracle installation.
Reply
Thanks given by:




Users browsing this thread: 1 Guest(s)
OTech Talks, Lets Talk OPEN! Get Oracle Tutorials, Tips! Post a Question!