Oracle, Web, Script, SQLserver, Tips & Trick

May 8, 2019

How to connect Form/Report dev6i to Oracle Database 12c

Filed under: dev6i,oracle,oracle:12c — sikathabis @ 2:21 am
Tags: , , ,

We have database 10.2.0.5, want to convert to 12.2.0.1, the step are:
– exp from 10.2.0.5
– imp to 12.2.0.1
import Oracle 12.2.0.1 has been completed.

And then the first problem is oracle form crash when connecting to oracle 12.2.0.1

After searching, the solution come from this website:
https://www.youtube.com/watch?v=V0Achdev4gA

CONNECT AS SYSDBA
CONNECT SYSTEM USER (SYSTEM/(OWN YOUR DATABASE PASSWORD))
SHUTDOWN IMMEDIATE;
STARTUP RESTRICT;
ALTER DATABASE CHARACTER SET INTERNAL_USE WE8MSWIN1252;
SHUTDOWN;
STARTUP MOUNT;
SHUTDOWN;
STARTUP RESTRICT;
SHUTDOWN;
STARTUP;

After solving the first problem, then the second problem is coming, ORA-28040: No matching authentication protocol

For second problem, this reference is the solution:
http://logic.edchen.org/how-to-resolve-ora-28040-no-matching-authentication-protocol/

Adding SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 to sqlnet.ora in 12.1 database server (not the old client).

Connecting successfulle but still got malformed TTC package message, will solved later ..

SQL*Plus: Release 8.0.6.0.0 – Production on Wed May 8 15:24:46 2019

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Enter password:
ERROR:
ORA-03137: malformed TTC packet from client rejected: [kpoal8Check-5] [0]
[0x000000000] [0x000000000] [0] [0] [2080] []

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production

SQL>



Advertisements

September 14, 2017

How to connect oracle 12c from toad 9.7

Filed under: oracle,oracle:12c,toad — sikathabis @ 3:34 am
Tags: , ,

You must have Oracle Client 10g and then replace 12c
https://sikathabis.wordpress.com/2013/09/12/menjalankan-toad-dengan-oracle-client-basic-lite-for-windows/

Example
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.111)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orclpdb)))

Blog at WordPress.com.

Pureblood

DONT WANNA BE NUMBER ONE

Learning is not a spectator sport

Connor McDonald on SQL and the Oracle Database

Teknologi Pendidikan

Just another WordPress.com weblog

BLOG KATAKAMI

Jurnalisme Yang Dapat Dipercaya

Tonk Kosonk Baonk Bunyinya

Penampungan Serapah Tanpa Sumpah

Qey050489's Blog

Ayo Bangkit sobat..!!!!!

B. S. Totoraharjo

Orang Desa Yang Mencintai Desa dan Kebudayaannya

culturekitchen foodlab

New Food and Art in Yogyakarta

Wahyu Catur Wibowo

Musafir Dunia Maya

SQL.... Still Learning

My Reference on SQL Server

arihdyacaesar

"Tuhan tidak menuntut kita untuk menang. Tuhan hanya meminta kita untuk berjuang tanpa henti.” -ean-

neinframe

Street Photography is like a box of a chocolates, you're never know what you're gonna get - Thomas Leuthard -

Be a good Moeslim

Menuju Pribadi Muslim Sejati yang Bertaqwa

TuanSUFI

Manajemen Sholat, renungan spiritual, Teknologi Informasi

Pelangi di khatulistiwa....

Mari berbagi kebaikan, pengalaman dan senyum denganku

Angkasa13

Ceritanya saya, Pikirannya saya, Hatinya saya

sikathabis

sikathabis semua informasi disini

Don Charisma

because anything is possible with Charisma