Solved

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

Posted on 2013-06-06
10
870 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
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
 
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
Can’t get the mobile email signature right?

Not having any luck when trying to create an email signature for mobile devices? Does the formatting keep messing up? Make sure you have great email signatures on all devices by using Exclaimer Cloud - Signatures for Office 365.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
On some Windows 7 (SP1) computers, Windows Update becomes super slow even the computer is reasonably fast.  There's one solution that seemed to have worked well for me (after trying a few other suggested solutions).
This Micro Tutorial will give you basic overview of the control panel section on Windows 7. It will depth in Network and Internet, Hardware and Sound, etc. 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 capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now