Today I found an interesting little issue when trying to use RCU to create schemas for a middleware installation. RCU could not connect to the database with the SYS user. I could connect with other users, like SYSTEM for example, and I had the password correct.
Turns out the database in question did not have an Oracle password file. You can check this by using the following query, which should return a row for SYS:
SQL> select * FROM v$pwfile_users;
no rows selected
As it did not, the solution was the create the password file, as follows:
[oracle@ebs ~]$ orapwd file=/oracle/VIS/db/tech_st/11.1.0/dbs/orapwVIS
Like this:
Like Loading...
About Mark Nelson
Mark Nelson is a Consulting Solution Architect in the Fusion Middleware Architects Team (known as ”The A-Team”) in Oracle Development. Their mission is to supply deep technical expertise to support customers deploying Oracle Fusion Middleware, and to collect real world feedback to continuously improve the product set. Mark spends most of his time working on development lifecycle, SOA and BPM. Before joining Oracle Development in 2010, Mark worked in Sales Consulting at Oracle since 2006 and various roles at IBM since 1994, including several in Software Group and System/390 Group across Asia Pacific.
