![]() ![]() The safest way to do this is to create a new profile that has all the same settings as the old profile, but with one change. You say you want to prevent your password from expiring in the future? Not problem, because all you need is a profile that prevents the password from expiring. How to Prevent “ORA-28001: the password has expired” From Happening In The Future Run the block of code, and your account will be unlocked and the password unexpired. ![]() Select 'alter user ' || name || q'' || spare4 || ' ' || password || q'' into v_unexpire_command >ĬONST_USERNAME constant varchar2(128) := 'PUT_USERNAME_YOU_WANT_TO_UNEXPIRE_HERE' Įxecute immediate ' alter user ' || CONST_USERNAME || ' account unlock' In the below block of code, you’ll want to replace PUT_USERNAME_YOU_WANT_TO_UNEXPIRE_HERE with whomever you want to unexpire the password for. So, here’s a workaround that will let you unexpire your password without having to change it! Or, even know what the password is!! How to Fix The Issue Now There are times when this feature is an annoyance, because sometimes changing your password is more trouble than it’s worth. Oracle is trying to force you to change your password to something different so that your database remains secure. So, if you’re getting this error, it means a password change is overdue. Yikes! This means that the user’s profile forces them to periodically change their password, due to a security precaution. Then register this same XML document as a user defined extension to the SQL Developer component in JDeveloper:įirst, restart JDeveloper to have the registration take effect.You’re trying to login to an Oracle database and you get ORA-28001: the password has expired. Select Type as Navigator and Location of the XML which has the queries and nodes are configured. Tools menu -> Preferences -> Database -> User Defined Extension -> Click Add Row JDeveloper Database Navigator emulates the same UI similar to SQL Developer after performing the below change in SQL Navigator: This gives developers the option to write extension. SQL developer leverages the JDeveloper IDE. Refer to this: How to backup Oracle DB using RMAN, and restore oracle using RMAN. Storage – Archive Logs, Control Files, Data files etc.Resource Manager – Plan, Settings, statistics etc.Data pump – Wizards to data export/import etc.Database Confiugration – Init parameters, Usuage Reports etc.This allows users with administrative privileges to access features across the following areas: As you see from the following view menu, there are several power features available for developers.Īny existing SQL Developer connection can be added to the DBA panel, available under the View menu. This latest SQL Developer has powerful features for developers and DBAs which are listed here. Once connected, it will list all the db objects for the connected schema as shown below. From the list, select the database where you want to connect it. Tools menu -> Preferences -> Database -> Advanced -> TNSNAMES Directory -> Click the browser and select the path somethink like this: C:\xyz\product\11.2.0\client_1\network\adminĪfter launching SQL Developer, it will now know where to get the list of TNS entries for db connection. Point the Oracle Client Home to SQL Developer by setting appropriate tnsnames directory as shown below: Windows 64-bit installer has been bundled with JDK 1.8 but other installers require JDK 1.8 to be installed. While launching, it copies the data from the existing SQL Developer version if any. Then Click the sqldeveloper.exe to get started. This SQL Developer standalone version can be downloaded from here.Īfter the download, unzip the file into a directory. To overcome this fat installation of SQL developer, go for the stand-alone SQL Developer version. Install Option#2: Standalone SQL Developer Install ![]() If you don’t have the correct JDK version, it will download and install it. ![]() The SQL Developer client looks for JDK 1.8 and above to launch it. This SQL Developer shortcut is getting created under Application Development in the Oracle – OraClient11g_home1 shortcut. Oracle Instant Client can be downloaded from here. For example, oracle 11g client 11.2.0.1.0 installer installs SQL Developer version 1.5.5 when Administrator mode is chosen as shown below. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |