RCU cannot connect to database with SYS user

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

About Mark Nelson

Mark Nelson is a Developer Evangelist at Oracle, focusing on microservices and messaging. Before this role, Mark was an Architect in the Enterprise Cloud-Native Java Team, the Verrazzano Enterprise Container Platform project, worked on Wercker, WebLogic and was a senior member of the A-Team since 2010, and worked in Sales Consulting at Oracle since 2006 and various roles at IBM since 1994.
This entry was posted in Uncategorized and tagged . Bookmark the permalink.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s