| Oracle installation dba user and pwd [message #275591] |
Sun, 21 October 2007 23:43  |
alexaoracle
Messages: 36
Registered: October 2007
|
Member |
|
|
Hi, I just installed Oracle 10g on Windows Vista,
since it is my first time I choose the "automatic" installation.
At some point the oui ask me for a password for the database orcl and I entered it. It was a successful installation unlike a little slow. The problem, which I believe is a big one, is that when I start isqlplus dont know how to log myself in. I entered the password but I need the connection string (try orcl, but no) Yes you can laugh, I am so lost..
where and how can I create my user name and password? The dba user.
Help greatly appreciated
|
|
|
|
|
|
| Re: Oracle installation dba user and pwd [message #275602 is a reply to message #275598] |
Mon, 22 October 2007 00:56  |
alexaoracle
Messages: 36
Registered: October 2007
|
Member |
|
|
hi, I just opened the file you mentioned this is what I have:
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ***.***.**.***)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
I got one question now, when I open Oracle Enterprise Manager it opens (via web) in a different port lets say 1150, should not be 1521 like in tnsnames.ora?
|
|
|
|
|
|
| Re: Oracle installation dba user and pwd [message #275721 is a reply to message #275628] |
Mon, 22 October 2007 09:01 |
alexaoracle
Messages: 36
Registered: October 2007
|
Member |
|
|
Well, I have to thank you, I thought that I should have to uninstall and install all over again, I use the sys and my password and log in sqlplus, but this does not work via web isqlplus, is asking me for a connection string. What do I enter here?
Anyway searching the net, I used the sys and manager combination.
Thanks a lot.
|
|
|
|
|
|
| Re: Oracle installation dba user and pwd [message #275792 is a reply to message #275784] |
Mon, 22 October 2007 13:05 |
alexaoracle
Messages: 36
Registered: October 2007
|
Member |
|
|
yes you are right, is system and manager. forgot a tem.
Ok, now I remember the oui asked me for a password, the pwd was for the orcl db, and also later on there was this button with "Password Management" but again since is my first time, well I click on it, and like I didn´t know what exactly to do, I just leave it like it was, hoping after installation process I would learn how to configure oracle db, and possible get again to this part.
And like it should be, I don´t know if this is the reason why
and system/manager works and only in sqlplus.
please, what do I write in Connection Identifier? so I can use the isqlplus
|
|
|
|
|
|
| Re: Oracle installation dba user and pwd [message #277401 is a reply to message #275801] |
Mon, 29 October 2007 23:30 |
alexaoracle
Messages: 36
Registered: October 2007
|
Member |
|
|
On the installation process I changed the password of the database in my case orcl, and the right combination was system and this new password.
ok. I have to apologize, too much hours working and a lot of coffee... too bad for your health.
I do this for the ones who is going to read this later, dont want to leave wrong stuff..
Again forgive my distraction.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
