Oracle connection string

ORA-01017: invalid username/password; logon denied
Solution:
1. "Run"-> Enter cmd-> enter the root directory
2. Input: sqlplus/nolog;
3. Connect username/password as sysdba. "linked" is displayed ";
4. Then you can use another user (non-Administrator account login ).

Oracle data provider for. Net (10.2.0.1.0)

Oledbconnection con = new oledbconnection (@ "provider = oraoledb. oracle.1; user id = bigtide2012; Password = shlzghli; Data Source = Dia; persist Security info = true; extended properties = plsqlrset = 1 ;");

Data Source = 130.200.81.190: 1521/Dia; user id = bigtide2012; Unicode = true

Java code:
String username = "sys as sysdba ";
String userpass = "TP ";
String drivername = "oracle. JDBC. Driver. oracledriver ";
String databaseurl = "JDBC: oracle: thin: @ 192.168.20.13: 1521: orcl ";

The ole db provider is not specified in connectionstring.

Insert into imagestore (imageid, imagedata, imagedata1, imagecontenttype, imagedescription, imagesize) values (s_imagestore.nextval, null, null, '','', 1 );

Access connection string

This. oledbconnection. connectionstring = @ "jet oledb: Global partial bulk Ops = 2;
Jet oledb: Registry Path =;
Jet oledb: Database locking mode = 0;
Data Source = "" E: \ ADO. Net \ ADO \ WEB \ app_data \ userdb. mdb "";
Jet oledb: Engine type = 5;
Provider = "" Microsoft. Jet. oledb.4.0 "";
Jet oledb: System database =;
Jet oledb: SFP = false;
Persist Security info = false;
Extended properties =;
Mode = share deny none;
Jet oledb: encrypt database = false;
Jet oledb: Create System database = false;
Jet oledb: Don't copy locale on compact = false;
Jet oledb: compact without replica repair = false;
User ID = admin;
Jet oledb: Global bulk transactions = 1"

Oracle SGA performance optimization:

Alter system set pre_page_sga = false scope = spfile;

Alter system set sga_size = 4096 M scope = spfile;

Sga_max_size
Sga_target

Alter system set sga_max_size = 3072 M scope = spfile

Alter system set sga_target = 3072 m;

Awe_window_memory 4294967296

Show parameter spfile

Show parameter SGA

Conn/As sysdba

Shutdown immediate;
Startup;

Alter system reset sga_max_size scope = spfile SID = '*';
Alter system reset sga_target scope = spfile SID = '*';
Alter system set shared_pool_size = 256 m scope = spfile;
Alter system set db_block_buffers' = 320000 scope = spfile;
Alter system set use_indirect_data_buffers = true scope = spfile;

Alter system set lock_sga = true;
Alter system set lock_sga = true;