ORA-00600: internal error code, arguments: [smboPut:fixedlen2]

while import full dump from AIX machine to X86 faced this error: [code language=»sql»] ORA-00600: internal error code, arguments: [smboPut:fixedlen2], [2], [7], [0], [66436], [], [], [], [], [], [], [] Failing sql is: CREATE INDEX SHIPMENT_INS_DATE ON SHIPMENT ("INSERT_DATE") ORA-39083: Object type INDEX failed to create with error: ORA-00600: internal error code, arguments: [smboPut:fixedlen2], […]

ORA-25152: TEMPFILE cannot be dropped at this time

hello, here how I dropped tempfile : start with: [code] ALTER TABLESPACE temp DROP TEMPFILE ‘+DATADG/p00pgp/tempfile/temp.340.882540285’; ALTER TABLESPACE temp DROP TEMPFILE ‘+DATADG/p00pgp/tempfile/temp.339.882540283’; [/code] but when I try to drop datafiles I’ve got this error: ORA-25152: TEMPFILE cannot be dropped at this time helped this sript [code language=»sql» highlight=»18″] SELECT b.TABLESPACE , b.segfile# , b.segblk# , […]

postgresql pgpool-II autofailover and failback

Hello, try to find a good material about how-to configure pgpool and found nothing, so I’ve decide to write my own article =)) I’m recommend to read previous articles: How to install postgres How to configure repmgr to manage standby databases because I use those config in this scenario So, lets start =) First of […]

postgresql repmgr how-to

For better result you should install database by this document how-to install postgres database i have 4 node config, 2 nodes in one datacenter and 2 in other config will look like this: [code] DR1 DR2 DB01—>DB11 | | \_DB02 \_DB12 [/code] create config file: node1 /u01/postgres/9.5/main/conf/repmgr.conf [code] node=1 cluster=db_cluster node_name=pg1 conninfo=’host=pg01 user=repmgr dbname=postgres password=q1′ […]

postgresql install how-to

I will split material of how-to install pgpool on several logical parts here is the first one: start install postgres with packages: [code] yum install postgresql95-devel postgresql95 postgresql95-test postgresql95-libs postgresql95-server postgresql95-contrib pgbouncer.x86_64 repmgr95* pgpool-II-95 pgpool-II-95-extensions [/code] for 9.6 [code] yum install postgresql96-devel postgresql96 postgresql96-test postgresql96-libs postgresql96-server postgresql96-contrib pgbouncer.x86_64 repmgr96* [/code] for 10 [code] yum install […]