Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

accessing the database

deepsadeepsa Member Posts: 9
Hi,

Whenever I create a database in Oracle 8i I get access to the database as a user as well as a admin.
But when i shutdown my system and restart it again , I cannot connect to the database I created and granted access to.
The Start Service also does not respond.
I cannot access my database so I have to create one again and then start the job from the scratch.
My system configuration is:
Pentinum IV 3.00Ghz(Single User System)
Operating System -> Windows XP Professional
Oracle 8i is installed on my computer.

Comments

  • lucky_melucky_me Member Posts: 39
    : Hi,
    :
    : Whenever I create a database in Oracle 8i I get access to the database as a user as well as a admin.
    : But when i shutdown my system and restart it again , I cannot connect to the database I created and granted access to.
    : The Start Service also does not respond.
    : I cannot access my database so I have to create one again and then start the job from the scratch.
    : My system configuration is:
    : Pentinum IV 3.00Ghz(Single User System)
    : Operating System -> Windows XP Professional
    : Oracle 8i is installed on my computer.
    :

    hi deepsa,
    did you tried the default user like scott and system?These accounts are working or not? First clear me on this then i'll suggest you something else.


  • deepsadeepsa Member Posts: 9
    : : Hi,
    : :
    : : Whenever I create a database in Oracle 8i I get access to the database as a user as well as a admin.
    : : But when i shutdown my system and restart it again , I cannot connect to the database I created and granted access to.
    : : The Start Service also does not respond.
    : : I cannot access my database so I have to create one again and then start the job from the scratch.
    : : My system configuration is:
    : : Pentinum IV 3.00Ghz(Single User System)
    : : Operating System -> Windows XP Professional
    : : Oracle 8i is installed on my computer.
    : :
    :
    : hi deepsa,
    : did you tried the default user like scott and system?These accounts are working or not? First clear me on this then i'll suggest you something else.
    :
    hello Unknown Friend,

    As per your Question goes I cannot login with the scott but with the system I can !
    I can login with the INTERNAL account and password oracle.
    It gives me a idle oracle instance. But I can only connect to my database my issusing the following command :
    STARTUP PFILE=E:OracleADMINemployeepfileinit.ora;
    Then only I can connect to the employee database as a database user named DEEPENDRA.
    After that I have to login again as INTERNAL and issue the following command
    SHUTDOWN NORMAL;
    To shut the database service.
    But I wanna have automatic starting of service and mounting of database as I start my system. That doesn't happens.

    Thanking U,
    Take Care
    Bye
  • lucky_melucky_me Member Posts: 39
    Hi Deepsa,
    As far as I understand that it's your configuration problem.
    Check out your LISTENER.ORA file and TNSNAMES.ora files.In Listener.ora there should be following configuration information...

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = [your computer name])(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = E:oracleora92)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = EMPLOYEE)
    (ORACLE_HOME = E:oracleora92)
    (SID_NAME = EMPLOYEE)
    )
    )

    IF it's not then configure it as above.Now check your TNSNAMES.ORA and include the following statements...
    EMPLOYEE =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = [your computer name])(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = EMPLOYEE)
    )
    )

    By default the port name for it is 1521, check what's your port number.

    try these and let me know whether it worked or not.

    One more thing, check your running services (control pannel>administrative tool> services) whether your database service named as OracleServiceEMPLOYEE is running or not.if not then run it mannually and try to reconnect to the database.

    Let me know whether it helped or not.
    Once this kinda problem happened with me also , i tried the above and it worked let's see it work with you or not.:-)

    I forgot to mention 1 thing, check your init.ora file that contains instance_name=EMPLOYEE or not.

    Good luck and Bye
    Lucky




    : hello Unknown Friend,
    :
    : As per your Question goes I cannot login with the scott but with the system I can !
    : I can login with the INTERNAL account and password oracle.
    : It gives me a idle oracle instance. But I can only connect to my database my issusing the following command :
    : STARTUP PFILE=E:OracleADMINemployeepfileinit.ora;
    : Then only I can connect to the employee database as a database user named DEEPENDRA.
    : After that I have to login again as INTERNAL and issue the following command
    : SHUTDOWN NORMAL;
    : To shut the database service.
    : But I wanna have automatic starting of service and mounting of database as I start my system. That doesn't happens.
    :
    : Thanking U,
    : Take Care
    : Bye
    :

  • deepsadeepsa Member Posts: 9
    : Hi Deepsa,
    : As far as I understand that it's your configuration problem.
    : Check out your LISTENER.ORA file and TNSNAMES.ora files.In Listener.ora there should be following configuration information...
    :
    : LISTENER =
    : (DESCRIPTION_LIST =
    : (DESCRIPTION =
    : (ADDRESS_LIST =
    : (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    : )
    : (ADDRESS_LIST =
    : (ADDRESS = (PROTOCOL = TCP)(HOST = [your computer name])(PORT = 1521))
    : )
    : )
    : )
    :
    : SID_LIST_LISTENER =
    : (SID_LIST =
    : (SID_DESC =
    : (SID_NAME = PLSExtProc)
    : (ORACLE_HOME = E:oracleora92)
    : (PROGRAM = extproc)
    : )
    : (SID_DESC =
    : (GLOBAL_DBNAME = EMPLOYEE)
    : (ORACLE_HOME = E:oracleora92)
    : (SID_NAME = EMPLOYEE)
    : )
    : )
    :
    : IF it's not then configure it as above.Now check your TNSNAMES.ORA and include the following statements...
    : EMPLOYEE =
    : (DESCRIPTION =
    : (ADDRESS_LIST =
    : (ADDRESS = (PROTOCOL = TCP)(HOST = [your computer name])(PORT = 1521))
    : )
    : (CONNECT_DATA =
    : (SERVER = DEDICATED)
    : (SERVICE_NAME = EMPLOYEE)
    : )
    : )
    :
    : By default the port name for it is 1521, check what's your port number.
    :
    : try these and let me know whether it worked or not.
    :
    : One more thing, check your running services (control pannel>administrative tool> services) whether your database service named as OracleServiceEMPLOYEE is running or not.if not then run it mannually and try to reconnect to the database.
    :
    : Let me know whether it helped or not.
    : Once this kinda problem happened with me also , i tried the above and it worked let's see it work with you or not.:-)
    :
    : I forgot to mention 1 thing, check your init.ora file that contains instance_name=EMPLOYEE or not.
    :
    : Good luck and Bye
    : Lucky
    :
    :
    :
    :
    : : hello Unknown Friend,
    : :
    : : As per your Question goes I cannot login with the scott but with the system I can !
    : : I can login with the INTERNAL account and password oracle.
    : : It gives me a idle oracle instance. But I can only connect to my database my issusing the following command :
    : : STARTUP PFILE=E:OracleADMINemployeepfileinit.ora;
    : : Then only I can connect to the employee database as a database user named DEEPENDRA.
    : : After that I have to login again as INTERNAL and issue the following command
    : : SHUTDOWN NORMAL;
    : : To shut the database service.
    : : But I wanna have automatic starting of service and mounting of database as I start my system. That doesn't happens.
    : :
    : : Thanking U,
    : : Take Care
    : : Bye
    : :
    :
    :

    Hi Lucky,

    I applied your solution but didn't got fruitful results. Here is my listing :-

    This is my LISTERNER.ORA file status.

    # E:ORACLEORA81NETWORKADMINLISTENER.ORA Configuration File:E:OracleOra81
    etworkadminlistener.ora
    # Generated by Oracle Net8 Assistant

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = sanswas-cde5878)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = E:OracleOra81)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = employee)
    (ORACLE_HOME = E:OracleOra81)
    (SID_NAME = EMPLOYEE)
    )
    )


    This is my TNSNAMES.ORA file status.

    # E:ORACLEORA81NETWORKADMINTNSNAMES.ORA Configuration File:E:OracleOra81
    etworkadmin nsnames.ora
    # Generated by Oracle Net8 Assistant

    EMPLOYEE =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = sanswas-cde5878)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = employee)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )


    Special Area:- (TNSNAMES.ORA)
    /*
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = employee)
    )
    */

    This caused me problem at the startup of the system with some Win32 services not starting up. So I have to remove the line

    SERVER = DEDICATED (it was on present in the original configuration file also).

    My init.ora file contains the line instance_name = EMPLOYEE at the starting.

    Also I saw the Control Panel -> Administrative Tools -> Services. where I found these services with the following status:-


    Service Name Status Startup Type

    OracleOraHome81Agent Started Automatic
    OracleOraHome81ClientCache Started Automatic
    OracleOraHome81DataGatherer Started Automatic
    OracleOraHome81TNSListener Started Automatic
    OracleServiceEMPLOYEE Starting Automatic
    OracleWebAssistant0 Started Automatic


    I turned this service "OracleServiceEMPLOYEE" as "STARTUP TYPE -> MANUAL" and started it on my known but it takes time and

    does not get started.

    Also Oracle Administration Assistant for Windows NT show the database EMPLOYEE but when I say start service EMPLOYEE it shows

    me a error Message having text as:-

    FAILED TO START SERVICE. ERROR (0X80070420)

    Your Solution didn't work for me. If you want to have complete details of my Oracle Installation and my machine I can send it

    to you on your request maybe that will tell you about the right problem and the right solution.

    Thank You
    Take Care
    Bye!!


  • lucky_melucky_me Member Posts: 39
    Hi Deepsa,
    Your Error (0X80070420) is a DNS error.Actually oracle is not tested at all on windows XP only 9i + has tested on XP , hence you are getting the problem.Try to install oracle 9i on your XP if you can, if it's not possible then try this one..... (I hope it'll help)

    Change the start-up options to "Manual" for all the 5 services listed below(OracleOraHome81TNSListener,OracleOraHome81DataGatherer,OracleOraHome81ClientCache,OracleOraHome81Agent and OracleWebAssistant0). Also change the OracleServiceEMPLOYEE service to Manual, then restart your system.

    Then once the system restarts, start the services one by one in the above listed order (you may get some problems when you changed the order. But don't panic and try to start all services manually). Then start your OracleServiceEMPLOYEE. It will come out with a dialouge box saying that "Unable to start" and the status will be "Starting".

    Go to the Task Manager, Kill the one and only ORACLE process running. Come back again and restart the OracleServiceEMPLOYEE service. Eventhough the status shown will be 'Starting' you will be able to start the service.

    I hope you'll solve your problem this time.
    Good Luck.
    Lucky





    : Hi Lucky,
    :
    : I applied your solution but didn't got fruitful results. Here is my listing :-
    :
    : This is my LISTERNER.ORA file status.
    :
    : # E:ORACLEORA81NETWORKADMINLISTENER.ORA Configuration File:E:OracleOra81
    etworkadminlistener.ora
    : # Generated by Oracle Net8 Assistant
    :
    : LISTENER =
    : (DESCRIPTION_LIST =
    : (DESCRIPTION =
    : (ADDRESS_LIST =
    : (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    : )
    : (ADDRESS_LIST =
    : (ADDRESS = (PROTOCOL = TCP)(HOST = sanswas-cde5878)(PORT = 1521))
    : )
    : )
    : )
    :
    : SID_LIST_LISTENER =
    : (SID_LIST =
    : (SID_DESC =
    : (SID_NAME = PLSExtProc)
    : (ORACLE_HOME = E:OracleOra81)
    : (PROGRAM = extproc)
    : )
    : (SID_DESC =
    : (GLOBAL_DBNAME = employee)
    : (ORACLE_HOME = E:OracleOra81)
    : (SID_NAME = EMPLOYEE)
    : )
    : )
    :
    :
    : This is my TNSNAMES.ORA file status.
    :
    : # E:ORACLEORA81NETWORKADMINTNSNAMES.ORA Configuration File:E:OracleOra81
    etworkadmin nsnames.ora
    : # Generated by Oracle Net8 Assistant
    :
    : EMPLOYEE =
    : (DESCRIPTION =
    : (ADDRESS_LIST =
    : (ADDRESS = (PROTOCOL = TCP)(HOST = sanswas-cde5878)(PORT = 1521))
    : )
    : (CONNECT_DATA =
    : (SERVICE_NAME = employee)
    : )
    : )
    :
    : EXTPROC_CONNECTION_DATA =
    : (DESCRIPTION =
    : (ADDRESS_LIST =
    : (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    : )
    : (CONNECT_DATA =
    : (SID = PLSExtProc)
    : (PRESENTATION = RO)
    : )
    : )
    :
    :
    : Special Area:- (TNSNAMES.ORA)
    : /*
    : (CONNECT_DATA =
    : (SERVER = DEDICATED)
    : (SERVICE_NAME = employee)
    : )
    : */
    :
    : This caused me problem at the startup of the system with some Win32 services not starting up. So I have to remove the line
    :
    : SERVER = DEDICATED (it was on present in the original configuration file also).
    :
    : My init.ora file contains the line instance_name = EMPLOYEE at the starting.
    :
    : Also I saw the Control Panel -> Administrative Tools -> Services. where I found these services with the following status:-
    :
    :
    : Service Name Status Startup Type
    :
    : OracleOraHome81Agent Started Automatic
    : OracleOraHome81ClientCache Started Automatic
    : OracleOraHome81DataGatherer Started Automatic
    : OracleOraHome81TNSListener Started Automatic
    : OracleServiceEMPLOYEE Starting Automatic
    : OracleWebAssistant0 Started Automatic
    :
    :
    : I turned this service "OracleServiceEMPLOYEE" as "STARTUP TYPE -> MANUAL" and started it on my known but it takes time and
    :
    : does not get started.
    :
    : Also Oracle Administration Assistant for Windows NT show the database EMPLOYEE but when I say start service EMPLOYEE it shows
    :
    : me a error Message having text as:-
    :
    : FAILED TO START SERVICE. ERROR (0X80070420)
    :
    : Your Solution didn't work for me. If you want to have complete details of my Oracle Installation and my machine I can send it
    :
    : to you on your request maybe that will tell you about the right problem and the right solution.
    :
    : Thank You
    : Take Care
    : Bye!!
    :
    :
    :

  • deepsadeepsa Member Posts: 9
    : Hi Deepsa,
    : Your Error (0X80070420) is a DNS error.Actually oracle is not tested at all on windows XP only 9i + has tested on XP , hence you are getting the problem.Try to install oracle 9i on your XP if you can, if it's not possible then try this one..... (I hope it'll help)
    :
    : Change the start-up options to "Manual" for all the 5 services listed below(OracleOraHome81TNSListener,OracleOraHome81DataGatherer,OracleOraHome81ClientCache,OracleOraHome81Agent and OracleWebAssistant0). Also change the OracleServiceEMPLOYEE service to Manual, then restart your system.
    :
    : Then once the system restarts, start the services one by one in the above listed order (you may get some problems when you changed the order. But don't panic and try to start all services manually). Then start your OracleServiceEMPLOYEE. It will come out with a dialouge box saying that "Unable to start" and the status will be "Starting".
    :
    : Go to the Task Manager, Kill the one and only ORACLE process running. Come back again and restart the OracleServiceEMPLOYEE service. Eventhough the status shown will be 'Starting' you will be able to start the service.
    :
    : I hope you'll solve your problem this time.
    : Good Luck.
    : Lucky
    :
    :
    :
    :
    :
    : : Hi Lucky,
    : :
    : : I applied your solution but didn't got fruitful results. Here is my listing :-
    : :
    : : This is my LISTERNER.ORA file status.
    : :
    : : # E:ORACLEORA81NETWORKADMINLISTENER.ORA Configuration File:E:OracleOra81
    etworkadminlistener.ora
    : : # Generated by Oracle Net8 Assistant
    : :
    : : LISTENER =
    : : (DESCRIPTION_LIST =
    : : (DESCRIPTION =
    : : (ADDRESS_LIST =
    : : (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    : : )
    : : (ADDRESS_LIST =
    : : (ADDRESS = (PROTOCOL = TCP)(HOST = sanswas-cde5878)(PORT = 1521))
    : : )
    : : )
    : : )
    : :
    : : SID_LIST_LISTENER =
    : : (SID_LIST =
    : : (SID_DESC =
    : : (SID_NAME = PLSExtProc)
    : : (ORACLE_HOME = E:OracleOra81)
    : : (PROGRAM = extproc)
    : : )
    : : (SID_DESC =
    : : (GLOBAL_DBNAME = employee)
    : : (ORACLE_HOME = E:OracleOra81)
    : : (SID_NAME = EMPLOYEE)
    : : )
    : : )
    : :
    : :
    : : This is my TNSNAMES.ORA file status.
    : :
    : : # E:ORACLEORA81NETWORKADMINTNSNAMES.ORA Configuration File:E:OracleOra81
    etworkadmin nsnames.ora
    : : # Generated by Oracle Net8 Assistant
    : :
    : : EMPLOYEE =
    : : (DESCRIPTION =
    : : (ADDRESS_LIST =
    : : (ADDRESS = (PROTOCOL = TCP)(HOST = sanswas-cde5878)(PORT = 1521))
    : : )
    : : (CONNECT_DATA =
    : : (SERVICE_NAME = employee)
    : : )
    : : )
    : :
    : : EXTPROC_CONNECTION_DATA =
    : : (DESCRIPTION =
    : : (ADDRESS_LIST =
    : : (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    : : )
    : : (CONNECT_DATA =
    : : (SID = PLSExtProc)
    : : (PRESENTATION = RO)
    : : )
    : : )
    : :
    : :
    : : Special Area:- (TNSNAMES.ORA)
    : : /*
    : : (CONNECT_DATA =
    : : (SERVER = DEDICATED)
    : : (SERVICE_NAME = employee)
    : : )
    : : */
    : :
    : : This caused me problem at the startup of the system with some Win32 services not starting up. So I have to remove the line
    : :
    : : SERVER = DEDICATED (it was on present in the original configuration file also).
    : :
    : : My init.ora file contains the line instance_name = EMPLOYEE at the starting.
    : :
    : : Also I saw the Control Panel -> Administrative Tools -> Services. where I found these services with the following status:-
    : :
    : :
    : : Service Name Status Startup Type
    : :
    : : OracleOraHome81Agent Started Automatic
    : : OracleOraHome81ClientCache Started Automatic
    : : OracleOraHome81DataGatherer Started Automatic
    : : OracleOraHome81TNSListener Started Automatic
    : : OracleServiceEMPLOYEE Starting Automatic
    : : OracleWebAssistant0 Started Automatic
    : :
    : :
    : : I turned this service "OracleServiceEMPLOYEE" as "STARTUP TYPE -> MANUAL" and started it on my known but it takes time and
    : :
    : : does not get started.
    : :
    : : Also Oracle Administration Assistant for Windows NT show the database EMPLOYEE but when I say start service EMPLOYEE it shows
    : :
    : : me a error Message having text as:-
    : :
    : : FAILED TO START SERVICE. ERROR (0X80070420)
    : :
    : : Your Solution didn't work for me. If you want to have complete details of my Oracle Installation and my machine I can send it
    : :
    : : to you on your request maybe that will tell you about the right problem and the right solution.
    : :
    : : Thank You
    : : Take Care
    : : Bye!!
    : :
    : :
    : :
    :
    : HI Lucky,

    The solution didn't work for me. But now I am sure I will not be working Oracle on Windows XP (SP2). I will now be installing it into Windows 2000 Professional which I have installed earlier in a another hard disk. Will Oracle 8i cause any problem in Windows 2000 professional and can I be able to migrate my database employee in Windows 2000 Oracle installation. Please answer this query.

    Thanks for Your help I have learnt a little bit about the internals of Oracle know.
    Take Care
    Bye!
    Deepsa

  • lucky_melucky_me Member Posts: 39
    : : Hi Deepsa,
    : : Your Error (0X80070420) is a DNS error.Actually oracle is not tested at all on windows XP only 9i + has tested on XP , hence you are getting the problem.Try to install oracle 9i on your XP if you can, if it's not possible then try this one..... (I hope it'll help)
    : :
    : : Change the start-up options to "Manual" for all the 5 services listed below(OracleOraHome81TNSListener,OracleOraHome81DataGatherer,OracleOraHome81ClientCache,OracleOraHome81Agent and OracleWebAssistant0). Also change the OracleServiceEMPLOYEE service to Manual, then restart your system.
    : :
    : : Then once the system restarts, start the services one by one in the above listed order (you may get some problems when you changed the order. But don't panic and try to start all services manually). Then start your OracleServiceEMPLOYEE. It will come out with a dialouge box saying that "Unable to start" and the status will be "Starting".
    : :
    : : Go to the Task Manager, Kill the one and only ORACLE process running. Come back again and restart the OracleServiceEMPLOYEE service. Eventhough the status shown will be 'Starting' you will be able to start the service.
    : :
    : : I hope you'll solve your problem this time.
    : : Good Luck.
    : : Lucky
    : :
    : :
    : :
    : :
    : :
    : : : Hi Lucky,
    : : :
    : : : I applied your solution but didn't got fruitful results. Here is my listing :-
    : : :
    : : : This is my LISTERNER.ORA file status.
    : : :
    : : : # E:ORACLEORA81NETWORKADMINLISTENER.ORA Configuration File:E:OracleOra81
    etworkadminlistener.ora
    : : : # Generated by Oracle Net8 Assistant
    : : :
    : : : LISTENER =
    : : : (DESCRIPTION_LIST =
    : : : (DESCRIPTION =
    : : : (ADDRESS_LIST =
    : : : (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    : : : )
    : : : (ADDRESS_LIST =
    : : : (ADDRESS = (PROTOCOL = TCP)(HOST = sanswas-cde5878)(PORT = 1521))
    : : : )
    : : : )
    : : : )
    : : :
    : : : SID_LIST_LISTENER =
    : : : (SID_LIST =
    : : : (SID_DESC =
    : : : (SID_NAME = PLSExtProc)
    : : : (ORACLE_HOME = E:OracleOra81)
    : : : (PROGRAM = extproc)
    : : : )
    : : : (SID_DESC =
    : : : (GLOBAL_DBNAME = employee)
    : : : (ORACLE_HOME = E:OracleOra81)
    : : : (SID_NAME = EMPLOYEE)
    : : : )
    : : : )
    : : :
    : : :
    : : : This is my TNSNAMES.ORA file status.
    : : :
    : : : # E:ORACLEORA81NETWORKADMINTNSNAMES.ORA Configuration File:E:OracleOra81
    etworkadmin nsnames.ora
    : : : # Generated by Oracle Net8 Assistant
    : : :
    : : : EMPLOYEE =
    : : : (DESCRIPTION =
    : : : (ADDRESS_LIST =
    : : : (ADDRESS = (PROTOCOL = TCP)(HOST = sanswas-cde5878)(PORT = 1521))
    : : : )
    : : : (CONNECT_DATA =
    : : : (SERVICE_NAME = employee)
    : : : )
    : : : )
    : : :
    : : : EXTPROC_CONNECTION_DATA =
    : : : (DESCRIPTION =
    : : : (ADDRESS_LIST =
    : : : (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    : : : )
    : : : (CONNECT_DATA =
    : : : (SID = PLSExtProc)
    : : : (PRESENTATION = RO)
    : : : )
    : : : )
    : : :
    : : :
    : : : Special Area:- (TNSNAMES.ORA)
    : : : /*
    : : : (CONNECT_DATA =
    : : : (SERVER = DEDICATED)
    : : : (SERVICE_NAME = employee)
    : : : )
    : : : */
    : : :
    : : : This caused me problem at the startup of the system with some Win32 services not starting up. So I have to remove the line
    : : :
    : : : SERVER = DEDICATED (it was on present in the original configuration file also).
    : : :
    : : : My init.ora file contains the line instance_name = EMPLOYEE at the starting.
    : : :
    : : : Also I saw the Control Panel -> Administrative Tools -> Services. where I found these services with the following status:-
    : : :
    : : :
    : : : Service Name Status Startup Type
    : : :
    : : : OracleOraHome81Agent Started Automatic
    : : : OracleOraHome81ClientCache Started Automatic
    : : : OracleOraHome81DataGatherer Started Automatic
    : : : OracleOraHome81TNSListener Started Automatic
    : : : OracleServiceEMPLOYEE Starting Automatic
    : : : OracleWebAssistant0 Started Automatic
    : : :
    : : :
    : : : I turned this service "OracleServiceEMPLOYEE" as "STARTUP TYPE -> MANUAL" and started it on my known but it takes time and
    : : :
    : : : does not get started.
    : : :
    : : : Also Oracle Administration Assistant for Windows NT show the database EMPLOYEE but when I say start service EMPLOYEE it shows
    : : :
    : : : me a error Message having text as:-
    : : :
    : : : FAILED TO START SERVICE. ERROR (0X80070420)
    : : :
    : : : Your Solution didn't work for me. If you want to have complete details of my Oracle Installation and my machine I can send it
    : : :
    : : : to you on your request maybe that will tell you about the right problem and the right solution.
    : : :
    : : : Thank You
    : : : Take Care
    : : : Bye!!
    : : :
    : : :
    : : :
    : :
    : : HI Lucky,
    :
    : The solution didn't work for me. But now I am sure I will not be working Oracle on Windows XP (SP2). I will now be installing it into Windows 2000 Professional which I have installed earlier in a another hard disk. Will Oracle 8i cause any problem in Windows 2000 professional and can I be able to migrate my database employee in Windows 2000 Oracle installation. Please answer this query.
    :
    : Thanks for Your help I have learnt a little bit about the internals of Oracle know.
    : Take Care
    : Bye!
    : Deepsa
    :
    :


    It'll work fine on windows 2000.
    best of luck.
    bye
    lucky


  • papu_cpapu_c Member Posts: 24
    Hey
    I installed Ora-8i on win2k pro

    It worked fine

    I also work Ora on WIN xp;
    But eveery time I start my machine
    I have to open SQLPLUS
    type :Username:internal
    password:oracle:
    the it connects to idle instance
    then type :startup open
    then it connect normamlly:
    thats all
    But in win2k there is no problem
  • Edward_HillsEdward_Hills Member Posts: 1
    Hello Friend,
    Wow i see you very good in oracle, i will like to share my view with you, if you are really Guru Pm me back.
    Thanks
    Edward

    : : : Hi,
    : : :
    : : : Whenever I create a database in Oracle 8i I get access to the database as a user as well as a admin.
    : : : But when i shutdown my system and restart it again , I cannot connect to the database I created and granted access to.
    : : : The Start Service also does not respond.
    : : : I cannot access my database so I have to create one again and then start the job from the scratch.
    : : : My system configuration is:
    : : : Pentinum IV 3.00Ghz(Single User System)
    : : : Operating System -> Windows XP Professional
    : : : Oracle 8i is installed on my computer.
    : : :
    : :
    : : hi deepsa,
    : : did you tried the default user like scott and system?These accounts are working or not? First clear me on this then i'll suggest you something else.
    : :
    : hello Unknown Friend,
    :
    : As per your Question goes I cannot login with the scott but with the system I can !
    : I can login with the INTERNAL account and password oracle.
    : It gives me a idle oracle instance. But I can only connect to my database my issusing the following command :
    : STARTUP PFILE=E:OracleADMINemployeepfileinit.ora;
    : Then only I can connect to the employee database as a database user named DEEPENDRA.
    : After that I have to login again as INTERNAL and issue the following command
    : SHUTDOWN NORMAL;
    : To shut the database service.
    : But I wanna have automatic starting of service and mounting of database as I start my system. That doesn't happens.
    :
    : Thanking U,
    : Take Care
    : Bye
    :

Sign In or Register to comment.