OCP Blog
Super DBA
ORA-27029: skgfrtrv: sbtrestore returned error
by Vazha Mantua Wednesday, November 16, 2011 1:43 PM

Good Day All,

Today We observe a main error, which appear when you are trying restore database to new location via Veritas Netbackup soft

Problem:

When you tried restore for example your controlfile from autobackup which is stored on types, you got a error

ORA-27029: skgfrtrv: sbtrestore returned error

 

 

Cause:

With NetBackup on UNIX one can restore a database to a client other than the one that originally performed the backup. Symantec refers to this process as an 'alternate client restore' while Informix refers to this same process as an 'imported restore.By default configuration there is some restrictions for restoring to new server.

Workaround:

1.Remove restrictions for alternate client restores for all clients

Create the following f file /usr/openv/netbackup/db/altnames/No.Restrictions on the master server

2.Restrict the restore to / from certain clients

Create the following file on the NetBackup master server: /usr/openv/netbackup/db/altnames/<target_client_name>
where "<target_client_name>" is the name of the client that will receive the restore. This will allow this client to restore images from any other client.

 

 

Tags: ,

ORA-600 [qertbfetchbyrowid]
by Vazha Mantua Saturday, October 15, 2011 10:43 PM

Good Evening All,

 

We have updated on of our database from 10.2.0.2 to 10.2.0.4, after upgrading in 2 days in alert log we got internal error ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], [] .

 

Cause of this error is index corruption

How can we resolve this problem?

Solution

1. Find appropriate trace file in udump for discover which SQL Statement is cause of problem.

2.In SQL statement find table which is cause of problem

3. with SQL plan of statement you can find appropriate index which is corrupted

4.Recreate index(not rebuild)!

 

After these 4 steps you problem will be resolved!

 

Good luck

Tags: ,

Problem During Installation Patch Set 10.2.0.4, PL/SQL: ORA-00904: "OTHER_XML": invalid identifier
by Vazha Mantua Sunday, September 18, 2011 2:49 PM

Good Day All,

 

 

 

After applying Patch Set 10.2.0.4 on Oracle RDBMS we discover that one of component was not updated correctly.Please see below:

 

Component Status Version HH:MM:SS
Oracle Database Server INVALID 10.2.0.4.0 00:19:27
Oracle XDK VALID 10.2.0.4.0 00:00:00
Oracle Workspace Manager VALID 10.2.0.4.3 00:01:22
Oracle Expression Filter VALID 10.2.0.4.0 00:00:16

 

In Installation Log file we found error PL/SQL: ORA-00904: "OTHER_XML": invalid identifier, while compiling package dbms_sqlpa.

In this post we will provide us how can you fix this problem.It’s very simple:

SQL>sqlplus / as sysdba
SQL>drop table plan_table;
SQL>@?/rdbms/admin/utlxplan
SQL>@?/rdbms/admin/prvtspao.plb
SQL>@?/rdbms/admin/utlrp.sql

Tags: ,

Installation Guide For Oracle TimesTen 11.2.1 In-Memory Database
by Vazha Mantua Thursday, August 25, 2011 5:38 PM

Good day all,

Today we will announced about a very nice type of database provided by Oracle. it’s Oracle TimesTen in memory database.

While installing a new technology, you can watch small presentation about this product, which I found on YouTube:

 

As you watched :

TimesTen is an in-memory relational database software product from Oracle. TimesTen is a high performance event-processing software component that enables applications to capture, store, use, and distribute information in real-time,
while preserving transactional integrity and continuous availability.

Full Articles about this product you can find on link: http://www.oracle.com/technetwork/database/timesten/overview/index.html

 

On This article we will provide you step by step procedure how install Oracle TimesTen 11.2.1 in Memory Database on Windows Platform 32 bit. Future We are going to publish some articles which deeply describe this product.

 

Let’s Start

 

Step 1: Install Software

First of all you should download installation package from Oracle:

You can download soft form link: http://www.oracle.com/technetwork/database/timesten/downloads/index.html

Run Setup.exe file , You can see in pictures steps , which you should done for installing software.

12

34

56

78

910

1112

13

After Installation software we should connect to DB

Step 2 Configure DSN

A Timesten Database is simply created by connecting to it, A first connection to an already-existing database results in loading the database in memory.Only A instance administrator can create TimesTen Database.

First of all We should configure system DSN for connecting to DB.

1. Go to control panel , then administrative Tools and Data Sources(ODBC)

2. Switch menu on System DSN part

3. Add System Data Source, named is my_ttdb

4. In Data Store Path browse directory in which you will store data

5. In Transaction Log Directory choose directory, where you will store log data.

6. Choose character set of DB, if you planning pin Oracle TimesTen Database on Oracle Database in future , choose character set, which you have an Oracle Database

7. In section First Connection you can set First connection attributes.

 

Step3 Connecting And Creating TimesTen Database

 

1. Enter ttisql at the OS Command prompt to launch ttIsql

2. For connecting to DB run connect “dns=my_ttdb”;

3. When the connect command returns , the database my_ttdb has been created and loaded into memory.

 

Now you can create users and object within database my_ttdb

 

Very useful instrument for TimesTen Database in SQL Developer. it’s very simple to use SQL Developer for TimesTen Database.

 

Status of Service you can get by command ttStatus from OS command prompt .

 

 

 

Tags: , , , , , ,

Oracle Announces Openworld 2011
by Vazha Mantua Wednesday, August 24, 2011 10:39 AM

Oracle OpenWorld is an annual Oracle event for business decision-makers, IT management. It is held in San Francisco, California; São Paulo, Brazil,Shanghai and China. The world's largest conference for Oracle customers and technologists.

 

Openworld in 2010:

About 41,000 people will attend this year’s expo, up from 37,000 in 2009, said Tania Weidick, vice president of event marketing for Redwood City, California-based Oracle. Those guests will spend more than $100 million on hotel rooms, restaurants and shopping, the company said.

 

Oracle welcomes proposals for presentations on a wide variety of topics, with content targeted at all levels of attendees from beginner to expert. Attendees come from around the world representing thousands of Oracle customers and partners. At this time Oracle is also accepting proposals for Oracle Develop content.

Oracle Openworld 2011 starts on 2 of October and ends 6 of October in Moscone Center 747 Howard Street, San Francisco , CA, USA

Detail Information about this event you can find on link : http://www.oracle.com/openworld/index.html

Tags: , ,

DBMS_PROFILER - Identify performance bottleneck
by Vazha Mantua Monday, August 22, 2011 3:13 PM

The dbms_profiler  package provides an interface to profile existing PL/SQL applications and identify performance bottlenecks. You can then collect and persistently store the PL/SQL profiler data.

The basic idea behind profiling with dbms_profiler is for the developer to understand where their code is spending the most time, so they can detect and optimize it.

Let see a example:

In Scott schema you have a procedure named create_client_information. Your goal is find which lines of source code of procedure is potential bottleneck .

Once you have run the profiler, Oracle will place the results inside the dbms_profiler tables.

First of all you should build appropriate tables and procedures for using dbms_profiler.

Step By Step:

 

1. Create necessary metadata for using dbms_profiler

   connect  as sysdba
run scripts @$ORACLE_HOME/rdbms/admin/profload.sql

    connect  as Scott 
run scripts @$ORACLE_HOME/rdbms/admin/proftab.sql

 

2. Delete unused data and start profiler for collecting information

delete from plsql_profiler_data;
delete from plsql_profiler_units;
delete from plsql_profiler_runs;
commit;

declare
  success binary_integer;
begin
  success := dbms_profiler.start_profiler(run_comment => 'test_run');

  if success <> 0 then
    dbms_output.put_line('could not start profiler');
  else
    dbms_output.put_line('Profiler started!');
  end if;
end;

3. Run procedure which you are testing now, for our example

begin  create_client_information(); end;

4. Stopping profiler

 select decode(
  dbms_profiler.stop_profiler,
  '0', 'Profiler Stopped',
  'Could not stop profiler')
from
  dual;

5. Get A results

 

First of all you should find which runid  is your case, you can get this information from statement:

select runid from plsql_profiler_runs
 
then you can get information with select

SELECT *
FROM PLSQL_PROFILER_DATA A,
     PLSQL_PROFILER_UNITS B
WHERE A.UNIT_NUMBER = B.UNIT_NUMBER
   AND A.RUNID = &ID

 

 With dbms_profiler you can find in which line of procedure you have a performance problem, but only find, it will not help you optimize code itself.

Tags: ,

ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []
by Vazha Mantua Thursday, August 18, 2011 5:26 PM
In a test DB we applied patch from 10.2.0.2 to 10.2.0.4 , after this procedure we could ’t compile a user specified view with error :ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []
On metalink there are a lot of articles and scenarios with this error, but I will focus on only one,which help us.
Problem
--------
SQL statement with aggregations and unions fail with
ORA-600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], [] during parse.


--------------------
Solution:
disable query_rewrite make it works fine.
alter session set "_complex_view_merging"=false;
Init parameter “_complex_view_merging”- Controls complex view merging.

Tags: ,

Now ocp.community.ge is on Facebook
by Vazha Mantua Wednesday, August 17, 2011 6:03 PM

My friends, know you can find us on Facebook, on page ocp.community.ge. Please like this page Smile

From this moment you can be noticed about new articles form Facebook page

 

 

Vazha Mantua

Tags: ,

How Prevent user with alter user privileges from changing password of sys and system users.
by Vazha Mantua Wednesday, August 17, 2011 10:26 AM

Good Day My friends,

 

Today we will discuss about one small security issue for users which have an alter user privileges. Our Task is avoid from these users privileges changing password of system users.

In metalink we found article about this issue. Note id is 271077.1 , which tell us create system trigger for avoiding this case.

 

SQL> conn  / as sysdba
Connected.

SQL> CREATE or REPLACE TRIGGER prohibit_alter_SYSTEM_SYS_pass
AFTER ALTER on SCOTT.schema
BEGIN
IF ora_sysevent='ALTER' and ora_dict_obj_type = 'USER' and
(ora_dict_obj_name = 'SYSTEM' or ora_dict_obj_name = 'SYS')
THEN
RAISE_APPLICATION_ERROR(-20003,
'You are not allowed to alter SYSTEM/SYS user.');
END IF;
END;
/

Trigger created.

 

Now we can see a result:

SQL> conn scott/tiger
Connected.
SQL>alter user system identified by manager;
alter user system identified by manager
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-20003: You are not allowed to alter SYSTEM/SYS user.
ORA-06512: at line 5
SQL> alter user sys identified by manager;
alter user sys identified by manager
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-20003: You are not allowed to alter SYSTEM/SYS user.
ORA-06512: at line 5
SQL> alter user dbsnmp identified by dbsnmp;
User altered.

 

 

But There are one mistake , which found my student Mariam Kupatadze.

 

Password of user system changed. trigger works after alter user user, correct version is before alter for prevent changing password!

 

Finally we give you correct version of trigger:

SQL> CREATE or REPLACE TRIGGER prohibit_alter_SYSTEM_SYS_pass 
BEFORE ALTER on SCOTT.schema
BEGIN
IF ora_sysevent='ALTER' and ora_dict_obj_type = 'USER' and
(ora_dict_obj_name = 'SYSTEM' or ora_dict_obj_name = 'SYS')
THEN
RAISE_APPLICATION_ERROR(-20003,
'You are not allowed to alter SYSTEM/SYS user.');
END IF;
END;
/

Trigger created.

 

 

 

Tags: , , , , , , , , ,

Jinitiator for windows 7
by Vazha Mantua Friday, July 29, 2011 4:19 PM

 

Good Day all,

 

Today we will discuss about problem which occurred when you migrated to new windows platform 7 or update IE version.

Oracle tell us that For new versions of IE , jinitiator is not supported , you should use Java instead of Jinitiator ! For oracle forms please use Java.

I Agree with it, because product Jinitiator is out of date!

 

But if you are not going to change method of using this product we found workaround which fix this issue.

 

 

Replace the jvm.dll in jinitiator directory (C:\Program Files\Oracle\JInitiator 1.3.1.22\bin\hotspot\) with this file http://files.getdropbox.com/u/3353/jvm.dll

In our case we use Jinitiator 1.3.1.22

It will help you.

Tags:

Filter by APML

Calendar

<<  October 2017  >>
MoTuWeThFrSaSu
2526272829301
2345678
9101112131415
16171819202122
23242526272829
303112345

View posts in large calendar

TextBox