Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Oracle database works properly but from designers tools I ..

  
   Database Help (Home) -> Oracle -> Server RSS
Next:  FileStream and sql 2008 edition  
Author Message
Jacek Maria Jackowski

External


Since: Dec 06, 2008
Posts: 2



(Msg. 1) Posted: Sat Dec 06, 2008 1:10 pm
Post subject: Oracle database works properly but from designers tools I can't
Archived from groups: comp>databases>oracle>server (more info?)
I've installed Oracle 10G on my computer. I can log in using system
account. by plsql. I've installed designer and tried to log from
designers plsql to the same databse also using sys account - I could
not't, I got ora-1017 error. What I'm doing wrong, why plsql from
database installation connects me and one from designer installation
disallow me from connecting ? I need databse just to run designer for
entity and processes diagrams. I need Barkers notation so I can only
use Oracle Designer because it's the only tool with Barkers notation.

Hope to get some help from You,
Jacek

 >> Stay informed about: Oracle database works properly but from designers tools I .. 
Back to top
Login to vote
Mladen Gogala

External


Since: Jan 12, 2008
Posts: 176



(Msg. 2) Posted: Sat Dec 06, 2008 8:26 pm
Post subject: Re: Oracle database works properly but from designers tools I can't [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Sat, 06 Dec 2008 13:10:05 -0800, Jacek Maria Jackowski wrote:

> I've installed Oracle 10G on my computer. I can log in using system
> account. by plsql. I've installed designer and tried to log from
> designers plsql to the same databse also using sys account - I could
> not't, I got ora-1017 error. What I'm doing wrong, why plsql from
> database installation connects me and one from designer installation
> disallow me from connecting ? I need databse just to run designer for
> entity and processes diagrams. I need Barkers notation so I can only use
> Oracle Designer because it's the only tool with Barkers notation.
>
> Hope to get some help from You,
> Jacek

[oracle@oracle16 ~]$ oerr ora 1017
01017, 00000, "invalid username/password; logon denied"
// *Cause:
// *Action:
[oracle@oracle16 ~]$

Have you tried using the right password?

--
http://mgogala.freehostia.com

 >> Stay informed about: Oracle database works properly but from designers tools I .. 
Back to top
Login to vote
Jacek Maria Jackowski

External


Since: Dec 06, 2008
Posts: 2



(Msg. 3) Posted: Sun Dec 07, 2008 3:20 am
Post subject: Re: Oracle database works properly but from designers tools I can't [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Back to top
Login to vote
Shakespeare

External


Since: Apr 01, 2008
Posts: 60



(Msg. 4) Posted: Sun Dec 07, 2008 3:25 pm
Post subject: Re: Oracle database works properly but from designers tools I can't [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Jacek Maria Jackowski schreef:
> Yes I was using hte right password

What do you exactly mean by Logging in from Designer with a sys account?
When you install Designer, you create a repository in a repository owner
schema. As the owner, you can grant other users to use the designer
repository. Use such a user to work with Designer. You may not be able
to use SYS though, for SYS can only connect as SYSDBA or SYSOPER, and I
don't think Designer offers those options.

Shakespeare
 >> Stay informed about: Oracle database works properly but from designers tools I .. 
Back to top
Login to vote
Shakespeare

External


Since: Apr 01, 2008
Posts: 60



(Msg. 5) Posted: Mon Dec 08, 2008 4:25 am
Post subject: Re: Oracle database works properly but from designers tools I can't [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Jacek Maria Jackowski schreef:
> I've installed Oracle 10G on my computer. I can log in using system
> account. by plsql. I've installed designer and tried to log from
> designers plsql to the same databse also using sys account - I could
> not't, I got ora-1017 error. What I'm doing wrong, why plsql from
> database installation connects me and one from designer installation
> disallow me from connecting ? I need databse just to run designer for
> entity and processes diagrams. I need Barkers notation so I can only
> use Oracle Designer because it's the only tool with Barkers notation.
>
> Hope to get some help from You,
> Jacek

There is a tool called SmartDraw, (see www.smartdraw.com) and it
supports Barker's as well. I'm not in any way involved in this company,
so it's no advice, just a remark.

Shakespeare
 >> Stay informed about: Oracle database works properly but from designers tools I .. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Articles on Oracle database, Oracle Exam Dumps (OCP)absolu.. - Dear Friends, Kindly dont ignore this mail. This is not a spam. Visit the link to get OCP dumps online absolutely free: http://neworacledba.blogspot.com/2008/04/oracle-exam-dumps-absolutely-free_5977.html See interesting articles on Oracle at: ..

Convert SAP Oracle Database to IBM DB2 Database?? - Hello, I would like to hear from anyone here who has converted their SAP Oracle database to IBM DB2 database? Did you realize greater disk saving via DB2 compression? Did you run the latest version of DB2 rather than allow SAP to keep your Oracle..

Oracle database 11g - Hi, I want to write oracle database 11g advanced pl/sql certification (1z1-146). Can anybody please tell me where will I get the materials? Or if anybody has the ILT, could you please give me? Dibyendu

Not able to connect to Oracle database through VPN - Port 1500 is open on firewall. Tnsnames entry tv92.tcrix= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.5.79)(PORT = 1500)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = tv92.tcrix) ...

Oracle error of "recover database until scn..." - Hi all, I get error message when using "recover database until scn ...." as below: ------------------------------------------------------------------------------ RMAN> list backup; List of Backup Sets =================== BS Key Type LV ...
   Database Help (Home) -> Oracle -> Server All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]