Thursday, 18 November 2010

how to create a database directory on current SO directory

I needed to create a one-click import with datapump script on Windows operating system, and for this I needed to create a database directory mapped on the current directory where the dumps are.
So I wrote an sql file:
 create_directory.sql

CREATE OR REPLACE DIRECTORY DATAPUMP AS '&&1'
/
exit
/


And import_one_click.bat file looks like this:

sqlplus / as sysdba @create_directory.sql %CD%

impdp '/ as sysdba' directory=DATAPUMP  dumpfile=export_andrei.dmp logfile=import_andrei.log schemas='ANDREI'

Wednesday, 3 November 2010

how to fix a shared server issue?

This is more of a question for you guys.

In the alert log i have this:

Errors in file /oradb/app/oracle/admin/test/bdump/test_s003_123472.trc:
ORA-00600: internal error code, arguments: [ksudel1], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [unable to load XDB library], [], [], [], [], [], [], []
Wed Nov  3 15:35:36 2010
found dead shared server 'S000', pid = (10, 2)
found dead shared server 'S001', pid = (24, 3)
found dead shared server 'S002', pid = (28, 1)
found dead shared server 'S003', pid = (29, 1)

And of course lots of trace files with test_s****.trc

Actually the solution I adopted is to make all connection on this database DEDICATED. So I changed everywhere SERVER=DEDICATED. And since then I had no error coming.

Do you have any ideas?