Latest topics for the forum "Tuning and Migration Wizard"

initdb.exe cannot locate component

damien519 — GMT

this is the error im getting when i try to install postgreSQL.

The component it cannot locate is "WSOCK32.dll"

i've downloaded this component but am not sure wat to do with it now.

any suggestions as ive tried numerous times to install postgresql with NO SUCCESS. and the same error everytime.

please help me

tuning wizard on windows x64

antoine.guidi — GMT

Enterprisedb tuning wizard don't work with PostgreSQL 9.1 x64 or I'm missing something?

I cannot CONNECT TO MY SERVER

patricio.ramos.cl — GMT

For the last 5 hours, I've been trying to figure out what's going on with my PostgreSQL server. I've reinstalled it but no luck. It constantly gives me this error...
I'm using postgreSQL 9.0

An error has occurred:
Error connecting to the server: server closed the connection unexpectedly
This probably means the server terminated abnormally before or while processing the request.

Inside the logfile, I have this error
2011-11-19 23:53:09 PST LOG: could not receive data from client: Unknown winsock error 10038

The database was working fine this morning and all of a sudden, the connection just died.

Someone please help me.

excessive disk storage issued by an alter table add column statement

patricio.ramos.cl — GMT

executed a simple statement: Alter table employees add column uuid uuid not null default uuid_generate_v4(); on a partitioned table, The problem is that this table employees contains 7 billion+ rows of data.
We executed this statement and it executed for about 50 hours and then the disk drive filled up and the process terminated and rolled back. We got the database back up and we are running VACUUM FULL in an attempt to recovery disk space, but the vacuum will likely run 3-5 days based upon our evaluation of how far the vacuum got since it was started yesterday morning, and so far we haven't seen any meaningful/measureable storage recovered.

Question#1 Does Postgresql require double the disk space based upon its current size for this command to finish successfully?

Question#2 If we break up the process into two steps. i.e. 1.) alter table employees add column uuid uuid; 2.) alter table employees alter column uuid default uuid_generate_v4(); will this minimize disk storage for this table?

Question#3 If vacuum don't reclaim space, is there any other alternatives other than doing a restore to get back to our original footprint.

Question#4 Do you have products that can monitor the alter statement and track where it is in the process. i.e. what partition is currently being populated with the default value, etc.

Thanks

Oracle pipeline function

roko55 — GMT

We are now using Oracle but want to migrate to Postgres. One of the issues during migration is that we use the oracle pipeline function in a lot of our PL/SQL procedures and functions. Is there a way to automatically migrate these functions using the migration wizard?

PhpBB3 Forum, MySQL to PostgreSQL

blodgfx — GMT

I try to convert my forum phpbb3, it uses mysql.

I use [b]EnterpriseDB MySQL Migration Wizard[/b].

The conversion finished successfully but phpbb3 have this error message:

[code]General Error

SQL ERROR [ postgres ]

ERROR: operator does not exist: boolean = integer LINE 3: WHERE is_dynamic = 1 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. []

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.[/code]

Do you have explanations or a solution has my problem please ? :(

Error: There are no EnterpriseDB Clusters configured, Cant't lauch dialog

subversion — GMT

I tried to migrate from Oracle to postgresplus-9.0.2-1 Standard with edb_migrationstudio-9.0.72-1-windows.exe. When i choose "Online Migration" on oracle schemas, it appears this error. Both DBs are connected.

Is it possible to migrate from oracle db to PG Plus Standard using edb migration studio? Console [url=http://www.enterprisedb.com/docs/en/8.4/mtkguide/Postgres_Plus_Standard_Server_Migration_Toolkit_Guide-16.htm]variant[/url] of the programm seems to work.

converting varbinary?

kuoirad — GMT

Greetings,

I'm trying to use the Migration Wizard to test a MySQL->PostgreSQL migration I'm looking for an RT instance.

The migration almost runs flawlessly. I have one error with the migration of two tables - the same with both. Each of them has a column of type varbinary, and the Wizard does not appear to know what to do with that. It seems the correct answer is to make a column of type bytea, per http://archives.postgresql.org/pgsql-novice/2010-12/msg00045.php.

Is there a chance the Wizard could be updated to handle this?

connecting to mysql over socket?

kuoirad — GMT

Greetings,

I'm trying to use the Migration Wizard to test a MySQL->PostgreSQL migration I'm looking for an RT instance.

I'm wondering if it's possible to tell the Wizard to connect to my MySQL server via socket instead of localhost:3306, as I don't have networking turned on for the MySQL server.

How I have to do to migrate Postgresql 8.2 to 9.0?

arcanosam — GMT

Hi all...

I'm here to collect more info about this migration I must do.

I have a database on [b]Postgresql 8.2 on FreeBSD ([/b]old server).

I will have to migrate to a [b]Postgresql 9.0 on a CentOS 5.6[/b] (new server)

Until now I'm planning to do this:

On the old server [b]using PgAdmin[/b]:

1) dump PostgreSQL database using Backup option in context menu;

2) dump CorporativeDatabase;

3) dump Template01;

4) dump Template02;

5) copy log files;

6) copy pg_hba.conf and postgresql.conf;

[i]With all that files change to the [b]new server[/b]:[/i]

1) Install Postgresql 9 by [u]compiling[/u];

2) initdb with [u]locale parameter[/u] - the old server is in Latin1. I will have to maintain this compatibility with the legacy software;

3) replace pg_hba.conf and postgresql.conf;

[b]on terminal using postgres user logon[/b]

4) Restore postgres dump backup;

[b] Using PgAdmin [/b]

5) restore Template01;

6) restore Template02;

7) restore CorporativeDatabase;

8) Lots of prey...

So... I will thankful if have more tips of how proceed with this,
like sugestions of what command I will do on the step 4 (restore postgres dump backup)
Or how could logs can help me on this entire proceding...
Something that I'm missing...

thank you guys in advanced.

see ya more times now :D

problem installing enterprisedb mysql migration wizard on ubuntu

Stamate_Stefan — GMT

hello,

i'm trying to install mysql migration wizard on ubuntu 10.04 and i get this error:

There has been an error. Sun java 1.5 or later is not installed on your system. Please ensure it is installed and in the system PATH before re-running the installer.

i have installed sun java 1.6 and i get the same error.

Can anybody help me?

i think my hair is getting whiter with any try of installing :D

unexpected error when try to tune standart server

mikhail_khodonov — GMT

Hello guys,
I installed standart server 9.03 on CentOS 5.5 and try to tune it. When I choose mode in in enterpriseDB wizard and press 'next' I have got 'initializing web service' and finally 'unexpected error'. What's wrong? Any ideas?

P.S.
I am looking for the same problem on forum but have got nothing

Migration Wizard auto_increment no Serial?

xjrmame — GMT

Hello,
I migrate my MySQL DB to PG with the Migration wizard.
Some Columns are auto_increment. The wizard has converted them to integer.
Now I have errors like
Not null violation: 7 ERROR: NULL-Wert in Column »LoginID« verletzt Not-Null-Constraint'

Do the wizard not automatically add a sequenze or convert the column to serial?

How can I change the integer column now to serial in PGAdmin?

regards

oracle migration problem

dmitry.bayanov — GMT

I've tried to migrate scheme from oracle and see errors like this:

Error Creating Constraint FK_BASE_PAY_RECEIPT: ERROR: syntax error at or near ")" at position 111
ALTER TABLE PAY_RECEIPT ADD CONSTRAINT FK_BASE_PAY_RECEIPT FOREIGN KEY (PAYRECEIPT_ID) REFERENCES TIGER.null () MATCH FULL ON DELETE NO ACTION

After removing "()" and adding schema name to table:
ALTER TABLE tiger.CALC_ERROR ADD CONSTRAINT FK_CALC_ERROR_TYPE FOREIGN KEY (CALC_ERROR_TYPE_CODE) references tiger.null MATCH FULL ON DELETE NO ACTION;
ERROR: relation "tiger.null" does not exist

Google doesn't know about this problem or may be I ask wrong questions.
Give me some glues how to solve this problem.
Thanks.

Problem with ENUM Migrate from MySQL

xjrmame — GMT

Hello
I have installed the newest PostgreSQL and also the migration wizard which is included in the package.
Problems occured while converting my MySQL tables which have ENUM types?

But why?
I thougt that Postgre now supports ENUM?

regards
Tom

Migration Wizard: Blank source schema page

dscampbell — GMT

Im trying to migrate from MySQL to postgreSQL but i cant get past the Source Schema section in the wizard. It connects to both databases fine but i get blank options when i get to the step 4: Source Schema

can anyone help me? Thanks

How to Migrate SQL SERVER 2000 Data Into Postgres 9.0

Umesh_gupta — GMT

We need to migrate our database from MS SQL Server 2000 to Postgres 9.0 on LINUX..

Any body can help in this respect.

please let me know the all steps..

Thanks

Umesh

Searching in multi-dimensional array fields

Daniel_Hursan — GMT

Hi,

I'm trying to build a query on a multidimensional array field, for example:
The array is organized as {key, value}.

{{'username','daniel'},{'first_name',''},{'middle_name',''},{'last_name',''},{'mailserver_guid','1'},{'number_of_mailaliases','1'}......}.

[B]Is there any way of searching , let's say for all username = daniel, without depending on indexes ??? [/B]
This is very useful to avoid issues like modifying array structure.

Sorry if this is not the right topic for my question.
Thanks in advance for any ideas !

I can't start migration studio Pg As 8.

Vaclav_CHMEL — GMT

Hi,
I can' start migration studio of Postgres Plus Advanced Server 8.3R2 and 8.4.

error message:

# An unexpected error has been detected by HotSpot Virtual Machine:
#
# EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x6d2b88db, pid=10864, tid=7620
#
# Java VM: Java HotSpot(TM) Client VM (1.5.0_22-b03 mixed mode)
# Problematic frame:
# C [fontmanager.dll+0x88db]
#

--------------- T H R E A D ---------------

Current thread (0x00868518): JavaThread "main" [_thread_in_native, id=7620]

siginfo: ExceptionCode=0xc0000005, reading address 0x6d360c94

Registers:
EAX=0xfffffee4, EBX=0x6d360c94, ECX=0x6d2f9804, EDX=0x000cf744
ESP=0x000cf6f8, EBP=0x000cf708, ESI=0x00010173, EDI=0x00001802
EIP=0x6d2b88db, EFLAGS=0x00010297

Top of Stack: (sp=0x000cf6f8)
0x000cf6f8: 00001802 0dd40a80 0de32b68 6d2f9804
0x000cf708: 000cf724 6d2b880b 000cf744 000cf71c
0x000cf718: 0de8a560 0de8bd63 0de8bd63 000cf798
0x000cf728: 6d2ba193 0dd40a80 000cf744 00000000
0x000cf738: 00000000 0dd40a80 0dc1d5c0 0dc1d500
0x000cf748: 008686a8 00000001 00006137 0dd40a80
0x000cf758: 0000434e 00000000 0df10000 aaa997d1
0x000cf768: 000cf780 6d2b9819 3de8a80d 0000b7ac

Instructions: (pc=0x6d2b88db)
0x6d2b88cb: 6d 3b f1 57 89 4d fc 7d 42 8d 1c f5 fc 00 2e 6d
0x6d2b88db: 8b 0b 8b fa 8a 11 8a c2 3a 17 75 1a 84 c0 74 12

Stack: [0x00090000,0x000d0000), sp=0x000cf6f8, free space=253k
Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code)
C [fontmanager.dll+0x88db]
C [fontmanager.dll+0x880b]
C [fontmanager.dll+0xa193]
C [fontmanager.dll+0x9782]
C [fontmanager.dll+0x1204d]
C [fontmanager.dll+0x23f11]
j sun.font.Type1Font.createScaler(I)J+0
j sun.font.Type1Font.getScaler()J+15
j sun.font.Type1GlyphMapper.initMapper()V+16
j sun.font.Type1GlyphMapper.(Lsun/font/Type1Font;)V+10
j sun.font.Type1Font.getMapper()Lsun/font/CharToGlyphMapper;+13
j sun.font.Font2D.canDisplay(C)Z+1
j java.awt.Font.canDisplay(C)Z+5
j java.awt.Font.canDisplayUpTo(Ljava/text/CharacterIterator;II)I+22
j java.awt.Font.canDisplayUpTo(Ljava/lang/String;)I+14
j com.edb.commons.i18n.I18NUtils.getAvailableChineseFonts()Ljava/util/ArrayList;+35
j com.edb.commons.i18n.I18NUtils.getPrefferedChineseFont()Ljava/awt/Font;+0
j com.enterprisedb.admin.MainWindow.loadFontSetting()Ljava/awt/Font;+4
j com.enterprisedb.admin.Administrator.main([Ljava/lang/String;)V+6
v ~StubRoutines::call_stub
V [jvm.dll+0x876b1]
V [jvm.dll+0xe0018]
V [jvm.dll+0x87582]
V [jvm.dll+0x8e7c5]
C [javaw.exe+0x14c5]
C [javaw.exe+0x317f]
C [kernel32.dll+0x13677]
C [ntdll.dll+0x39d42]
C [ntdll.dll+0x39d15]

Java frames: (J=compiled Java code, j=interpreted, Vv=VM code)
j sun.font.Type1Font.createScaler(I)J+0
j sun.font.Type1Font.getScaler()J+15
j sun.font.Type1GlyphMapper.initMapper()V+16
j sun.font.Type1GlyphMapper.(Lsun/font/Type1Font;)V+10
j sun.font.Type1Font.getMapper()Lsun/font/CharToGlyphMapper;+13
j sun.font.Font2D.canDisplay(C)Z+1
j java.awt.Font.canDisplay(C)Z+5
j java.awt.Font.canDisplayUpTo(Ljava/text/CharacterIterator;II)I+22
j java.awt.Font.canDisplayUpTo(Ljava/lang/String;)I+14
j com.edb.commons.i18n.I18NUtils.getAvailableChineseFonts()Ljava/util/ArrayList;+35
j com.edb.commons.i18n.I18NUtils.getPrefferedChineseFont()Ljava/awt/Font;+0
j com.enterprisedb.admin.MainWindow.loadFontSetting()Ljava/awt/Font;+4
j com.enterprisedb.admin.Administrator.main([Ljava/lang/String;)V+6
v ~StubRoutines::call_stub

--------------- P R O C E S S ---------------

Java Threads: ( => current thread )
0x0c1f7ff0 JavaThread "Java2D Disposer" daemon [_thread_blocked, id=1020]
0x0023adb8 JavaThread "Low Memory Detector" daemon [_thread_blocked, id=7104]
0x0023b9f8 JavaThread "CompilerThread0" daemon [_thread_blocked, id=8428]
0x0023a430 JavaThread "Signal Dispatcher" daemon [_thread_blocked, id=10460]
0x00231f08 JavaThread "Finalizer" daemon [_thread_blocked, id=10432]
0x0022f930 JavaThread "Reference Handler" daemon [_thread_blocked, id=11044]
=>0x00868518 JavaThread "main" [_thread_in_native, id=7620]

Other Threads:
0x0022c0a8 VMThread [id=10752]
0x001da1e8 WatcherThread [id=10736]

VM state:not at safepoint (normal execution)

VM Mutex/Monitor currently owned by a thread: None

Heap
def new generation total 576K, used 380K [0x03e00000, 0x03ea0000, 0x042e0000)
eden space 512K, 61% used [0x03e00000, 0x03e4f028, 0x03e80000)
from space 64K, 99% used [0x03e80000, 0x03e8fff8, 0x03e90000)
to space 64K, 0% used [0x03e90000, 0x03e90000, 0x03ea0000)
tenured generation total 4108K, used 2862K [0x042e0000, 0x046e3000, 0x07e00000)
the space 4108K, 69% used [0x042e0000, 0x045abb10, 0x045abc00, 0x046e3000)
compacting perm gen total 8192K, used 4154K [0x07e00000, 0x08600000, 0x0be00000)
the space 8192K, 50% used [0x07e00000, 0x0820eb70, 0x0820ec00, 0x08600000)
No shared spaces configured.

Dynamic libraries:
0x00400000 - 0x0040d000 C:\Prgs\PostgresPlus\8.4AS\jre\bin\javaw.exe
0x77e20000 - 0x77fa0000 C:\Windows\SysWOW64\ntdll.dll
0x76d90000 - 0x76e90000 C:\Windows\syswow64\kernel32.dll
0x77260000 - 0x772a6000 C:\Windows\syswow64\KERNELBASE.dll
0x76cf0000 - 0x76d90000 C:\Windows\syswow64\ADVAPI32.dll
0x772b0000 - 0x7735c000 C:\Windows\syswow64\msvcrt.dll
0x77050000 - 0x77069000 C:\Windows\SysWOW64\sechost.dll
0x777e0000 - 0x778d0000 C:\Windows\syswow64\RPCRT4.dll
0x75990000 - 0x759f0000 C:\Windows\syswow64\SspiCli.dll
0x75980000 - 0x7598c000 C:\Windows\syswow64\CRYPTBASE.dll
0x759f0000 - 0x75af0000 C:\Windows\syswow64\USER32.dll
0x75c40000 - 0x75cd0000 C:\Windows\syswow64\GDI32.dll
0x77df0000 - 0x77dfa000 C:\Windows\syswow64\LPK.dll
0x77530000 - 0x775cd000 C:\Windows\syswow64\USP10.dll
0x779c0000 - 0x77a20000 C:\Windows\system32\IMM32.DLL
0x76b90000 - 0x76c5c000 C:\Windows\syswow64\MSCTF.dll
0x6d740000 - 0x6d8de000 C:\Prgs\PostgresPlus\8.4AS\jre\bin\client\jvm.dll
0x73380000 - 0x733b2000 C:\Windows\system32\WINMM.dll
0x74da0000 - 0x74deb000 C:\Windows\system32\apphelp.dll
0x6d300000 - 0x6d308000 C:\Prgs\PostgresPlus\8.4AS\jre\bin\hpi.dll
0x77070000 - 0x77075000 C:\Windows\syswow64\PSAPI.DLL
0x6d710000 - 0x6d71c000 C:\Prgs\PostgresPlus\8.4AS\jre\bin\verify.dll
0x6d380000 - 0x6d39d000 C:\Prgs\PostgresPlus\8.4AS\jre\bin\java.dll
0x6d730000 - 0x6d73f000 C:\Prgs\PostgresPlus\8.4AS\jre\bin\zip.dll
0x6d070000 - 0x6d1e0000 C:\Prgs\PostgresPlus\8.4AS\jre\bin\awt.dll
0x73320000 - 0x73371000 C:\Windows\system32\WINSPOOL.DRV
0x76ef0000 - 0x7704c000 C:\Windows\syswow64\ole32.dll
0x6f4a0000 - 0x6f520000 C:\Windows\system32\uxtheme.dll
0x6d2b0000 - 0x6d300000 C:\Prgs\PostgresPlus\8.4AS\jre\bin\fontmanager.dll
0x6d540000 - 0x6d553000 C:\Prgs\PostgresPlus\8.4AS\jre\bin\net.dll
0x76c60000 - 0x76c95000 C:\Windows\syswow64\WS2_32.dll
0x777d0000 - 0x777d6000 C:\Windows\syswow64\NSI.dll
0x74f30000 - 0x74f6c000 C:\Windows\system32\mswsock.dll
0x74a10000 - 0x74a16000 C:\Windows\System32\wship6.dll
0x6d560000 - 0x6d569000 C:\Prgs\PostgresPlus\8.4AS\jre\bin\nio.dll

VM Arguments:
java_command: C:\Prgs\PostgresPlus\8.4AS/migrationstudio\edb-migrationstudio.jar
Launcher Type: SUN_STANDARD

Environment Variables:
PATH=C:\Prgs\Oracle\app\admin\product\11.2.0\dbhome_1\bin;C:\Program Files (x86)\Embarcadero\RAD Studio\7.0\bin;C:\Users\Public\Documents\RAD Studio\7.0\Bpl;C:\Prgs\Oracle\instantclient_11_2;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files\Intel\DMIX;C:\Program Files (x86)\NTRU Cryptosystems\NTRU TCG Software Stack\bin\;C:\Program Files\NTRU Cryptosystems\NTRU TCG Software Stack\bin\;C:\Program Files\Wave Systems Corp\Gemalto\Access Client\v5\;c:\Program Files (x86)\Common Files\Roxio Shared\DLLShared\;c:\Program Files (x86)\Common Files\Roxio Shared\10.0\DLLShared\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\VMware\Infrastructure\VIToolkitForWindows\Scripts;C:\Program Files (x86)\Pinnacle\Shared Files\;C:\Program Files\WIDCOMM\Bluetooth Software\;C:\Program Files\WIDCOMM\Bluetooth Software\syswow64;;C:\Program Files (x86)\Embarcadero\Delphi Prism\bin;C:\Program Files (x86)\Embarcadero\Delphi Prism\bin;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files (x86)\Nmap;C:\Program Files (x86)\OpenVPN\bin
USERNAME=admin
OS=Windows_NT
PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 23 Stepping 10, GenuineIntel

--------------- S Y S T E M ---------------

OS: Windows 7 , 64 bit Build 7600

CPU:total 2 (cores per cpu 2, threads per core 1) family 6 model 7 stepping 10, cmov, cx8, fxsr, mmx, sse, sse2

Memory: 4k page, physical 4181924k(965688k free), swap 4194303k(3359780k free)

vm_info: Java HotSpot(TM) Client VM (1.5.0_22-b03) for windows-x86, built on Oct 9 2009 01:15:45 by "java_re" with MS VC++ 6.0

Could you help me?

Thanks Vaclav

Postgres to kill Queries

joan_ventura_2 — GMT

We have a database here... but i think we have a bad configuration...

can i set the database so when a query has spent some MBs on memory, lets say i put a limit of 100MBs so, when the query arrive to this limit the database kills the query?

if its this possible? whats the set that i have to do.

ERROR Migrating Table - OCI throws ORA-01406, JDBC Copy throws invalid byte seq ... encoding "UTF8"

null — GMT

Hi All,

Trying to use migration toolkit:

With OCI:

( ../bin/runMTK.sh -dataonly -alltables -copyViaDBLinkOra -truncload -logDir ScriptLog -fastCopy blk_common_dat ca_inq_dat )

...
Migrated 435000 rows.
Migrated 440000 rows.
Migrated 445000 rows.
Migrated 450000 rows.
Migrated 455000 rows.
Error Loading Data into Table: BATCH_REQUESTS_ENHANCED: ERROR: OCI call failed
Detail: ORA-01406: fetched column value was truncated

Disabling FK constraints & triggers on ca_inq_dat.city_zip_county before truncate...
Error Loading Data into Table: CITY_ZIP_COUNTY: ERROR: current transaction is aborted, commands ignored until end of transaction block
Disabling FK constraints & triggers on ca_inq_dat.client_company_req_codes before truncate.

==========================================================

With the standard JDBC Copy:

( ../bin/runMTK.sh -dataonly -alltables -copyDelimiter '~' -truncload -logDir ScriptLog -fastCopy blk_common_dat ca_inq_dat )

Loading Table: BATCH_REQUESTS_ENHANCED ...
Error Loading Data into Table: BATCH_REQUESTS_ENHANCED: ERROR: invalid byte sequence for encoding "UTF8": 0x00
Hint: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
Where: COPY batch_requests_enhanced, line 5404

-----------------

The good / bad news: JDBC continues / OCI Fails the rest of the tables.

Suggestions?

thank you,

john

Oracle dblink migration issue

null — GMT

Good Morning,

I'm trying to migrate some tables from Oracle 9.2.0.8 to edb 8.4. I have configured the db link capability, but can't get the script-based migration to recognize the link, yet the query tool does.

Migration tool call & output:

Script to call runMTK:

bash-3.2$ cat mtk-gss_2.sh
../bin/runMTK.sh -dataonly -copyViaDBLinkOra -tables TRAN_REQUESTS,USRS,VEHICLES -truncload -logDir ScriptLog -copyDelimiter ^ gss_common_dat
# 1. GSS_COMMON_DAT.TRAN_REQUESTS
# 2. GSS_COMMON_DAT.USRS
# 3. GSS_COMMON_DAT.VEHICLES
---------------------------------

Results in:

bash-3.2$ ./mtk-gss_2.sh

Source database connectivity info...
conn =jdbc:oracle:thin:@caeser.gssolrs.net:1521:TMP1
user =dbmgr
password=******
Target database connectivity info...
conn =jdbc:edb://localhost:5444/a_edbtmp1
user =enterprisedb
password=******
Connecting with source Oracle database server...
Connecting with target EnterpriseDB database server...
Importing redwood schema gss_common_dat...
Table List: 'TRAN_REQUESTS','USRS','VEHICLES'
Error while loading DBLink_Ora module. ERROR: OCI call failed
Detail: ORA-12154: TNS:could not resolve the connect identifier specified

Verify that dblink_ora is installed/configured on target EnterpriseDB server. Refer to $EDB_HOME/share/doc/contrib/README-DBLINK_ORA_SETUP.txt for more details on how to configure the dblink_ora module.
ERROR: connection "mtk_connection" not available

Schema gss_common_dat imported with errors.

One or more schema objects could not be imported during the migration process. Please review the migration output for more details.

Migration logs have been saved to /opt/PostgresPlus/8.4AS/FromTemp/ScriptLog

******************** Migration Summary ********************

Total objects: 0
Successful count: 0
Failure count: 0

*************************************************************
bash-3.2$

=====================================

Query Tool:

drop public database link mtk_connection;
create public database link mtk_connection connect to dbmgr identified by dbman05 using 'TMP1';
select * from gss_common_dat.products@mtk_connection;

returns:

Total query runtime: 199 ms.
30 rows retrieved.

From psql:

edb=# select * from gss_common_dat.products@TMP1;
ERROR: server "tmp1" does not exist
LINE 1: select * from gss_common_dat.products@TMP1;
^
edb=# select * from pg_dblinks;
link_name | link_type | server | port | user_name | user_pwd | remote_database_name
-----------+-----------+--------+------+-----------+----------+----------------------
(0 rows)

psql (8.4.4.10)
Type "help" for help.

edb=# create public database link TMP1 connect to dbmgr identified by dbman05 using '//caeser.gssolrs.net:1521/TMP1';
CREATE DATABASE LINK
edb=# select * from gss_common_dat.products@TMP1;
ERROR: ORA-12154: TNS:could not resolve the connect identifier specified

LINE 1: select * from gss_common_dat.products@TMP1;
^
edb=# exit

Testing SQLPlus:

bash-3.2$ sqlplus dbmgr/dbman05@TMP1;

SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 8 11:13:04 2010

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle9i Release 9.2.0.8.0 - Production
JServer Release 9.2.0.8.0 - Production

SQL>

====================================

Am I missing something?

thank you,

john

Tuning wizard on linux

joan_ventura_2 — GMT

Can i use tuning wizard with a linux server?

Does Postgresql 8.4 supports all the functions supported by Advanced postgres plus server

Rajesh _A — GMT

[b]Dear All,

Previously we configured Advanced Postgres Plus server for our web application...

Now the same is configured with Postgresql 8.4 since Advanced Postgres plus is a licensed version...

But most of the functions and sql queries are not working with Postgresql 8.4.

What should I do to make things fine with Postgresql8.4..

Is there any add-ons or plugins available for Postgresql8.4 to support Postgres plus functions...

Please suggest me.. [/b]

Unable to restore data from version 8.3 to 8.4

Sohrab_Monsi — GMT

Hi,

I have installed a PostgreSQL server version 8.4.4, and wanted to restore my old data from PostgreSQL server version 8.3.11. When i tried to restore the data, it gives me a failure notice with ignoring failure code: 736. Afterward, i have edited the data with Hexadecimal editor and i have changed to the data form from 8.3.11 to 8.4.4. Then from PGAdmin III i could able to restore the data with failure code:0, but afterward it does't show those data in new databank. What should i do to read my old data in version 8.4.4?

Please help me? Can i do it also manually? what is the right command to perform it?

Regards,
Monsi