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'
Thursday, 18 November 2010
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?
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?
Subscribe to:
Comments (Atom)