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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bkreynolds48Author Commented:
thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.