Oracle SYS as SYSDBA Connection |
[eluser]Unknown[/eluser]
Hi CI experts, I have a project using CodeIgniter (version 2.1.0) and Oracle as its database. The problem is it has to connect using SYS account as SYSDBA. Here is the code: Code: function ora_conn() 1. "SYS" Result: "ORA-28009: connection as SYS should be as SYSDBA or SYSOPER" 2. "SYS AS SYSDBA" Result: "ORA-01017: invalid username/password; logon denied" 3. some users apart from SYSDBA Result: connected. for point 2, I'm pretty sure about the password for SYS account, I think the problem is how to declare "AS SYSDBA" in the connection configuration. any idea ? Thanks in advance, yusata.
[eluser]weboap[/eluser]
check this http://ellislab.com/forums/viewthread/68453/ http://codeigniter.com/wiki/Oracle:Known_Issues/ hope it help! |
Welcome Guest, Not a member yet? Register Sign In |