Solved

Oracle 11g - Set SYS & SYSTEM password after initial install

Posted on 2013-06-06
10
873 Views
Last Modified: 2013-06-13
I'm a MSSQL guy trying to learn Oracle.  So, I am installing Oracle 11g using the universal installer and it installs without issue.  My issue is I never set a password for SYSTEM or SYS and don't know what they are.

When I install MSSQL, I can log into the instance with the local user account I installed it with HOST\INSTANCE and it uses windows authentication, then I can go in and create users and setup passwords and roles and such.

Can someone help me understand, after an installation of Oracle what I do to get to the same point?  During installation there is no prompt for default password for SYSTEM or SYS.  How do I go and set them after an install?  What are the prerequisites prior to this if any?

Thanks in advance
0
Comment
Question by:andrej770
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
10 Comments
 
LVL 10

Expert Comment

by:Sam Simon Nasser
ID: 39228150
as simple as:
SQL> connect / as sysdba
 
SQL> alter user <username> identified by <password>;

Open in new window

0
 
LVL 19

Expert Comment

by:Thommy
ID: 39228162
If your OS user is a member of DBA group, you can login as SYS using operating system authentication: sqlplus / as sysdba

Default passwords of Oracle 11g
0
 

Author Comment

by:andrej770
ID: 39228805
How to d

When I run sqlplus by itself in an Administrator elevated Windows command prompt, I get:

C:\Users\Administrator>sqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 7 08:44:54 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter user-name:

----------------------------------
When I run sqlplus / as sysdba  in an Administrator elevated Windows command prompt, I get:


C:\Users\Administrator>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 7 08:48:11 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:
----------------------------------

I know in SQL I have to setup the ports and named pipes and such so that the instance is listening on certain ports.  Is setting up the TNS:protocol a prerequisite?  If so, provide the prerequisite steps.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 37

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 100 total points
ID: 39228855
looks like you installed the software only
> this is the first step for oracle, and doesn't require sys or system password

the next step is to create a database
> this requires a sys/system password

after you installed the software (you probably gave the location .(c:\program files\oracle\etc)
look in the bin folder and start dbca
> this tool will let you create a database
0
 

Author Comment

by:andrej770
ID: 39228968
Wait...

So in Oracle, you have to have a database BEFORE you have a admin user for the Oracle instance?  Or am I missing something?
0
 
LVL 23

Assisted Solution

by:David
David earned 50 total points
ID: 39229966
Yes.  During the database creation a few overhead user accounts (SYS, SYSTEM, et.al.) are created by default.  When the database is later mounted and opened, you then have an instance.

And, since you don't remember what you entered when prompted, try:

SYS: change_on_install
SYSTEM: manager

Lastly, you initially asked about how to create users.  To supplement the answers above, here's a good source that gives a better explaination: http://stackoverflow.com/questions/9447492/how-to-create-a-user-in-oracle-11g-and-grant-permissions
0
 

Author Comment

by:andrej770
ID: 39230058
@dvz - Thanks for your response, but the reason I come here, and award points, is for the answer not for a suggestion on how to search for the answer.  What's the point in awarding the points then?? :-)

So, I'll ask again, after the initial install of oracle, what are the prerequisite steps to being able to set the password for SYS and SYSTEM.  My current windows administrator user is in the ora_dba user group but the "as sysdba" still brings up the error:

ERROR:
ORA-12560: TNS:protocol adapter error

Trying to figure this out on my own, I read the documentation on how to create the LISTENER using the Net Configuration Assistant.  A listener service was successfully created in the "services" of windows and started successfully on the default port 1521.  When I do a netstat -a I see that a service is running and listening on port 1521.

Still get :

ERROR:
ORA-12560: TNS:protocol adapter error

Thanks.
0
 

Accepted Solution

by:
andrej770 earned 0 total points
ID: 39230708
Instead of installing Oracle as "Software Only"  I installed it with and created a dummy database at the same time.  Installing it this way setup all the users automatically AND allowed me to set a password.

Thanks to all those that offered other solutions.
0
 

Author Closing Comment

by:andrej770
ID: 39240449
Though there were observations that I possibly could have been installing the software only, there was no suggestion not to to get to the solution.
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 39246771
installing the oracle database software is the first step
after this you have:
  > $(oracle home) > a path to the location of the installed software
  > the binaries in $(oracle home)\bin for setting up databases, listeners, etc

the setup tool can do both items sequentially,
first installing the software and then setting up the database

a comparison:
consider windows itself like the oracle database software
notepad.exe could then be your database

notepad.exe uses windows for all the administration, like writing data to disk, retrieving data from disk, displaying objects on screen etc ...

oracle database (ot the instance) uses the oracle software for the administration of writing data to disk, retrieving data from disk, supplying the output to the oracle client, etc

you typically need:
backend:
> oracle software in an oracle home
>> oracle database running from that oracle home
>> a listener to provide connection to that database

frontend
> an application: example: excel
> an oracle client: odbc connection

the link between the two: the connection string
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
When asking a question in a forum or creating documentation, screenshots are vital tools that can convey a lot more information and save you and your reader a lot of time
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question