| Trying [message #58288] |
Tue, 12 August 2003 09:29  |
Nikki
Messages: 6
Registered: November 1999
|
Junior Member |
|
|
|
Trying to get log on to Oracle here at work to play around with. No one here seems to know the password. Does Oracle use something standard such as scott/tiger, or system/manager, and if so what is the host string?
|
|
|
|
| Re: Trying [message #58291 is a reply to message #58288] |
Tue, 12 August 2003 22:41  |
shesha
Messages: 24
Registered: August 2003
|
Junior Member |
|
|
You delete the password file...
Create a new one...
and connect as sys with sysdba priv...
|
|
|
|
|
|
| Re: Trying [message #58311 is a reply to message #58288] |
Wed, 13 August 2003 12:44 |
Satish Shrikhande
Messages: 167
Registered: October 2001
|
Senior Member |
|
|
Do you know the name or IP address of the database server ?
Do you know the name of the database you have created ?
Add this entry in your tnsnames.ora file .
DBSERVER - Database Server Name
DBNAME - Database Name (it may be ORCL)
NIKKI.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DBSERVER)(PORT = 1521))
(CONNECT_DATA = (SID = DBNAME))
)
User id - system
Password - manager
Host String - Nikki.world
Good Luck !
|
|
|
|
| Re: Trying [message #58319 is a reply to message #58306] |
Wed, 13 August 2003 22:48 |
shesha
Messages: 24
Registered: August 2003
|
Junior Member |
|
|
Password file will be in Oracle_home/dbs directory.
The format of the file will be orapw<SID>.
Just delete this file and recreate the file using ORAPWD utility.
orapwd file=$ORACLE_HOME/dbs/orapw<SID> password=<Password for sys>
Note:There are no spaces around the equal-to (=) character.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
