My Diary In Learning ORACLE and Others

ORA-00001

2008-04-24T18:43:00.000-07:00

ORA-00001 is means unique constraint (string.string) violated
Caused An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.
To try an Action Either remove the unique restriction or do not insert the key.

ORA-00000

2008-04-24T18:36:00.000-07:00

ORA-00000 is means successful completion its normal that caused normal exit no action to try

ORA-00056

2008-04-24T18:00:00.000-07:00

ORA-00056 is means DDL lock on object 'string.string' is already held in an incompatible mode,
that errors caused An attempt was made to acquire a DDL lock that is already locked.
You can try this action This happens if you attempt to drop a table that has parse locks on it.

FRM-41213 : Unable to connect to the Report server repsrv.

2008-02-29T08:32:00.000-08:00

Question :
Saya mencoba untuk memanggil report dari form (oracle develope 10g). Namun muncul error FRM-41213 : Unable to connect to the Report server repsrv.

Di FORM-nya saya sudah setting di property Report Server dengan mengisikan REPSRV.

OracleAS Report Service juga sudah saya start dengan E:\Devsuithome_ 1\bin> RWSERVER server=REPSRV start

Trigger WHEN-BUTTON- PRESSED :
DECLARE
report_id Report_Object;
ReportServerJob VARCHAR2(100) ;
BEGIN
report_id:= find_report_ object('MyReport 1');
ReportServerJob: =run_report_ object(report_ id);
END;

Answer :
saya pernah alami hal serupa, akhirnya saya panggil dengan syntax spt ini (syarat client harus terinstall acrobat reader) :

declare
vstate varchar2(200) :='/reports/ rwservlet? server=reportserver &report=d: \share\dev10g\ scanami\pengirim an.rdf&desformat =pdf&destype= cache&userid= user/password@ sid&paramform= yes';
BEGIN
WEB.SHOW_DOCUMENT( vstate,'_ blank');
END;

Bila desformat diisi dng htmlcss, biasanya format report jadi berantakan.. .
File report harus rdf bukan rep.

Error message ORA-12151

2008-02-21T01:09:00.001-08:00

Question :
On Feb 19, 2008 9:13 PM, Sujan Panday via oracle-db-l <oracle-db-l@groups.ittoolbox.com> wrote:
I am trying to login sys/manager @sysadmin, got this error message.
ORA-12151: TNS: could not resolve service name
Actully, I forgot my sys or system password.
Now I only login with Scott/tiger@oracle.
I am using Oracle 9i
Walk me through the process? __.

Answers :

Posted by blf2vkr
on 02/19/2008 10:16:00 PM
Try this:
SQL> sys/manager@ as sysdba or
SQL> sys/manager@ as sysoper and I think it will work.
I am not sure what you mean by @sysadmin in the sql statement. Is sysadmin a
sid name or what?
Well, I tried what I am providing you and it works.
Good Luck.
blf2vkr

Posted by naveen_bisht
on 02/19/2008 10:47:00 PM
hi
this is naveen
try this
SQL> conn /as sysdba
this will connect u by defaule as sys user.bcoz when u login with sysdba
role u will connected with sys user.
after connected check the user name .query
SQL> show user
this query show u the user name with whom ur connected currently.
i observe ur statement and i think ur trying to login remotely to another
database.if i m right.so be sure there tns
entry should be added in both tnsnames.ora file.
if this work plz confirm me.
naveen2_bisht@yahoo.co.in
or
naveen2bisht@gmail.com