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 an Architect in the Enterprise Cloud-Native Java Team at Oracle. Mark works mainly on making Java (traditional and microservices) easy to use in Kubernetes and the CNCF ecosystem. Before joining this team, Mark 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 )

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s