Solved

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

Posted on 2013-06-06
10
872 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
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
This article summaries thoughts and ideas from two years of sustained use. It provides good reasoning to make the jump to Windows 10.
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

733 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