sqlplus / as sysdba ora1017 trying to create a database

oracle 11g
aix 7
created init.ora and orapw file
trying to create a new database
sent ORACLE_HOME - PATH, etc
sqlplus / as sysdba
get ora 1017

any ideas?  I thought as long as the init file had the remote_login_passwordfile=EXCLUSIVE
and that I created the password file
orapwd file=$ORACLE_HOME/dbs/orapwtest password=password force=y

why do I get the ora1017

then
Enter user-name: sys / as sysdba
Enter password:

I enter the password and I am in


so confused
LVL 1
bkreynolds48Asked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
>>have not as  yet found the april 2018 psu patch

I found this for AIX 11gR2.  It was put out 8 days ago at the same time of the PSU:
Patch 27338049: DATABASE PATCH SET UPDATE 11.2.0.4.180417

I would open an SR with Support asking them if there is an April PSU for AIX.
0
 
slightwv (䄆 Netminder) Commented:
The remote_login_passwordfile just tells oracle to check the password file or not.  It doesn't  say you can use '/' or OS authentication or not.

Check out the following on Oracle Support:
Is It Possible To Prevent an OS Authenticated Oracle User To Connect via the command "SQLPLUS / AS SYSDBA" ? (Doc ID 988262.1)

If is controlled by your sqlnet.ora file.
0
 
bkreynolds48Author Commented:
thanks - thought that was it but wasn't sure
someone had created a weird sqlnet.ora - put the old one back in and things work fine now
0
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
slightwv (䄆 Netminder) Commented:
>>someone had created a weird sqlnet.ora

Normally this is done for a good reason.  Many times it is because of policies in place.  I wouldn't just go changing things.

>> things work fine now

They worked "fine" before.  It just didn't allow OS authentication.  That isn't wrong.  It is just different.
0
 
bkreynolds48Author Commented:
I am on our test (sandbox) system and everyone does their own thing there  - no database are currently installed on this system
I am trying to find the april 2018 psu patch for aix 64 to download and test the patch application so needed a database to do that with
have not as  yet found the april 2018 psu patch
0
 
bkreynolds48Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.