TNS-12533: TNS:illegal ADDRESS parameters

I was setting up an new database and adding a tns entry and I get TNS-12533: TNS:illegal ADDRESS parameters when I tnsping. Had not come across this one before. I look at my entry.


my_database =

(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = my_host)(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = my_database)
)
) <--- Turns out when I cut-n-paste I missed this last parenthesis. What a time waster.

Read More

ORA-1113 signalled during: alter database open

The ORa-1113 error means that your Backup implementation does an ALTER TABLESPACE BEGIN BACKUP and END BACKUP for each tablespace.

 Start the service.

Go to Windows command line prompt as the Administrator or account in the OS_DBA group (with the right ORACLE_SID, ORACLE_HOME and PATH)

sqlplus / as sysdba

startup mount -- or ALTER DATABASE MOUNT if it did get started but not mounted

ALTER TABLESPACE (tablespacename_that_was_in_backup_mode) END BACKUP ;
(if there were multiple tablespaces in backup mode, issue the END BACKUP for each one of them)

ALTER DATABASE OPEN ;
The other option to step 5 is the "RECOVER DATABASE" . Oracle may apply archivelogs to synchronise the datafiles back.

Read More

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

After successful creation of database. I was not able to start the listener. whenever i tried to start the listener it throws the error.


TNS-12560: TNS:protocol adapter error
TNS-00583: Valid node checking: unable to parse configuration parameters


Solution : I renamed sqlnet.ora . And started the listener again.

Read More

Reconfigure Oracle EM

When you’ve installed Oracle Database 11G as well you can’t change the Windows Host name without reinstalling Oracle Enterprise Manager.

1. Change the %ORACLE_HOME%\network\admin\listener.ora file from an IP number to machine name.
2. Change the %ORACLE_HOME%\network\admin\tnsnames.ora file from an IP number to a machine name.
3. Change the C:\WINDOWS\System32\drivers\etc\hosts file by adding this line beneath the default localhost line
  
127.0.0.1       localhost
192.168.50.1    servername.domain.xyz
Reboot the machine, and then drop the em configuration with the following commands:


C:\admin> set ORACLE_SID=orcl
C:\admin> emca -deconfig dbcontrol db -repos drop

You should then drop the SYSMAN user manually because it doesn’t happen without your assistance (or, it didn’t happen when I did it). If you don’t drop the SYSMAN schema, you’ll raise an error when you try to recreate it:

STARTED EMCA at Aug 23, 2012 1:26:42 AM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y

Error Like

CONFIG: ORA-20001: SYSMAN already EXISTS..
ORA-06512: at line 17

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already EXISTS..
ORA-06512: at line 17

Drop the user and dependent on version a few other objects, like;

DROP USER sysman CASCADE;
DROP PUBLIC SYNONYM setemviewusercontext;
DROP ROLE mgmt_user;
DROP PUBLIC SYNONYM mgmt_target_blackouts;
DROP USER mgmt_view;

You can then create the em environment with the following syntax:

C:\admin> emca -config dbcontrol db -repos create

 Again, you’ll receive the following prompts, enter the Oracle SID and Port number without double quotes but you must enter all passwords with double quotes (at least in Oracle Database 11g):

STARTED EMCA at Aug 23, 2012 1:26:42 AM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
 
Enter the following information:
DATABASE SID: orcl
Listener port NUMBER: 1521
Password FOR SYS USER:
Password FOR DBSNMP USER:
Password FOR SYSMAN USER:
Password FOR SYSMAN USER: Email address FOR notifications (optional):
Outgoing Mail (SMTP) server FOR notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

DATABASE ORACLE_HOME ................ C:\product\oracle\11.1.0\db_1
 
LOCAL hostname ................ servername
Listener port NUMBER ................ 1521
DATABASE SID ................ orcl
Email address FOR notifications ...............
Outgoing Mail (SMTP) server FOR notifications ...............

Do you wish TO continue? [yes(Y)/no(N)]: y

Read More

How to backup mode enable/disable

ALTER DATABASE BEGIN BACKUP; -- to enter the backup mode.

select file#,status from v$backup;
FILE# STATUS
---------- ------------------
1 ACTIVE
2 ACTIVE
3 ACTIVE
4 ACTIVE

All the data files are in backup mode now


ALTER DATABASE END BACKUP; -- to exit from the backup mode.


select file#,status from v$backup;
FILE# STATUS
---------- ------------------
1 NOT ACTIVE
2 NOT ACTIVE
3 NOT ACTIVE
4 NOT ACTIVE

All the data files are out of backup mode now.

Read More

Receiving Error 'ORA-01041: internal error. hostdef extension doesn't exist.' on re-establishing a connection to Oracle.

You can receive the error message 'Error ORA-01041: internal error. hostdef extension doesn't exist' when attempting to re-establish a connection to Oracle with ERwin. This can happen for example when repeating the Complete Compare process.

Solution:
Locate the 'sqlnet.ora' file and set:

SQLNET.AUTHENTICATION_SERVICES = (NONE)  

Read More

ORA-01991: invalid password file

Oracle Version: 10gr1

OS: Windows 2003 Server

In development db i was getting below error message during database startup in mount stage.

SQL> startup
ORACLE instance started.
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
ORA-01991: invalid password file
'D:\oracle\product\10.1.0\Db_1\DATABASE\PWDspipr.ORA'
above error occured after i refreshed development db from production db.
Clause: I was restore production db hot backup (user mananged) to development db and re-create oracle services and forget to create password file. so everything is new but the password file is old one. that is why i was getting ABOVE error during startup database.
Solution: Re-create the password file.
1. Stop oracle services
D:\oracle\product\10.1.0\Db_1\BIN>net stop oracleserviceSPIPR
The OracleServiceSPIPR service is stopping.......
The OracleServiceSPIPR service was stopped successfully.
2. Re-create password file through ORAPWD utility
D:\oracle\product\10.1.0\Db_1\BIN>orapwd file=D:\oracle\product\10.1.0\Db_1\database\pwdSPIPR.ORA password=oracle entries=5 force=Y
NOTE: FORCE=Y will re-create password file and replace any existing passwordfile.
3. start oracle database services
D:\oracle\product\10.1.0\Db_1\BIN>net stART oracleserviceSPIPR
The OracleServiceSPIPR service is starting......
The OracleServiceSPIPR service was started successfully.
D:\oracle\product\10.1.0\Db_1\BIN>sqlplus / as sysdba
SQL*Plus: Release 10.1.0.2.0 - Production on Mon Aug 18 19:11:19 2008
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
[output cut]
Database mounted.
Database opened.

Read More

Removing an Automatic Storage Management Instance

To remove an Automatic Storage Management (ASM) instance running in the Oracle home after the database has been removed, perform the following steps:

1. At the Windows command prompt, set the ORACLE_SID environment variable to the SID for the Automatic Storage Management instance. For example:
   

   SYSTEM_DRIVE:\> set ORACLE_SID=+ASM
   
   

2. Start SQL*Plus and connect to the Automatic Storage Management instance as the SYS user:
   

   SYSTEM_DRIVE:\> sqlplus sys/sys_password as sysdba
   
   

3. Enter the following command to determine whether any Oracle database instances are using the Automatic Storage Management instance:
   

   SQL> SELECT INSTANCE_NAME FROM V$ASM_CLIENT;
   
   

   This command lists all of the database instances that are using this Automatic Storage Management instance. This command only lists database instances that are running. It is possible that other instances are associated with the Automatic Storage Management instance, but they are not currently running.
   If you removed a database from this Oracle home but the output from the command shows that this Automatic Storage Management instance is supporting a database instance in another Oracle home, do not remove the Automatic Storage Management instance or the Oracle home.
   
4. If there are no database instances associated with this Automatic Storage Management instance, drop the disk group associated with this instance.
   
   Note:

   Dropping the Automatic Storage Management disk group makes the disk device available for use with another Automatic Storage Management instance, if required. However, all data in the disk group is lost. Make sure that no other database instance requires any data from this disk group before you drop it.
   1. Identify the disk groups associated with the Automatic Storage Management instance:
      

      SQL> SELECT NAME FROM V$ASM_DISKGROUP;
      
      

   2. For each disk group that you want to delete, enter a command similar to the following:
      

      SQL> DROP DISKGROUP disk_group_name INCLUDING CONTENTS;
      
      

5. Shut down the Automatic Storage Management instance and exit SQL*Plus:
   

   SQL> SHUTDOWN
   SQL> EXIT
   
   

6. At the command prompt, enter the following command to remove the Automatic Storage Management service:
   

   ORADIM -DELETE -ASMSID +ASM 

   Removing the Oracle Net Service Registry Key
   To remove only the Oracle Net Service registry entry (if it exists):
   
7. Log in as a member of the Administrators group.
   
8. Make sure that you have stopped Oracle services by following the instructions in the "Stopping Oracle Services" section.
   
9. From a command prompt, enter the following command:
   

   SYSTEM_DRIVE:\> regedit
   
   

10. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete the OracleHOME_NAMETNSListener registry entry. Oracle Universal Installer automatically deletes all other Oracle Net services.
    
11. Exit the registry editor.
    
12. Restart your computer.
    
    
    
    Removing All Oracle Registry Keys
    Caution:

    These instructions remove all Oracle components, services, and registry entries from your computer. Use extreme care when removing registry entries. Removing incorrect entries can break your system. Do not delete any database files under ORACLE_BASE\ORACLE_HOME\DB_NAME until you have completed these instructions.
    To remove all Oracle registry keys from a computer:
    
13. Log in as a member of the Administrators group.
    
14. Make sure that you have stopped Oracle services by following the instructions in the "Stopping Oracle Services" section.
    
15. Start the registry editor at the command prompt:
    

    SYSTEM_DRIVE:\> regedit
    
    

16. Go to HKEY_CLASSES_ROOT.
    
17. Delete keys that begin with Ora, Oracle, Orcl, or EnumOra.
    This collection of keys includes those that begin with the following:
    
    • EnumOraHomes
      
    • OracleConfig
      
    • OracleDatabase
      
    • OracleHome
      
    • OracleInProcServer
      
    • OracleProcess
      
    • ORADC
      
    • ORAMMCCFG10
      
    • ORAMMCPMON10
      
    • OraOLEDB
      
    • OraPerfMon
      
    • ORCLMMC
      
    • ORCLSSO
      
18. Go to HKEY_CURRENT_USER.
    
19. Delete the ORACLE key.
    
20. Go to HKEY_CURRENT_USER\Software.
    
21. Delete all Oracle keys, including Oracle-HOME_NAME entries under: Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\Programs.
    
22. Go to HKEY_LOCAL_MACHINE\SOFTWARE and search for the ORACLE group key.
    Select ORACLE and note the value of the inst_loc key. This is the location of Oracle Universal Installer. The default location is c:\Program Files\Oracle\Inventory. If this value is different, make a note of it so that you can delete it later.
    
23. Delete the ORACLE Group key.
    
24. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC.
    
25. Expand all the subkeys under ODBC and remove any Oracle-related ODBC driver keys, except for the Microsoft ODBC for Oracle key.
    For example, the ODBC\ODBCINST.INI directory lists keys for each Oracle home.
    
26. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services.
    
27. Delete all keys under this branch that begin with Oracle or OraWeb.
    
28. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ Eventlog\Application.
    
29. Delete all keys under this branch that begin with Oracle.
    
30. Exit the registry editor.
    
31. Restart your computer.
    

6.3.3.3 Updating the System Variable Path

Check the Path environmental variable and remove any Oracle entries.

1. Open System from the Control Panel.
   
2. In the System Properties dialog box, click the Advanced tab, then click the Environment Variables button.
   
3. Select the system variable Path and edit the Path variable to remove any Oracle entries.
   For example, remove Oracle entries that contain ORACLE_BASE\ORACLE_HOME in the Path variable. You may see a Path variable that contains entries similar to the following:
   

   C:\oracle\products\10.2.0\db_1\bin;C:\oracle\products\10.2.0\db_1\jre\

   1.4.2\bin\client;C:\oracle\products\10.2.0\db_1\jre\1.4.2\bin
   
   

   If the JRE path was installed by Oracle, remove it.
   
4. If there is a CLASSPATH variable that was set for Oracle, delete it.
   
5. If there are any other Oracle variables set, remove them: ORACLE_HOME, ORACLE_SID, TNS_ADMIN, JSERV, or WV_GATEWAY_CFG.
   
6. Save your changes and then exit the Control Panel.
   

6.3.3.4 Removing Oracle from the Start Menu

Check the Start menu for any Oracle entries and remove them.
Follow these steps:

1. Select Start, then Programs, and then Oracle - HOME_NAME.
   
2. Right-click Oracle - HOME_NAME, and from the menu, select Delete.
   

You can also remove Oracle menu entries by using the following method:

1. Right-click the Start button to display the pop-up menu.
   
2. Select the Explore All Users option.
   
3. Under Documents and Settings, expand the \Start Menu\Programs folder.
   
4. Right-click and delete the Oracle - HOME_NAME folder.
   

6.3.3.5 Removing Oracle Directories

After removing all Oracle registry keys and restarting the computer, delete any existing Oracle directories and files.
Use My Computer or Windows Explorer to delete the following directories:

1. Delete the SYSTEM_DRIVE:\Program Files\Oracle directory.
   
2. Delete all ORACLE_BASE directories on your hard drive.
   
3. If Oracle Universal Installer was installed in a location other than the default, delete this directory.
   
4. Remove any Oracle temporary directory files from SYSTEM_DRIVE:\Documents and Settings\user_name\Local Settings\Temp

Read More

The value of the environment variable PATH is more than 1023 characters. This value cannot be set.

Generally we see this error, when PATH variable  reaches it’s character limit of 1023.
We can avoid this issue by editing PATH variable and removing unwanted characters or paths ( But make sure you are not going to remove any system related paths like %SYSTEMROOT% etc.. )
Navigation: My Computer –> right click –> properties –> Advanced –> Environment Variables –> Select PATH in system Variables.  Then remove unwanted variables.

Once done with the above steps, press “retry” button to continue with the installation.

Read More

Josh Cell Softwares: Advanced Tokens Manager - The Activation Backup So...

Josh Cell Softwares: Advanced Tokens Manager - The Activation Backup So...: "The Activation Backup for Windows and Office has never been easier"

Read More