vizagpower Posted January 10, 2013 Report Posted January 10, 2013 [quote name='iTeachSAP' timestamp='1357836196' post='1303084651'] Oralce lo ee command kotti chudu ... nuvvu create chesina informatica user ki password expire ayindhemo check chesukoo .. [b]select username, account_status, expiry_date, lock_date from dba_users;[/b] [/quote] hi can u tell me the syntax to create a new schema in oracle 11g
yankees Posted January 10, 2013 Report Posted January 10, 2013 [quote name='computerboy' timestamp='1357834977' post='1303084431'] Apice lap kadhu va.. Na own lap....so nenee ADMIN nee [/quote] own laptop aaaaaaaaaaa
iTeachSAP Posted January 10, 2013 Report Posted January 10, 2013 [quote name='vizagpower' timestamp='1357836453' post='1303084707'] hi can u tell me the syntax to create a new schema in oracle 11g [/quote] chala simple bayya.. CREATE USER <USERNAME> identified by password ; and then grant access to it.. anthe...
vissu Posted January 10, 2013 Report Posted January 10, 2013 [quote name='computerboy' timestamp='1357834079' post='1303084326'] Hi All, Na Lap lo Informatica Repository connecy avutuntee ela error vastundhee......Admin console lo ORA -28001 The Password has expired ane error vastundhee....logs lo plz Evaraina help cheyandhee plz Repository password ela change cheyale... [color=#FF0000]Admin Console Error:[/color] serviceType serviceName severity timestamp threadName messageCode message RS Rep_localhost 1$_:_$ERROR 01/10/2013 15:31:07.277 PM 3220 REP_51002 Failed to logon to Database server Database driver error... Function Name : Logon [color=#FF0000]ORA-28001: the password has expired[/color] Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [pow_repo] and connection string [localhost:1521/dev.168.0.113]. [/quote] Hi Computerboy, [u]solution edegooo.......[/u] 1. sqlplus lo sys database ke connect avvu first 2. ee command execute cheyee sysdba loo Sql > select * from dba_profiles; password life time anedhee 180 days keee responsible. 3. malli ee command cheyee danenee Disable cheyadanekee. 4. Sql> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; 5. Taruvatha cross check cheyee disabling features nee. 6. Sql > select * from dba_profiles; so eppuduu nee password_life_time change ayyindhee life time kee.......inka eppuduu expire avvadhuu 7. eppuduu password change cheyee nee USER dhee.....ee command tho 8. ALTER USER <USERNAME> IDENTIFIED BY <NEWPASSWORD>. 9. eppuduu nee USER nee UNLOCK cheyee....ee command tho... 10. ALTER USER <USERNAME> ACCOUNT UNLOCK; 11. Eppuduu nee User account nee cross check cheyeee danee status telustundhee 12. sql> select username,account_status from dba_users so eppuduu nee password change ayyindhee....and nee USER unlock ayyindhee...... Step1: Informatica Admin console loke vellee..... Step2: Nee Repository nee and Integration Services nee Refresh cheyeeee....Definite ga pane chesthadheee..... Njoy........................If u need any help let me know
yankees Posted January 10, 2013 Report Posted January 10, 2013 [quote name='iTeachSAP' timestamp='1357836443' post='1303084701'] System password tho sambandham ledhu anukunta mama.. unless he is using windows authentication to login in to database. I dont think he is using that ... [/quote] yes.........i thought its office laptop
computerboy Posted January 10, 2013 Author Report Posted January 10, 2013 [quote name='vissu' timestamp='1357836726' post='1303084751'] Hi Computerboy, [u]solution edegooo.......[/u] 1. sqlplus lo sys database ke connect avvu first 2. ee command execute cheyee sysdba loo Sql > select * from dba_profiles; password life time anedhee 180 days keee responsible. 3. malli ee command cheyee danenee Disable cheyadanekee. 4. Sql> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; 5. Taruvatha cross check cheyee disabling features nee. 6. Sql > select * from dba_profiles; so eppuduu nee password_life_time change ayyindhee life time kee.......inka eppuduu expire avvadhuu 7. eppuduu password change cheyee nee USER dhee.....ee command tho 8. ALTER USER <USERNAME> IDENTIFIED BY <NEWPASSWORD>. 9. eppuduu nee USER nee UNLOCK cheyee....ee command tho... 10. ALTER USER <USERNAME> ACCOUNT UNLOCK; 11. Eppuduu nee User account nee cross check cheyeee danee status telustundhee 12. sql> select username,account_status from dba_users so eppuduu nee password change ayyindhee....and nee USER unlock ayyindhee...... Step1: Informatica Admin console loke vellee..... Step2: Nee Repository nee and Integration Services nee Refresh cheyeeee....Definite ga pane chesthadheee..... Njoy........................If u need any help let me know [/quote] Thank you Vissu Working fine.......thanks a lot....... User work chestundhe.....Password change chesanuu.... Repository and Integration Services....work chestunnayee
iTeachSAP Posted January 10, 2013 Report Posted January 10, 2013 [quote name='computerboy' timestamp='1357837199' post='1303084826'] Thank you All [/quote] informatica chincheyi mama... [img]http://i1249.photobucket.com/albums/hh517/twinklebt/Brahmis/brahmi37.gif[/img] By the way which version of infirmatica ?
Terminator II Posted January 10, 2013 Report Posted January 10, 2013 [quote name='vissu' timestamp='1357836726' post='1303084751'] Hi Computerboy, [u]solution edegooo.......[/u] 1. sqlplus lo sys database ke connect avvu first 2. ee command execute cheyee sysdba loo Sql > select * from dba_profiles; password life time anedhee 180 days keee responsible. 3. malli ee command cheyee danenee Disable cheyadanekee. 4. Sql> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; 5. Taruvatha cross check cheyee disabling features nee. 6. Sql > select * from dba_profiles; so eppuduu nee password_life_time change ayyindhee life time kee.......inka eppuduu expire avvadhuu 7. eppuduu password change cheyee nee USER dhee.....ee command tho 8. ALTER USER <USERNAME> IDENTIFIED BY <NEWPASSWORD>. 9. eppuduu nee USER nee UNLOCK cheyee....ee command tho... 10. ALTER USER <USERNAME> ACCOUNT UNLOCK; 11. Eppuduu nee User account nee cross check cheyeee danee status telustundhee 12. sql> select username,account_status from dba_users so eppuduu nee password change ayyindhee....and nee USER unlock ayyindhee...... Step1: Informatica Admin console loke vellee..... Step2: Nee Repository nee and Integration Services nee Refresh cheyeeee....Definite ga pane chesthadheee..... Njoy........................If u need any help let me know [/quote] awesome bhayya,.. informatica admin aa nuvvu.. developer aa
vissu Posted January 10, 2013 Report Posted January 10, 2013 [quote name='kevkekaa' timestamp='1357837484' post='1303084859'] awesome bhayya,.. informatica admin aa nuvvu.. developer aa [/quote] Nenuuu Oracle lo working bhayyaa
Terminator II Posted January 10, 2013 Report Posted January 10, 2013 [quote name='vissu' timestamp='1357838229' post='1303084923'] Nenuuu Oracle lo working bhayyaa [/quote] okk...
vizagpower Posted January 10, 2013 Report Posted January 10, 2013 [quote name='iTeachSAP' timestamp='1357836665' post='1303084741'] chala simple bayya.. CREATE USER <USERNAME> identified by password ; and then grant access to it.. anthe... [/quote] is it the syntax for schema creation?
Recommended Posts