Blog search
Entries from AnySQL.net tagged with 'SYSDBA'
学习Perl DBI -- 以SYSDBA或SYSOPER连接到Oracle
在连接9i或以上版本的Oracle数据库时, 必须指定SYSDBA或SYSOPER选项, 当你的Perl角本需要以SYS用户连接时, 如何指定呢? #!/usr/bin/perl -w # use DBI; # Get a database connection Handle. my $dbconn = DBI->connect("dbi:Oracle:", '/','/', {ora_session_mode=>2}); ...... 当ora_session_mode的值指定为2时表示以SYSDBA连接, 指定值为4时表示以SYSOPER来连接. 最近越来越发现Perl的好处, 以后将改用Perl来写些小角本, 并将源代码共享给大家....
Posted on January 15, 2007 11:27 PM
Feed Subscription
If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'SYSDBA'. [What is this?]
Other Tags
Other tags used on this blog:
- 2007 (8)
- ACE (1)
- ADSL (4)
- Alexa (5)
- Alibaba (1)
- AnySQL (22)
- Apache (2)
- Archive (2)
- Array (6)
- ASCII (1)
- ASSM (3)
- AUL Update (4)
- AUL/MyDUL (81)
- Awstats (5)
- Baby (2)
- Backup (4)
- Basename (1)
- Batch (2)
- Bind (2)
- Binlog (2)
- Block Format (2)
- Blog (46)
- Book (2)
- Buffer (1)
- Bug (3)
- Builder (2)
- Bulk (1)
- Busy (3)
- Byte (2)
- C (16)
- Cache (9)
- Camera (1)
- Canon (3)
- Capacity (1)
- Career (1)
- CDMA1X (9)
- Charset (8)
- Chart (2)
- Cigarette (1)
- Client (1)
- CLOB (3)
- Cluster (6)
- CNOUG (1)
- Column (5)
- Comment (2)
- Compress (6)
- Context (2)
- Copy (3)
- Copyright (2)
- Coredump (1)
- CPU Time (2)
- Crack (2)
- Crazy (1)
- Creative (1)
- CRH (1)
- CSV (9)
- Cube (1)
- 火车 (1)
- 爸爸 (4)
- 牙疼 (2)
- 牙医 (2)
- 玩弄 (1)
- 生活 (15)
- 礼物 (1)
- 空格 (1)
- 笑话 (1)
- 绑定变量 (3)
- 编译 (1)
- D630 (1)
- Data (13)
- Data Guard (3)
- DataDirect (1)
- DBA (53)
- DBD (15)
- DBDiff (3)
- DBI (14)
- DDL (2)
- Delete (2)
- Dell (2)
- DES3 (1)
- Dimension (1)
- Direct (2)
- DLL (1)
- Download (7)
- Drop (7)
- DSG (2)
- DST (1)
- DUL (15)
- Edian (2)
- eMail (1)
- Encrypt (1)
- English (4)
- Enqueue (1)
- Error (6)
- Excel (9)
- Export (18)
- External (1)
- 集成电路 (1)
- 补牙 (2)
- 裸设备 (1)
- 高薪 (1)
- 麒麟 (1)
- 麻将 (1)
- Fast (2)
- FastCGI (3)
- Favicon (1)
- Feedback (1)
- Fetch (2)
- File (6)
- Film (1)
- FM2 (1)
- Fork (3)
- Format (11)
- Free (2)
- Gift (2)
- GPRS (5)
- Handle (2)
- Hash (5)
- Hint (1)
- HotCopy (2)
- HTML (2)
- Huawei (1)
- iconv (4)
- ID (1)
- IE7 (1)
- Import (8)
- Index (21)
- InnoDB (1)
- Internet (1)
- IO (2)
- IOT (3)
- ITPub (3)
- Java (6)
- JavaScript (2)
- JDBC (3)
- Job (4)
- Join (2)
- Joke (1)
- Kernel (5)
- Keyboard (2)
- Kill (1)
- libsrvm (1)
- Life (80)
- Lilina (7)
- Linux (17)
- Load (10)
- Load Average (3)
- LOB (23)
- Lock (3)
- Log (36)
- Log Miner (21)
- LONG (5)
- Meeting (1)
- Memory (2)
- Metro (1)
- Motor (1)
- Move (3)
- MT (15)
- MTS (2)
- Mutex (1)
- MVIEW (15)
- MyLOG (8)
- MySQL (23)
- Nikon (1)
- Notes (1)
- OCI (6)
- OLAP (4)
- OLTP (3)
- Online (1)
- Open (1)
- Optimizer (3)
- Oracle (228)
- Oracle Bug (5)
- Oracle10g (12)
- Oracle11g (12)
- OTop (1)
- OTune (1)
- Parameter (3)
- Partition (2)
- Party (1)
- Password (2)
- Paste (1)
- Patch (3)
- Pay (1)
- Perl (32)
- Photos (3)
- PHP (2)
- Plugin (6)
- Pool (1)
- POSIX (3)
- Procedure (2)
- QQ (2)
- Query (4)
- Query Rewrite (8)
- Queue (1)
- RAC (9)
- Realsync (3)
- Recovery (42)
- Refresh (9)
- Regular Expression (3)
- Relink (1)
- Replication (20)
- Resetlogs (1)
- RMAN (4)
- RSS (1)
- rsync (4)
- SCode (6)
- Scren (1)
- Search (5)
- Security (2)
- Session (2)
- Set Unused (1)
- Shareplex (5)
- Shell (2)
- Skype (2)
- Smoking (1)
- Solaris (2)
- Sort (2)
- Speedup (1)
- Spool (1)
- SQL (30)
- SQL*Plus (3)
- SQLLDR (16)
- SQLServer (3)
- Standby (4)
- Startup (1)
- Statistics (5)
- Stock (2)
- Sybase (3)
- SYSDBA (1)
- System (7)
- Table (20)
- Tag (1)
- Taobao (1)
- Teeth (2)
- Temp (4)
- ThinkTwice (1)
- Thread (6)
- Ticket (3)
- Timestamp (1)
- Tnsname (1)
- Tomcat (1)
- Tools (16)
- Trigger (4)
- Truncate (2)
- Tuning (38)
- Unicode (1)
- Unix (11)
- Upgrade (5)
- USM (1)
- Value (2)
- View (2)
- VMWare (7)
- WE8ISO8859P1 (1)
- West Wind (1)
- WFH (1)
- Where (1)
- Windows (4)
- XML (2)
- 免费 (3)
- 分页 (1)
- 分区 (6)
- 南京北站 (1)
- 和谐 (1)
- 坏块 (1)
- 垃圾留言 (2)
- 夫子庙 (1)
- 孩子 (1)
- 幸运中国 (1)
- 微硬盘 (1)
- 性能调整 (15)
- 恢复 (1)
- 成长 (2)
- 手机 (1)
- 排序 (3)
- 摄影 (3)
- 数据恢复 (36)
- 数据仓库 (3)
- 日志文件 (1)
- 时间单位 (1)
- 杭州 (1)
- 查询重写 (6)
- 止哭 (1)
- 汉芯 (1)
- 一口价 (1)
- 东方明珠 (1)
- 游戏 (1)
- 交流 (1)