Visit Amazan Store

Wednesday, May 18, 2016

Unsupported network datatype or representation

Check what version of the Oracle client are you using !!!
Any chance you're using an old version of the client that isn't aware of the TIMESTAMP data type !!!


Verify your database version  like as :


sql>select * from v$version;
 
 
 You wouldn't get an ORA-03115 if the version of the Oracle database didn't support timestamps.

 You would get an ORA-03115 if you were using an outdated version of the Oracle client when connecting to the 10.2 database. What version of the 
Oracle client are you using? 


Tuesday, May 17, 2016

How to prevent DB link creation

How to  prevent DB link creation


First remove all the roles and just grant only required privileged.

Sunday, May 15, 2016

grant select on all tables in a schema



GRANT  SELECT on all tables in a schema

Single statement to grant privileges

FOR  x  IN (SELECT * FROM user_tables)
LOOP
 EXECUTE IMMEDIATE  ‘GRANT SELECT ON  ‘ || x.table_name || ‘  TO  << someone >>’ ;
END LOOP;

OR

DECLARE
CURSOR  cur1 IS SELECT TABLE_NAME from user_tables;
cmd varchar2(200);
BEGIN
FOR c in c1 LOOP
cmd := ‘GRANT SELECT ON ‘||c.table_name||<< TO YOURUSERNAME>>’;
execute immediate cmd;
END LOOP;
END;

Oracle database parameter files

There are few defaults Database Parameter value created at time of database creation and above that we can change them according to our requirements.
Database parameters are environment variables for a database which can change database behavior according to value of the parameter.
These are input values which are taken at time of database startup and continue until changed.

Saturday, November 21, 2015

ORA-01033 Oracle initialization or shutdown in progress

ORA-01033-Oracle-initialization-or-shutdown-in-progress
ORA-01033 Oracle initialization or shutdown in progress

When you connect oracle 12c plug gable database, Thus time you have get oracle initialization or shutdown in progress error. This error occurred because pluggable database are not initialized.

To fix this error connect as sysdba and run  ALTER PLUGGABLE DATABASE ALL OPEN   command.

ALTER-PLUGGABLE-DATABASE-ALL-OPEN
ALTER PLUGGABLE DATABASE ALL OPEN



Thanks.

Monday, September 28, 2015

google html guide

HTML GUIDE PROVIDED BY GOOGLE

Omit the protocol from embedded resources

Omit the protocol portion (http:https:) from URLs pointing to images and other media files, style sheets, and scripts

/* Not recommended */
.example {
  background: url(http://www.google.com/images/example);
}

/* Recommended */
.example {
  background: url(//www.google.com/images/example);
}

Use only lowercase.


http://google-styleguide.googlecode.com/svn/trunk/htmlcssguide.xml

Thursday, September 24, 2015

runtime process has terminated abnormally

In runtime Oracle Forms crash when calling RUN_REPORT_OBJECT and nothing to show in showjobs.

Check this procedure to solve this problem


Friday, July 24, 2015

GOOGLE SEARCH TRICKS

search-tricks
Google Search Tricks
Today google searching is the learning objects. It's very important to know how to search in Google in efficient way. Here I explain some google search tricks and tips. I hope it will be help you.

IF YOU LIKE IT DO NOT FORGET TO SHARE IT WITH YOUR FRIENDS.  
HAPPY GOOGLE SEARCHING .....


Wednesday, July 22, 2015

application block click for details

Application Block Click For Details

Today I have face a problem when i run my oracle forms application. I get new java error first time. That is ...
Your security settings have blocked a self-signed application from runing

application block click for details
Application Block Click For Details











Friday, July 10, 2015

line breaks

Visually Separate Elements with Line Breaks

Add a br element to your page, preferable between two or your elements.

br elements, also known as  "line break" elements, can be created with
.

Note that
has no closing tag. It is a "self-closing" element.