oracle连接字串

ORA-01017: invalid username/password; logon denied
解决方案：
1。“运行”->输入cmd->进入根目录
2。输入： sqlplus /nolog;
3. connect username/password as sysdba,  会显示“已链接”；
4。然后就可以使用其他用户（非管理员帐户登入了）。

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代码：  
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"; 

在 ConnectionString 中未指定 OLE DB 提供程序

insert into ImageStore(ImageID,ImageData,ImageData1,ImageContentType,ImageDescription,ImageSize)values(S_ImageStore.Nextval,NULL,NULL,'','',1);     

access连接字串

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 性能优化：

                                      alter system set pre_page_sga=false scope=spfile;

                                      alter system set sga_size=4096M scope=spfile;

sga_max_size
sga_target


ALTER SYSTEM SET sga_max_size = 3072M SCOPE=SPFILE

alter system set sga_target = 3072M;


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=256M 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;